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..
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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...
 
Upvote 0

Forum statistics

Threads
1,218,744
Messages
6,144,229
Members
450,531
Latest member
avril18

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
Back
Top