Data Entry with Row Increment

[avinashraste]

Dear Friends,

I have a sheet having data in Sheet 1. I want to copy the data in Sheet 3 BUT with the incremental row. For eg

Data is in Sheet 1 - A3 : F3 will be stored in Sheet 3 - A3 : F3, Now

The next data AGAIN will be written in Sheet 1 - A3 : F3, But it should be copied & saved in Sheet 3 - A4 : F4, and so on... If it is possible, kindly guide & help, how to do it

Regards,

AR

 

[footoo]

Sheets("Sheet1").[A3:F3].Copy Sheets("Sheet3").Cells(Rows.Count, "A").End(3)(2)

 

[avinashraste]

Dear footoo,


Thank you for replying so fast. As per the requirement, I have copied the data from Sheet 1 to sheet 3 in A3 : F3. And now I have to write the data in the same sheet 3 BUT in the columns L3 : Q3.

The input data will be in the A3 : F3 & the it will be copied to L3 :Q3, L4 : Q4, L5 : Q5 and so on

Sorry for the sudden change but this is the issue I am facing now

Regards,

AR

 

[footoo]

See if this does it:

Sheets("Sheet1").[A3:F3].Copy Sheets("Sheet3").Cells(Rows.Count, "L").End(3)(2)