Split Workbook into Separate Workbooks VBA

[Admin]

Hi All,

Might be a useful one ....

Note: The file uploaded.

[Rasm]

Kris
It is cool all the various programs you & Fox are putting up - in this latest one i changed the output folder (Cell C10) - however the output files still are save in my apps.path - I just figured I could change settings on the sheet itself - and it would save it in that folder.

[Admin]

Edit: New file uploaded.

[ramakrishnan]

Dear Kris,

This is really a good one which is useful for our daily works.

Regards
R.Ramakrishnan

[malaionfun]

HI admin,

I require a similar kind of macro to split data into multiple workbooks but with 3 conditions.

Ex column A to E have the data.

A is supplier name
B is supplier's region
C is Currency
D is Product.
E is amount

Here in A I will have different suppliers who are from different region however there is a chance that supplier name could be same in different region. When the country changes the currency also would change

Hence I need a macro to create multiple workbook for the below filtering criterias

Supplier Name
Supplier's Region
Currency

Hope you could help me.

Regards,
Malai

[mraverageatexcel]

Hi All,

Might be a useful one ....

Note: The file uploaded.

Wonderfully programmed piece of code guys ! thank you for putting that up. could you please advise as to what line of code and where I would add it so as to ensure that the newly split files retain the formatting of the original ?

All help appreciated, many thanks !

[PowerDirect]

Great macro.
Is there perhaps one that can filter multiple columns? (2+)
Date - Unique Field A - Unique Field B

[emoes]

Hello,

This is really a great script.
Tis is helping me out. what a power to get things arranged.
I have one question.
Do you think it is possible to have in the default example (The XLSM file)
To Add a column that contains a value V (Vertical) the output is paste in a new workbook Vertical (Transpose)
So that I in the ControlSheet can select the column that contains the past direction.
And a second one that contains the value that is in the column for the past direction. If it is True, it will be passed in the new Workbook but then transponse.

16-02-16 20-22-02.png

[emoes]

Hello,

SplitDataIntoMultipleWorkbooks.xlsm is realy a great excelsheet and woorks good.
For me it would be nice to have a extra feature and that is, to have the output (Workbooks) based on a selected Column, and A true or false value, Past in Transpose.

It would be nice to select on the Controlsheet, the column that holds the value that decides if the workbooks are created normal or in transpose.

Selectie.jpgTranspose.jpg

Kind regards,

Alex

[marll]

Hi, thanks for the sharing.
but wonder if there possible to split the workbook according to number of row with column (example: A5)
as my filter header was on row no 5. Row 1 till 4 was the workbook header such as Company name, report name etc.

Anyway appreciate your sharing