consolidation of tables in excel with text and figures  
Author Message
vav





PostPosted: Top

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

Excel284