t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi,
I have many spreadsheets that all have an employee list of some sort,
Whenever I create a new spreadsheet I am generally creating a whole new staff list sheet in that specific spreadsheet.
If I have to update staff details I usually need to do it across multiple spreadsheets.
My question is:
Does anyone know of a way I can have a main "Staff Data" spreadsheet which once updated I can just overwrite the current one within the other spreadsheets and have formulas etc use this new sheet and not error with #REF when the new data is imported.
My current thoughts for this project are to merge various spreadsheets as necessary as this way would limit the updating to only ones that couldn't be merged. Though this also brings up an issue of spreadsheet size depending on how the new sheets I need to add create.
Thanks in advance,
t0ny84
I have many spreadsheets that all have an employee list of some sort,
Whenever I create a new spreadsheet I am generally creating a whole new staff list sheet in that specific spreadsheet.
If I have to update staff details I usually need to do it across multiple spreadsheets.
My question is:
Does anyone know of a way I can have a main "Staff Data" spreadsheet which once updated I can just overwrite the current one within the other spreadsheets and have formulas etc use this new sheet and not error with #REF when the new data is imported.
My current thoughts for this project are to merge various spreadsheets as necessary as this way would limit the updating to only ones that couldn't be merged. Though this also brings up an issue of spreadsheet size depending on how the new sheets I need to add create.
Thanks in advance,
t0ny84