Separate Data from Master Worksheet into Individual Worksheets

**bhenderson** · 10-26-2011, 01:18 PM

Hello,

I have what I would call a fairly simple variable macro question. I have a long list of master accounts and sub accounts that I want to be separated into separate excel worksheets (so they can be saved as individual documents and sent out).
I want to write a macro that would recognize the master account number and copy the information for all those rows into a new worksheet, then jump to the next master account number and copy the information for all the sub accounts under that master account number into a different new worksheet and so forth. I have created an example here as well as an excel workbook attached.

Example:
How it looks now (all on one worksheet):
Master Account Number Sub Account Information
1 1000 A C1:G1
2 1000 B C2:G2
3 1000 C C3:G3
4 2000 D C4:G4
5 3000 E C5:G5
6 3000 E C6:G6

How I want it to look (different worksheets):

Worksheet 1
Master Account Number Sub Account Information
1 1000 A Info from original C1:G1
2 1000 B Info from original C2:G2
3 1000 C Info from original C3:G3

Worksheet 2
Master Account Number Sub Account Information
1 2000 D Info from original C4:G4 now in C1:G1

Worksheet 3
Master Account Number Sub Account Information
1 3000 E Info from original C5:G5 now in C1:G1
2 3000 E Info from original C6:G6 now in C2:G2

Thank you so much,
Ben

**arlu1201** · 10-26-2011, 02:09 PM

You have mentioned it as worksheets but you also say that you want to save it as individual documents and send across? So do you mean individual workbooks then?