Excel sheet - Create multiple files from rows

[Tropic32]

Hi Team,

So heres is what I'd like to happen.

I have one master file in the attachment "Example" Sheet.

I'd like VBA code if possible I've seen it done before... but without the drop down list intact.

I'd like to create a file for each ROW in this excel file.

so a loop if possible to go through each row until you see an empty row.

in this example: I'd have 3 extra files.

each with one row and most importantly the drop down list in tact so the user can change the state.

First File: 1 Joe Bob San Francisco CA 11122
SecondFile:2 Smith Joe NY NY 11232
ThirdFile:3 Stan Theman Mesa AZ 22334

Thanks for your time everyone.

Elias

[royUK]

I can't see much purpose in this. How do you intend naming the files, maybe JoeBob.xlsx?

What data do you want in the new workbook?

[Tropic32]

I can't see much purpose in this. How do you intend naming the files, maybe JoeBob.xlsx?

What data do you want in the new workbook?

The need is to be able to separate each row into one file for each client we have.

Naming of the files is not really important... possibly by name of member?

LastName_FirstName...

[Tropic32]

New datasheet has the rows + the drop down function if possible.

Thanks so much for your help.

[Armando Montes]

Take a look here:
http://www.contextures.com/excelfiles.html#Filter

[Tropic32]

Take a look here:
http://www.contextures.com/excelfiles.html#Filter

Hi

Thanks for your help.

each row is unique i need a file for each one with the drop down list intact with all values for lookup on each new file.

This is very complicated i bet.

[royUK]

This code will create a workbook for each Row. However to maintain the Data Validation you need to type the list in the Source Box, like this CA,AZ,NY,NE, or also copy the Sheet with the list in.

Please Login or Register  to view this content.

[tjs03e]

This VBA code is working for my spreadsheet, but only creating new files for my first three rows. How would I alter this code to create new files for all of my rows (268)? Thanks.

[tjs03e]

This code will create a workbook for each Row. However to maintain the Data Validation you need to type the list in the Source Box, like this CA,AZ,NY,NE, or also copy the Sheet with the list in.

Please Login or Register  to view this content.

This VBA code is working for my spreadsheet, but only creating new files for my first three rows. How would I alter this code to create new files for all of my rows (268)? Thanks.

[arthurbr]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.