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? |
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 |