How to loop back information to source sheet.
Is there a way to push/copy cell information from one sheet to the source sheet. We have a master record with the master data for all projects. Each project then collects some of the information from the master record including approved budget based on the project ID column to the project template sheets. The project then consumes time and resources generating a cost/allocated budget in the project sheet. What we would like to do is to bring back the allocated budget to the master data sheet and to the correct project ID
As projects are added continuously with and new project ID´s and corresponding project sheets we can not hard code a cell reference but would rather for the project sheet to push the allocated budget from the project sheet to the master record sheet as that sheet will always be on the same path.
Hope this makes sense, if not please let me know and i will try to explain mer elaborate.