Multiple Tables Consolidation

Microsoft Office excel 2007 - upgrade
January 26, 2011 at 01:31:10
Specs: Microsoft XP
in a summary sheet can i import the tables i have in different worksheets?
can this summary use a variable number of tables? is it inteligent enough to put one on top of the other?

See More: Multiple Tables Consolidation

January 26, 2011 at 08:25:27
There's no way we can answer your question without more information.

We don't know what the tables look like, what they contain, how they are laid out, calculated, etc.

Post some examples (after reading the How To reference below) and we'll see what we can do.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 27, 2011 at 05:55:20

Multiple table consolidation is effective option provided for a PIVOT.

There are certain condition to perform this otherwise you are done.

1. Make sure the layout and columns are smiliar across the woksheets and then add the ranges you want to add, and then you have the table ready.

Data --> PIVOT --> Multiple consolidation ranges --> Create a single page field, for me --> and add the ranges --> and FINISH

I hope I have understood your need correctly..

Report •

January 28, 2011 at 00:42:27
yes that sounds great thanks, i now have the problem of, excel does not allow to share the file when it has tables!?
is there any ways around this,? i NEED to share the file...
thanks for the help

Report •

Related Solutions

March 30, 2011 at 11:57:27 is a very good website for all of your table needs.

Report •

Ask Question