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