Copy data from sheet 1 to 2 on a new line

apearson

New Member
Joined
Apr 15, 2005
Messages
45
I have recorded a macro that copies data from a row of cells in one sheet and pastes them into another sheet. I made it so that it inserts a row for the next set of data. Is this the best way or is there a way to change the macro so that it just selects the next available free row to paste in the data in the second sheet.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,363
Members
410,911
Latest member
AniEx
Top