How to consolidate various tables?

  • Thread starter Thread starter murphykilpatrick
  • Start date Start date
M

murphykilpatrick

I have various tabs made up of lists of names and planned hours they will
work in 2009. i.e.,
Account Management
CEO
Assitant
Account Executive

Proofreading
Proofreader1
Proofreader2

Looking to have a master table which adds all employees' individual hours to
see how many hours we are planning for them for they year. I would normally
do a VLOOKUP, but I cannot put the original tabs in ascending order...
Anyone have any ideas?
 
Hi,

Its not clear what your individual spreadsheets look like? Where are the
numbers, where are the titles, and what do you want the results to look like
- layout wise?

By the way you do not have to sort the original tabs in ascending order to
use VLOOKUP
Just set the last argument to FALSE, which means Exact match, in which case
order is not important, despite what many Excel books say.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup tables to muliply various hourly rates 0
Adding up total hours worked on employee schedule using various criteria 0
Pivot Table Repeats Names in multiple rows 3
Prepare Cash Consolidation Wkst 2
Pivot Table-Multiple Consolidation Ranges 3
Using Pivot Table to consolidate multiple worksheets 1
Excel 2003 - How to do this 2
How To Clear Previous Selection From a Drop Down 2

Back
Top