Copy data from Sheet1 to ActiveSheet

[buckobro]

I have a workbook with many sheets. On each sheet is a command button with a macro assigned to it. when the button is clicked, I want data from cells A1:A10 from Sheeet1 (the data source sheet) to be copied to a selected area in the target active sheet (The active sheet is the sheet where the macro button was clicked). I don't want to duplicate this macro for every sheet that has a button. How can I word the VBA code so that the data is copied to the sheet where the button was clicked and have only one macro subroutine? Thanks.

[thameem127]

Upload your file

[JOHN H. DAVIS]

Not sure I understand does this help?

Please Login or Register  to view this content.

[buckobro]

Here it is.

[thameem127]

try this

Please Login or Register  to view this content.

[buckobro]

That won't work because the macro can only copy the data from Sheets("Data") and paste it to Sheets("Sheet2"). I need the macro to paste the data in whichever sheet where the button was clicked. For example, if I click the button on Sheet3, the data should be copied to sheet3 -- not to sheet2.

[billstpierre79]

try

Please Login or Register  to view this content.

[thameem127]

try this

Please Login or Register  to view this content.

[buckobro]

Bingo. Thank you.