Copy Data From Two Worksheets to Master Worksheet Automatically

[Amitha]

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.

Thank you.

 

[Sathish KV]

Hi,

This can be done by many methods in macro. It would be helpful if you post a sample workbook with two sheets Data and Master with headers only

 

[Amitha]

Dear Sathish,

Thanks for the reply. Herewith I attach the sample workbook.

Thanks

Amitha

 

[Sathish KV]

Hi,

When you copy 1st row from 'Sheet-bandnew' and paste to 'Sheet-master', macro should copy the 1st row from 'Sheet-used' and paste 'Sheet-master'

Should it be only based on the row number you copy or Can it be based on the 'ORDER #'

 

[Amitha]

Hi Sathish,

If it is row number that is fine

Thanks