JBeaucaire,

I have very much the same spreadsheet, except I have one column heading at row A1 and no more column headings throughtout my spreadsheet. I have a list of Cities in alphabetically order and wanted to split all the cities out into separate worksheets as outlined here with VP. What would I modify so the code in not looking for VP column heading down the spreadsheet before it splits out to a separte worksheet?

Thanks

James