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
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
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:
- If row is checked copy it onto next available row on 2nd sheet
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- How to check if someone is spying on my whatsapp - Guide
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
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
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
