Is there a way to copy multiple worksheets into one, row by row?


G

Guest

I have a workbook that is updated daily. There are 10 worksheets with
individual data. Although the columns are exactly alike, the amount of rows
can vary. I want to copy all data, by rows, into one sheet for a report. I
have to be able to refresh the "master" sheet as new data is put into the
other 10 sheets. Short of copying and pasting every sheet into the master
every time a change is made, is there an easier way to automatically do this?
Thanks for any help!
 
Ad

Advertisements

G

Guest

Hey - how can i do this so that it update automatically every time I enter
data. not once, but something I can update continuously....
 
Ad

Advertisements

R

Richard Buttrey

Hey - how can i do this so that it update automatically every time I enter
data. not once, but something I can update continuously....

Check out my suggestion to a similar request in a previous post called

"Formula to duplicate data to second sheet"
on the 6th September. in this newsgroup.

I suggest longer term this may not be the best way to handle this
functionality. It sounds like a classic database, and if so you'd
probably be better advised to structure your master sheet accordingly.
With suitable codes added to represent the current 10 sheets of data.
Then you'd simply filter the master sheet as required.

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top