Hello!
First time posting here, though have come often searching for help.
This time I couldn't find it just using the search engine.
I hope someone can help.
I have one master excel spreadsheet displaying jobs daily. Every day has a new tab. I have 5 other files that are distributed to managers of different teams who will then input the number of workers daily and then email me the data. Every day there is a new page for each of their files. I need to keep a cumulative total of all of this data, merged into one file, as well as the back data from previous days. One small catch, after I submit one day's data, it cannot be changed, so I need to "fix" the link from previous days, just in case someone messes with old data in one of the 5 sub files. Is this all possible in Excel? If so, how? (and am I making myself clear?)
Would appreciate any help on this!
Cheers
First time posting here, though have come often searching for help.
This time I couldn't find it just using the search engine.
I hope someone can help.
I have one master excel spreadsheet displaying jobs daily. Every day has a new tab. I have 5 other files that are distributed to managers of different teams who will then input the number of workers daily and then email me the data. Every day there is a new page for each of their files. I need to keep a cumulative total of all of this data, merged into one file, as well as the back data from previous days. One small catch, after I submit one day's data, it cannot be changed, so I need to "fix" the link from previous days, just in case someone messes with old data in one of the 5 sub files. Is this all possible in Excel? If so, how? (and am I making myself clear?)
Would appreciate any help on this!
Cheers
