2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/Runningwithbirds1
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#google sheets
#Excel compatibility
#Excel alternatives
#rows.com
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#automate
#staff competencies