If row is checked copy it onto next available row on 2nd sheet [Closed]

Report
Posts
1
Registration date
Tuesday April 22, 2014
Status
Member
Last seen
April 22, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hi Excel Folk and Friends of Michael,
I have sheets and sheets each day of potenital 'buys' - when I get one I like I have to copy it onto another sheet where the same data populates some new cells (in which I get different GOCS and profit etc)
Is there a way to automate the copying of the data from row 'x' on sheet 1 to the next spare line on sheet 2?
This would save me hours of time.
Thank you SO much.
James

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
not fully clear

if you want to Paste to the row next to the last data row in sheet2 use this code

with worksheets("sheet2")
.cells(rows.count,"A").end(xlup).offset(1,0).pastespecial
end with