VBA - Split file with multiple sheets into new workbooks based on column value

[gamergirlxx1]

I have a file that contains three detail sheets and a pivot. I'd like to filter all three sheets based on column A and create a new workbook for each value in column A. The new workbooks would contain the three detail sheets and the pivot only containing data that has only data for one of the values of column A. I attached a sample file and what the ideal output would be. Thank you in advance!

Attached is my sample data and the output of what that sample data would turn into:

VBA help.zip

 

[DanteAmor]

Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

There are several macros similar to your request.

For example, check out the following links:

Split each row into individual files

I have a very large table that includes thousands of rows. Row 1 is the header and I'd like to extrapolate each subsequent row to its own file, keeping the original header, and save each using the entry in column A. Could someone help me with a script to accomplish this? Original table that...

www.mrexcel.com

Split Excel Data into Separate Tabs based on Building Names

Hi, I have data in excel that needs to be split in separate tabs based on the building name. can someone please advise how can I create a macro or vb code for this? AssetID Building Level1 Level2 Level3 Level4 AssetLabel AssetLocation MoreSpecificLocation 1 Bldg1 D Services D30 HVAC D3040...

www.mrexcel.com

Try to adapt some of these solutions to your requirement.