How can Copy one Excel Content to a new Excel File By Click Comm
Closed
nisar.mohammed
Posts
1
Registration date
Wednesday August 13, 2014
Status
Member
Last seen
August 13, 2014
-
Aug 13, 2014 at 06:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 14, 2014 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 14, 2014 at 11:24 AM
Related:
- How can Copy one Excel Content to a new Excel File By Click Comm
- Efootball 2022 downloadable content - Download - Sports
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 14, 2014 at 11:24 AM
Aug 14, 2014 at 11:24 AM
Hi Nisar,
Welcome to this great site!
You might be surprised how handy the macro recorder is.
Start recording, apply filter, select all cells, copy cells, activate destination file, paste data, remove filter, stop recording.
Probably the only issue you have doing this, is finding the first available row.
This may help:
Range("A"&Rows.count).end(xlup).offset(1,0)
Let us know if you get stuck, so we can help you further. Note that more details are always welcome.
Best regards,
Trowa
Welcome to this great site!
You might be surprised how handy the macro recorder is.
Start recording, apply filter, select all cells, copy cells, activate destination file, paste data, remove filter, stop recording.
Probably the only issue you have doing this, is finding the first available row.
This may help:
Range("A"&Rows.count).end(xlup).offset(1,0)
Let us know if you get stuck, so we can help you further. Note that more details are always welcome.
Best regards,
Trowa
