This one is a doozie! Please read.....

[zakasnak]

I have two sheets that I need to breakout by store (145 stores currently open, is flux).

Each store should get it's own sheet that will include the 7 static columns A:G PLUS their three individual columns.

The two sheets are currently set up like this example:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	BIPAD	TITLE	Category 1	Category 2	FREQ	PRICE	CLASS	9301, DRAW	9301, AVG SALE	9301, AVG SELL OFF %	9602, DRAW	9602, AVG SALE	9602, AVG SELL OFF %	9604, DRAW	9604, AVG SALE	9604, AVG SELL OFF %
2	28323	3 X 3 Annual * * * * * *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	1	$19.00	FILLER	0	0	*	0	0	*	0	0	*
3	5840	3 X 3 Magazine * * * * *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	2	$16.00	FILLER	0	0	*	0	0	*	5	1.33	26.60%
4	25712	Acrylic Artist Special *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	1	$7.99	FILLER	0	0	*	4	4	100.00%	5	2	40.00%
5	27728	Afterall Journal * * * *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	2	$10.00	FILLER	0	0	*	0	0	*	0	0	*
6	1215	Air Brush Action * * * *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	6	$5.99	CORE	0	0	*	5	0.5	10.00%	11	5.83	53.00%
7	2541	American Art Collector *	ART * * * * * * * * * * * * *	N/A * * * * * * * * * * * * *	12	$6.95	PERFORMING	0	0	*	2	0.5	25.00%	2	0	0.00%
9301 thru 9737

Sheet 1 comprises stores 9301 thru 9737, Sheet 2 has 9738 thru 9896..... Help?

I am currently using ASAP Utilities #4.2 (Insert sheets based on cell names) & #6.1 (conditional column delete). The person taking this over does not have access to ASAP Utilities, so I need a macro that can take the place of, at least, the 6.1. Otherwise this is too tedious........