•2 min read•from 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
Our take
Managing staff competencies can be streamlined through automation, allowing for seamless updates across multiple sheets in your Excel workbook. By establishing a master sheet for staff details, you can ensure that columns for surname, first name, and employee number automatically reflect changes across all competency sheets. This approach not only saves time but also enhances accuracy in tracking staff qualifications. With your competencies tracked separately, you can maintain focus on essential details while simplifying the overall management process.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to autofill data from a row to a column on a different sheet in the same folder?I've been struggling with some solutions I've found on the forum but after 1.5hrs I'm close to giving up and manually entering data - which is bound to cost me another 28 hrs. Hoping someone has the solution I'm looking for and is willing to share.. I've exported questionnaire results from Mentimeter to Excel. The document output is formatted automatically in a way that uses columns for unique respondents, followed by their answers in the same column but along individual cells on that column's row, meaning the first entry is A2 and the last entry is in cell CQ2 or something. I would like to make this more user-friendly by: 1) putting each respondent's answers in their own sheet in the folder, and 2) by listing the questions in the first column and the answers in the next columns pretty much 'the other way around'. Currently it looks like this; the answers I need are listed in !VotersF3 to !VotersCQ3. The next respondent's answers are in !VotersF4 through to !VotersCQ4 and so on. What I'm looking for would ideally display answers in !AnswerA3 through to A80. When I manually select !AnswerA3 and click on !VotersF3, logically it does what I want. When I then drag down to autofill, equally logically the sheet enters !VotersF4 instead of !VotersB3 as it's a row vs column problem. I've tried different version of INDEX and TRANSPOSE but I can't get a working formula from that. Would anyone be able to provide me with the correct solution for doing this? I've got another 20+ respondents answers that need to be 'easy to view' instead of scrolling 500 screens horizontally.... Thank you Excel wizards! :) submitted by /u/Lost_Mud2097 [link] [comments]
- Excel with PowerAutomat vs List with automationSo I manage a spreadsheet of nursing students coming into our healthcare system. I update it manually when a student name is added to a rotation in ACEMAPP (our web based student management solution) and I change the status in the spreadsheet to “Approved” when the student has completed their onboarding to be onsite. I am trying to get the spreadsheet to email the Unit Contact to let them know 1) when a student name is added 2) when the status is approved, so they don’t always have to just go check it for changes. I was talking to our SharePoint person and she said I should use Lists instead of trying to learn PowerAutomate for the spreadsheet in Excel. Thoughts? I am a masters prepared nurse who manages incoming healthcare students, but I do a lot of data management and would love to create a living database like this to track our over 3000 students per year. Basically feel free to dumb it down for me, but I am a quick learner with a deep interest in data analysis and management (currently looking at adding an MBA in Project Management to my letters). submitted by /u/TaitterZ [link] [comments]
- Formula to achieve more complex text to columns?Hi everyone! I'm back with my latest question in my journey to maximize excel's usefulness in my office! Currently, I'm trying to figure out how to autofill a table and from there auto convert to a chart. To explain: The spreadsheet is tracking productivity goals for our employees (specifically the goals are to move x amount of clients into different statuses each month). As the employees complete these tasks, they are posting a message in a central teams chat with the information status, client name, client number, caseload, and the date. Once a week, management goes through the chat and copies and pastes the information into a spreadsheet broken up by employee and status. Every month, they use the data from that sheet to fill in a chart that counts them and calculates percentage of the goals met. Management asked me to find a way to take the monthly task of filling in the chart off their hands by making that automated. The way I was going to do this was to convert their sheet into a table and then use the table to create the chart. However, upon opening the spreadsheet, I see how much management has been just copy and pasting the raw data underneath each caseload's heading. I don't want to make more work for them by making them fill in the table, so I'm trying to find a way to automate this to. I thought about text to columns, but everyone's doing things slightly differently in their posts in the teams chat so that makes this a little difficult. The status is pretty universally first with a dash between that and the name with is almost universally second. After that some people are not including separation between name and client number, some people are using commas, some people are using dashes, some people are using a pound sign, and some people are putting the leading zeros. So it's really messy. Obviously, I can ask management to set the expectation that this be uniform and they would be happy to do that. But I want to see if there's a way we can do this easily without changing the already existing process. Does anyone have ideas? Thank you for reading all of this and helping!! submitted by /u/tashykat [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
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