Split worksheet content into multiple worksheets

**macaco20** · 04-11-2012, 09:51 AM

Hi Everyone,

I am trying to split an excel spreadsheet into multipule workbooks by column A (location), but really do not have a clue as to where to start.

can anyone help please.

**JBeaucaire** · 04-11-2012, 11:22 AM

================
'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

**JBeaucaire** · 07-13-2012, 08:13 PM

Did you try it out? How is it going?

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.

**jindon** · 07-14-2012, 12:15 AM

See the link below

Exactly the same situation

http://www.excelforum.com/excel-prog...=1#post2857955

**MarvinP** · 07-14-2012, 12:42 AM

Hi guys (I'm assuming).

I think Jerry's code creates multiple workbooks and Jindon's creates multiple worksheets. Workbooks <> Worksheets.

This means Jerry's answer isn't what the OP asked for and Jindon is incorrect when he says "Exactly the same situation".

I've had a few drinks so I may be wrong, but this is what it looks like from here.

**jindon** · 07-14-2012, 01:34 AM

Originally Posted by MarvinP

Hi guys (I'm assuming).

I think Jerry's code creates multiple workbooks and Jindon's creates multiple worksheets. Workbooks <> Worksheets.

This means Jerry's answer isn't what the OP asked for and Jindon is incorrect when he says "Exactly the same situation".

I've had a few drinks so I may be wrong, but this is what it looks like from here.

Yeah, you are.
What I meant was Exactly the same situation as the thread title.

Split worksheet content into multiple worksheets