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

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!

Hi, Janet. Perhaps something like this will help:
http://vbaexpress.com/kb/getarticle.php?kb_id=151
************
Anne Troy
www.OfficeArticles.com

"Janet" wrote in message
...
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!

Thanks Anne, That is just want I was looking for!

"Anne Troy" wrote:

Hi, Janet. Perhaps something like this will help:
http://vbaexpress.com/kb/getarticle.php?kb_id=151
************
Anne Troy
www.OfficeArticles.com

"Janet" wrote in message
...
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!

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

"Janet" wrote:

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!

On Fri, 9 Sep 2005 10:15:01 -0700, "aria0901"
wrote:

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

"Janet" wrote:

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!

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
__________________________