I have roughly 10 worksheets that are all the same. They are for different people to fill out information on employees. I need the take the employee names and auto populate the master list. Preferably in alphabetical order.
I have roughly 10 worksheets that are all the same. They are for different people to fill out information on employees. I need the take the employee names and auto populate the master list. Preferably in alphabetical order.
Hello shuttletech,
Welcome to the Forum!
Where are the employee names located? The only names I see are on the worksheet tabs.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Put this macro into the Master Sheet module of your workbook. It will collect the names from all the other sheets and sort them each time you bring up the Master onscreen.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for such a quick response. Perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks