Is there a way to use a worksheet range that spans multiple worksheets to select all names (Column A) from the 10th worksheet to last one.
I then want to sort this list and remove duplicates to build list that includes all staff that have worked any pay periods for the year.
Read up on and then play around with Multiple Sheet Pivot Tables.
http://office.microsoft.com/en-us/ex...010226585.aspx
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
I have tried using the Pivot Table option but can't get it working. Gives me errors evaluating the range. Not sure if naming conventions on worksheets could be the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks