Making new spreadsheets from tabs

See Move or copy worksheets to another workbook here http://office.microsoft.com/en-us/ex...035.aspx?CTT=1 and see if that is what you want.

Thanks MrShorty,

I'm working with Lexi on this, so let me see if I can help pose the question/scenario we would like help with.

We have 3 columns in a spreadsheet. State, City and Zipcode. The spreadsheet has data for 200+ cities and is about 1500 rows. Is there a way (VBA or other) to create a new .xls file for each City, so the resulting file(s) would maintain each row that correspond to the city, but there would be 200+ files, 1 for each city? Based on the image I attached, the results would be a new file for Ardmore, Adamsville, Addison, Altoona and Anniston. Any thoughts?

example.png

It's never as easy as originally advertised, is it.

This isn't the kind of spreadsheet programming I do, so I'm not very good at it.

If I were using a brute force method, I would sort the list by city name, then cut and paste data for each city into new files. 200+ cities would take a while and it would be tedious, but it might be faster for me to do that than to try to come up with code to do it for me.

I could see using Filters to extract data for each city, then put that information into a separate file.

I'm not good with pivot tables either, but I wonder if a pivot table would be a useful way to extract data for an individual city.

Hopefully someone will come along who is good with this sort of programming who can suggest a reliable method for extracting subsets of data from a larger data set.