I have to ask this question again. I got a respones but when I click on it to
veiw nothing comes up. So I will try again

I get a spread sheet that has mutiple customers on it. The customers are
repeated serveral times and have different data each time.
Is there a way for excel to take the information given on sheet1 and create
a new tab for each customer?
I would need the orginal sheet to stay the same but the new tabs would have
each customer info seperate. It take to long to copy and paste to each tab
everytime the report comes to me.

Here is a short example of the spread sheet I get.

TODAY'S
DATE EXCEPTION # CUSTOMER STOCK
1/8/2009 00448 COSTCO; SUMNER 25090
1/8/2009 00439 US FOOD SERVICE; FIFE 715559
1/8/2009 00421 US FOOD SERVICE; FIFE P516
1/8/2009 00474 WEST COAST PAPER; KENT TLB316
1/12/2009 ? WEST COAST PAPER; BOISE 6R
1/13/2009 ? BUNZL; RENTON MISC
1/14/2009 00488 SYSCO; KENT L16BLY
1/14/2009 00488 SYSCO; KENT P508
1/14/2009 00466 BUNZL; RENTON LRG516
1/14/2009 00457 MCLANE NORTHWEST; TACOMA SE16C
1/14/2009 00499 BUNZL; CLACKAMAS B200
1/14/2009 00444 BUNZL; CLACKAMAS 412TA
1/20/2009 ? LAGASSE SWEET INC; AUBURN 420SI
1/20/2009 ? JOHANNA BEVERAGE CO.; SPOKANE HSJ4RV
1/20/2009 ? UNISOURCE; PORTLAND MISC
1/21/2009 ? SYSCO; KENT KH8AYS
1/21/2009 00544 US FOOD SERVICE; FIFE GBX7TW
1/21/2009 00543 MCLANE NORTHWEST; TACOMA X16N
1/21/2009 00543 MCLANE NORTHWEST; TACOMA CG32W

Your help is greatly appreciated
Tom

Tom,

Try:

Excel Explosion 3.0 (free addin) at:
'DataPig Technologies'
(http://www.datapigtechnologies.com/freeware.htm)

VIEW THE DEMO.


Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125240