copy row to another sheet (1 Viewer)

zezo2021

Member
Local time
Today, 20:03
Joined
Mar 25, 2021
Messages
381
friends
if I have a row number
I want to copy the entire row to last row in another sheet
how can I do that
Thank you show much
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:03
Joined
Sep 21, 2011
Messages
14,046
Use the macro recorder to get started.
Then google on how to find last row with vba, add 1 to that and paste.
 

Isaac

Lifelong Learner
Local time
Today, 11:03
Joined
Mar 14, 2017
Messages
8,738
dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow

rngcopy.Copy rngPaste
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:03
Joined
Sep 21, 2011
Messages
14,046
dim rngCopy as range, rngPaste as range
set rngCopy = thisworkbook.worksheets("worksheetname").range("A50").entirerow
set rngPaste - thisworkbook.worksheets("anotherworksheetname").range("A50").entirerow

rngcopy.Copy rngPaste
That does not paste to last row, Isaac?
 

Isaac

Lifelong Learner
Local time
Today, 11:03
Joined
Mar 14, 2017
Messages
8,738
Hi Isaac

Can I use row number = 150 in range
Yep - i just used "a50" as a example, you can use whatever number you need, or, set up some method (which I haven't addressed at all yet) to determine dynamically which is last row
 

Users who are viewing this thread

Top Bottom