PDA

View Full Version : Consolidate data



Richard Smit
08-12-2008, 10:54 PM
Hi All,

I have a tough task on hand to consolidate data from 10 different sheets in one workbook. They all have the same parameters. I would like all this information gathered on on page in the workbook, and then I would like to create a graph based on the parameters I filter out. I've tried the pivot but that would'nt work out. Please help me out with a possible solution.

Thanks in advance for your support.

Regards,
Richard

Bob Phillips
08-13-2008, 12:12 AM
I would have suggested Pivot tables, so why won't that work?

Richard Smit
08-13-2008, 08:23 PM
Hi,

I'm sure, However... let me explain..

I have to create a graph based on the consolidated data. Also I will be filtering this information and I would like the graph to change accordingly. I tried this on my computer, however for some reason it did not work out.I'm not sure if this is something wrong with my computer or they do not work that way at all.

Regards,
Richard