VBA Macro required - Copy data from another workbook and paste in new cell and delete it then

[MaunishP]

Hi Team,

I would require a macro to copy data from one worksheet from ROW 1 , only copy 4 columns and paste in another worksheet and then paste data below new row. It should be a continous process.

I have attached both worksheet.

DataRequiredHere Worksheet should have data pasted below in each row
CopyPaste Worksheet have data in single row which needs to be copied only 4 column and paste in DataRequiredHere worksheet and then delete same column and move to next data.

Regards,
Maunish Patel

 

[Marc L]

Hi !

Can you check if it needs to copy only 4 columns ?!
​

 

[Derek McGill]

Can you post the code you have tried to do your tasks ?

 

[MaunishP]

Hi !

Can you check if it needs to copy only 4 columns ?!
​

Hi Marc,

Yes i need to only copy 4 columns from sheet 5 and paste in DataRequiredHere sheet

 

[Marc L]

As it is not the reflect of your result worksheet
at least crystal clear explain which columns to extract …
​