Data Entry with Row Increment
Results 1 to 4 of 4

Thread: Data Entry with Row Increment
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2008
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Entry with Row Increment

    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

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,567
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data Entry with Row Increment

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

  3. #3
    Board Regular
    Join Date
    Mar 2008
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Entry with Row Increment

    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

  4. #4
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,567
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data Entry with Row Increment

    See if this does it:
    Code:
    Sheets("Sheet1").[A3:F3].Copy Sheets("Sheet3").Cells(Rows.Count, "L").End(3)(2)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •