Exporting to new workbooks by column values

[cultavix]

Hello all, I would like to know if it possible to create the following program. Basically I want to create a program that will read a pre-generated excel sheet with about 6,000 rows and about 50 columns. I want it to then filter the results by for example, names, and then have those names export to another excel sheet, and do the same for everyname. (maybe there ar 100 rows for one name).

There is an example of the extract attached. If you look at column Z, you can see that it says "responsable", I would like to create a excel file for every responsable.

THANK YOU SO MUCH FOR YOUR HELP!

[Bob Phillips]

Yes it is, and it is not difficult.

You could easily get some starter code by doing that action for one specified name with the macro recorder on, and then amend this code to work for all names.

[royUK]

I have posted various examples on the board to do this, one monlt today.

Despite being asked your question title still does not comply with the rules - you wouldn't find anything constructive with a google search using

"Is this theoretically possible to do with VBA ?

[cultavix]

I have loaded the master list, filtered out results by a responsable, and then copied the information, and then created a new excel, pasted the information and saved the file.

Here is the code.

Please Login or Register  to view this content.

The problem I see with this are 2 things.

#1 - I need to know how to record it so that it will copy and paste all the data after it is filtered.

#2 - I need to edit the VB after so that it will save the file as the name of the responsable, for example in this case "AGUADO-LARA"

Note: I am quite new with VBA and im learning as I go, the recorder is much more useful than I thought.

[royUK]

Take a look at the code here, it creates a sheet for each unique name in column A

http://www.excelforum.com/excel-prog...ll-sheets.html

[cultavix]

Instead of specifying the user, can I just have it separate a file for each different responsable user?

Example. I have Peter, John, and Jimmy in the Responsables column. I want to create a new exel file for Peter, John and Jimmy. Maybe each one has 20 or 30 rows, depends.

Also, instead of specifying the area of "$A$1:$BA$4675", how do I specify all ?

Thank you!

[Bob Phillips]

Try something like

Please Login or Register  to view this content.