Summarising Data from 3 Sheets
Posted by Helen on June 12, 2001 3:51 AM
This has been driving me crazy for almost a week now!
I have 3 sheets that are all identically laid out but with different data. I want to create another sheet with the same layout that pulls all the data into one sheet.
That part I can do but I also want more rows to be added to the 3 original sheets and for the summary sheet to be able to reflect this.
I have a workaround at the moment where I have copied 1000+ rows in each of the 3 sheets and pasted links to these in the summary sheet. This includes all the empty rows and is untidy!
Does anyone know of any way that I can make the summary sheet update when data is added to the 3 original sheets?
Any help would be greatly appreciated!
Helen
Posted by BJ on June 12, 2001 4:09 AM
why not paste special sheets into summary with skipblanks:=true ?
Posted by Helen on June 12, 2001 5:41 AM
How do you mean?
Posted by Helen on June 12, 2001 5:50 AM
Got it! Ignore the last message!
I think that works! Seems really easy and obvious now!
Posted by Helen on June 12, 2001 6:01 AM
OK, so that did initially seem to work but it will not show all the data for some reason? Also, that is still a bit messy. Is there no way to just show the data, not the extra, unused rows and update it as and when it changes?
