Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet.
I have been able to go from the master sheet to the correct project sheet and update information in the correct cell of the project sheet, but I need to go the other way. When information is input into a certain cell, it will be updated in the master sheet in the correct row and column.
The project sheets are saved with the same project name that appears on the master sheet and I also have the project name in a unique cell (top/right) in all project sheets.
Thank you for your help
Help Article Resources
Check out the Formula Handbook template!