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 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 14, 2014 at 11:24 AM
Hi dears,
i am new user in this site
So i hope you will find my requst as well
I want to copy the filtered data to my excel file (my excel (Sheet,)) to a New Excel file by click command button
When i click command button a new excel file want to open and transfer the content of my excel sheet 1

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
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
0