Hello all,
I have a workbook with multiple worksheets,
The first sheet (Master) is a list of names, the other sheets are also lists of names made up from the master sheet and detail different qualifications that each person has. So each list may not contain all the names and are detailed on different rows.
What I would like to do is delete or add a name to the master sheet and in doing so delete or add the name to all the other sheets
Any advice on the best approach greatly received
Kevin
Sir can you please attach a example sheet
Thank you please see attached
KevinTest sheet.xlsx
what would be the basis for having a name appear on "this" sheet or "that" sheet?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This is one way of doing what you want. It involves having one row for each qualification that each individual has. The individual worksheets for each qualification then uses the qualification on the Master worksheet to extract the correct records for that qualification.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
This is a variation of the first submission. Each qualification has its own column on the Master worksheet and each name has only 1 row.
Each sheet has to be printed and displayed at certain times/places. The master list is just a record of everybody. The other sheet have additional information in them such as renewal dates etc, the goal is to have everybody trained for everything at some point.Originally Posted by FDibbins
Kevin
Newdoverman,
Thank you
Would it be possible to add a name to the master sheet and have it appear on all the other sheets?
Thanks again
Kevin
Here is a VBA solution to achieve this. See if this helps...
Right click on Master Sheet Tab --> View Code --> Paste the code given below on the code window --> Save your workbook as Excel Macro-Enabled Workbook.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
If you add a name with a qualification(s), that name will be added to the correct worksheet(s). If the name has all the qualifications, and those qualifications are added to the name it will be added to all the worksheets. Both forms of the file will do this. The presentations are different that's all.
Adding a name without a qualification is useless as there is no logic behind what qualification(s) the name belongs to.
Thank you
Kevin
Sktneer,Here is a VBA solution to achieve this. See if this helps...
Right click on Master Sheet Tab --> View Code --> Paste the code given below on the code window --> Save your workbook as Excel Macro-Enabled Workbook.
Please Login or Register to view this content.
Many thanks
works great
Regards
Kevin
You're welcome.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks