Copy rows from one sheet to another
Closed
rickl138
-
Jan 30, 2011 at 08:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:18 PM
Related:
- Copy rows from one sheet to another
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Excel copy data from one sheet to another automatically - Guide
- How to screenshot excel sheet - Guide
- Cmd network commands cheat sheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2011 at 05:18 PM
Feb 9, 2011 at 05:18 PM
find the used row of the sheet where you want to copy
lastRow = Cells(rows.count, "A").end(xlup).row
presuming that if a row has a data then column A will always have data
the above formula gives you the last used row (unless the sheet is empty then it gives the row #1)
lastRow = Cells(rows.count, "A").end(xlup).row
presuming that if a row has a data then column A will always have data
the above formula gives you the last used row (unless the sheet is empty then it gives the row #1)
