Hi,
Good day! I would like to loop on my table that will transfer the row data to sheet2 up to the last end value.
br,
ivan
Hi,
Good day! I would like to loop on my table that will transfer the row data to sheet2 up to the last end value.
br,
ivan
Code:Sub MoveTableEntire() With Worksheets("Sheet1") .Range("A1:F1").Copy Worksheets("Sheet2").Range("A1") .Range("A2:F" & Application.Max(2, .Cells(.Rows.Count, 1).End(xlUp).Row)).Copy Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp)(2) End With End Sub
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks Excel Fox,
But what i need is the output should be like in Col I to Col O, sorry i wasn't able to explain it well.
The logic is to check the first row with value in col B and lookup the next value in col C up to the last value which Col C is not available in Col B.
br,
Bookmarks