Split my data into separate worksheets

Hello again,

I'm looking to split the spreadsheet into different worksheets dependent upon the value in column 1 (VP). What would happen is a new worksheet would be created when a new VP is listed.

I've attached an example. Please advise if you need more info.

I thank you all in advance as I'm a complete excel macro newb.

-drunk8gods

Try this:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Thanks for the updated code, just one item.

- Is there a way to disable gridlines with the newly created worksheets?

I was able to modify your code to assign widths to the columns of the newly created worksheets.

I can't thank you enough again for the assistance.

Disable gridlines? You mean like in Tools > Options > View > Gridlines?

Add in this line of code inside the For/Next loop:

Please Login or Register  to view this content.

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

I don't know. Sounds like a completely different question.

Start your new question in a new thread with a new sample wb and sample "results" sheets, just like you did to make this thread a success. You can cite this thread in your new one if you wish.