Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate tables/ranges with text from multiple worksheets | Excel Discussion (Misc queries) | |||
How do I consolidate 2 tables into 1 pivot report? | Excel Discussion (Misc queries) | |||
Consolidate Pivot Tables | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
How do you consolidate tables contianing text? | Excel Worksheet Functions |