Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidation of tables in excel with text and figures
Hello,
I have to consolidate about 20 sheets from 20 differents workbooks (always the first one of a workbook). The amount of columns are not always the same, so i have used the "consolidation" option. The problem is that with the consolidation tool the text does not appear on the consolidate sheet. what did i do wrong? Or is there an other way to do so? Is there an easy way to write a program that accept to show text as wel, As the function allready exist? thanks in advance Florence |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Discussion (Misc queries) | |||
pivot tables: multiple consolidation ranges | Excel Programming |