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

Closed
JamesRugg Posts 1 Registration date Tuesday April 22, 2014 Status Member Last seen April 22, 2014 - Apr 22, 2014 at 04:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 23, 2014 at 01:34 AM
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 23, 2014 at 01:34 AM
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
0