Apologies if this question has been posed before, however I have not been able to find a solution by browsing through the community (there is also a good chance I'm approaching the problem incorrectly). I have started building a master project sheet that contains several columns with project related information. I would like to pull some of these columns into a second sheet in order to create a production schedule. I have had success in doing this by using Index/Match. For example, in the screenshots below, I have pulled the Base Beer column from the "Sour Project Release Table v4" sheet into the "2021 Brew Production Table v4" sheet using =INDEX({Sour Project Release Table v4 Base Beer}, MATCH([Project Index #]@row, {Sour Project Release Table v4 Project Index}, 0)). In the "2021 Brew Production Table v4" sheet, I have added several columns so that new information can be added (Batch, Brew Date, Transfer Date, Brew Index #). I would like to be able to make changes to the master project sheet "Sour Project Release Table v4" and have the changes reflect in the "2021 Brew Production Table v4" sheet. However, if I need to insert a new row into the "Sour Project Release Table v4" sheet, it will add the appropriate row to the "2021 Brew Production Table v4" sheet but it will not add an additional row to the manually entered columns (Batch, Brew Date, Transfer Date), causing the data to be offset by one row. I am unsure of how to solve this problem, and if anyone has any insight it would be greatly appreciated.
Sheets before row insertion:
Sheets after row insertion:
Thanks in advance,
Norm
