I am trying to find out if it is possible to have excel using VBA to create new worksheets automatically named after the supervisor's name that is in the list. In addition to the new worksheets being created is there a way have employees information who work for the supervisor moved to that respective sheet.
TEST.xlsx
Try this.
To run both macros {ctrl} + T when in MasterRoster
Please Login or Register to view this content.Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
these work perfectly for being run one time which is totally cool but is there a way to be able to run them more than once where they will "update" the information if information is changed on the the Master Roster sheet?
Replace procedure "CreateWorksheets" with the one below
Changes made
1 Deletes all sheets except "MASTERROSTER" and "Change Matrix" before creating employee data - so clean start each time
2 Have added sort of employee data by Supervisor, then by employee number - which means sheets generated alphabetically and employees added in sequence on each sheet
3 New sheets are now added after the other 2 sheets
Notes
1 If you add another sheet that you want to retain, remember to include it in the condition to prevent it being deleted alongside all the supervisor sheets!
2 Clean start approach may seem a bit like "a sledgehammer to crack a nut", but it is simple.
3 If you insert the second code below into worksheet "MASTERROSTER" module , then anytime cell A1 (in that sheet) is selected , other sheets updated
Please Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks