Copy Data from Various WorkSheet.

[JohnSky]

HI
I would like to copy the data from different
worksheets to the main work sheet. How do I write the code
for this? On the work book. I have 5 tab of Work Sheets
as Sheet1, Sheet2, Sheet3, Shee4 and MainSheet.
Sheet1,2,3,4 are the same Format and are use for the
users to input the Data into. Afer the data are input to
the Sheet1,2,3,4. I would like to have one command button,
when I click and it will copy the Data from that active
sheet to the MainSheet.
Exampes: If I open the Sheet2 and click on the command
button. It will ONLY copy the data on this Sheet2 to the
Mainsheet. then I open the sheet1 and click on the command
button, it wil conly copy the data on this shhet1 to
Mainsheet.

Any help wold be very appreciated.

 

[Ron de Bruin]

Hi John

Try this example
http://www.rondebruin.nl/copy1.htm

 

[Frank Kabel]

Hi
have a look at the following site as a starting point:
http://www.rondebruin.nl/copy2.htm

 

[Guest]

Thanks for a reply. I know how to copy from one sheet to
the other. But I don't how to copy whatever sheet I open
and that is the one sheet only to copy. I don't want to
created a Command Buttons on Every Sheets and run. I only
need one Macro or Command button to run and copy ONLY the
active sheet Data to Master Sheet.
Thanks

 

[Ron de Bruin]

Hi

In the examples on this page change Sheets("Sheet1")
To Activesheet.
http://www.rondebruin.nl/copy1.htm