Copy Data From Two Worksheets to master Worksheet

[amithap]

Hi,

Im new to Macro programming. I want to write a Macro to copy row by row in two worksheets data to a master worksheet in the same Excel file. For example if I copy the first row of first worksheet to the master worksheet's first row by Macro then the second worksheets first rows should copy to the second row of the Master worksheet etc..

An example for the above requirement is greately appreciated.

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[amithap]

Dear John,

Thanks a lot for the reply. I tried your code under command button. The coding as follows

Please Login or Register  to view this content.

When I do that it gives the error " Run-time error '9'. Subscription out of rage". When I go to debug an see the definition it says "Identifier under cursor is not recognized"

When I run the code without the command button option It doesn't give an error but nothing happens

What did I do wrong?

Thanks

Amitha

[oeldere]

Sheets("Worksheet2")

change the red text in your code and try again.

[amithap]

Dear Oeldere and John,

The code works to some extent . It was my mistake I have typed "Worksheet" instead of Sheet. But when I type number "1" in Sheet1 and press the command button it copies to the second row of the Sheet3. When I type number "2" in the first roe of Sheet2 it copies to the fourth row of Sheet3. It copies the number one of the first sheet on the Third row. Screenshots are attached to get a clear idea.

What should I do to stop this repetition of copying data?

The code as follows

Please Login or Register  to view this content.

Many Thanks

Amitha

[JOHN H. DAVIS]

Rather than screen shots can you attach a sample file for us to see? Click Go Advance and scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.

[amithap]

Hi John,

Here is the file


Thanks