LinkBack URL
About LinkBacks
But how would the macro know which worksheet should be changed to Dave Jones? How would it know that participant 1 should be changed to Dave Jones? Should it go in the order that entry 1 is for worksheet1, entry 2 for worksheet 2, etc?
But how would the macro know which worksheet should be changed to Dave Jones? How would it know that participant 1 should be changed to Dave Jones? Should it go in the order that entry 1 is for worksheet1, entry 2 for worksheet 2, etc?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Exactly.
If I have 10 names in my list and 10 worksheets, I want the 10 worksheets to take the name of the 10 participants.
Basically, I prepared a spreadsheet with generically named worksheets ("participant 1", "participant 2", etc...) and as soon as I have the actual name of the participants, I want to update my list and that automatically update the name of the worksheets.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks