How to consolidate various tables?
 

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?

How to consolidate various tables?
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"murphykilpatrick" wrote:

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?