Automate the updating of column data across different sheets in the same workbook from a master sheet
I want to automate the copying of changes from certain columns across workbooks
Hi everyone, I need some help with creating an excel document to track staff competencies. I would like a file that contains a list of staff members and their employee number. This file would contain multiple sheets (one for each competency). I would love for the staff ID columns to update across all the different sheets.
For example:
Column A, B, C = surname, first name, employee number
Column D = competency name
Column E = date completed
Column F = upcoming date for reaccreditation
Ideally A, B, and C would update across all the different sheets within the workbook (eg after changing a master sheet), and D, E, F would only be updated within the individual sheet pertaining to that specific competency.
Context: a list of nurses who can do IV cannulation, special wound dressings, special examinations etc.
I would like sheet1 to be a list of staff IDs, and as those staff change over time, I would like thise changes to update automatically to sheet2 (competency1), sheet3 etc...
All the instructions I have searched for on google are just too complicated for me.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site