Hi all,
I'm managing a workbook that works as an employee tracker. Each employee has their own sheet with the same information being inputted- personal details, absences/lateness, disciplinary records etc. The layout is identical for each sheet, it's just the data that differs.
My problem is every time I want to change something such as conditional formatting in a specific field, or which range a drop-down pulls values from, I have to edit this for every single sheet (and we have a lot of employees!) My question to you is: Is it possible to set one blank template as the "master" sheet, that any child copies will automatically pull these changes from? Would save me a ton of time if so!
(For clarity's sake, I usually make quick changes to the file in Google Sheets but will use Excel for larger edits- it's referenced by multiple users in several locations.)
Many thanks!
Bookmarks