Move or Copy a selected data from one Work Book to another work book

1333117

New Member
Joined
Apr 18, 2013
Messages
20
Hi,

I have a huge data, where I would like to filter the data using the header "Project Leader" and select the first Project leader and move or copy the data to new work book and delete the data of all other project leaders and name the new work book with the Project leader name and save in a particular location and then close the work book and come back to the original work book and now select the second Project leader form the filter and continue the same above process and it should continue for all the project leaders we have in this sheet.

Please help me in doing this using macro..
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

1333117

New Member
Joined
Apr 18, 2013
Messages
20
Hi,

Thank You so much, it is working.. But there is a problem , I will hide some columns before moving the data to another work book. By using this Excel Explosion, all the columns are unhided in all the separated sheets. Is there any solution to keep the hided columns as hided in the separated sheets too...
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top