Consolidate data
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
I would have suggested Pivot tables, so why won't that work?
Last edited by Bob Phillips; 08-14-2008 at 12:11 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Posting Permissions
Reply With Quote
