Data Entry with Row Increment

avinashraste

Board Regular
Joined
Mar 12, 2008
Messages
167
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
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,030
Office Version
2016
Platform
Windows
Code:
Sheets("Sheet1").[A3:F3].Copy Sheets("Sheet3").Cells(Rows.Count, "A").End(3)(2)
 

avinashraste

Board Regular
Joined
Mar 12, 2008
Messages
167
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

Well-known Member
Joined
Sep 21, 2016
Messages
3,030
Office Version
2016
Platform
Windows
See if this does it:
Code:
Sheets("Sheet1").[A3:F3].Copy Sheets("Sheet3").Cells(Rows.Count, "L").End(3)(2)
 

Watch MrExcel Video

Forum statistics

Threads
1,101,996
Messages
5,484,089
Members
407,430
Latest member
sgoldman

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top