Copy paste special into last row of another worksheet
Solved/Closed
Roy
-
Jun 17, 2016 at 05:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 27, 2016 at 09:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 27, 2016 at 09:42 AM
Related:
- Macro to copy data from one sheet to another last row
- Transfer data from one excel worksheet to another automatically - Guide
- Macro to copy data from one sheet to another based on criteria ✓ - Excel Forum
- Google sheet right to left - Guide
- Copy cells from one sheet to another ✓ - Excel Forum
- Little alchemy cheat sheet - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jun 21, 2016 at 11:35 AM
Jun 21, 2016 at 11:35 AM
Hi Roy,
Try this:
Worksheets("Allocation").Range("K9:Y262").copy Worksheets("WebADI").Range("C"&rows.count).end(xlup).offset(1,0)
When you want an empty row between pasted data change the offset to (2,0).
Best regards,
Trowa
Try this:
Worksheets("Allocation").Range("K9:Y262").copy Worksheets("WebADI").Range("C"&rows.count).end(xlup).offset(1,0)
When you want an empty row between pasted data change the offset to (2,0).
Best regards,
Trowa
Jun 22, 2016 at 10:00 AM
thank you very much for your response its made a huge dent in what i am trying to do. It worked in regards to pasting the information over, however i will need to paste as values in order to stop all the formulas ref'ing out, can you please help me further in pasting the same code as values.
Thank you Roy