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

Closed
JamesRugg Posts 1 Registration date Tuesday 22 April 2014 Status Member Last seen 22 April 2014 - 22 Apr 2014 à 16:08
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Apr 2014 à 01:34
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
23 Apr 2014 à 01:34
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