Question on Macros
I have a macro that is moving data from on sheet to another.
For example the macro below will move everything that is in l51down to n2.
Sheets("sheet1").Range("l51:l" & Trim(Str(20 + iRows))).Copy
Sheets("sheet3").Range("n2:n" & Trim(Str(3 + iRows))).PasteSpecial
Paste:=xlPasteValues
How can I move more data to sheet 3 that will automatically put the data in
the last row where the previous data was placed?
Thanks
|