Filter data, create a new workbook from filtered criteria

Hi Everyone,

I've been using this forum a lot over the last few months and I must say it is the best excel resource I've found online! That being said, I am a first time poster.

I have a big database (~1500 rows, 17 columns) of sales reps and their assigned clients and information about those clients (city, state, products, etc). I've been populating the database every time we get new information and I send the reps their individual data, however I have to manually filter the "Sales Rep" column by rep, copy all of their data, create a new workbook, paste that data, and then save to a folder.

I want to automate it so that I can just press a button to "Generate Reports" or something and have have each rep's individual report saved to a directory, saving me lots of time.

I basically want something exactly like antoka05's solution here:

http://www.excelforum.com/excel-prog...hat-sheet.html

However that macro is not working for me, I think because I have all text data and no numbers. I don't need any data sorted or rearranged - simply cut from the master and copied to the individual rep reports. I have attached an example. FYI - Columns G,H, and I are data validated, hopefully not a problem? And I will be adding several more columns and rows of data of about 20 sales reps.

I'm sorry, I'm still relatively new to excel. Thank you so much in advance!

hi reef, welcome to Excelforum, please check attachment, press Run button. The files will be located on the same path the main file is