Split data into new sheets for excel
 

I have spread sheet that has several customers listed with different data for
each time a customer is listed. Is there away to take the data by customer
name and have it automatically display on its on tab?

Example
1/8/2009 00448 COSTCO; SUMNER 25090 0001
1/8/2009 00439 US FOOD SERVICE; FIFE 715559 00000
1/8/2009 00421 US FOOD SERVICE; FIFE P516 17857
1/8/2009 00474 WEST COAST PAPER; KENT TLB316 0004
1/12/2009 ? WEST COAST PAPER; BOISE 6R 2050
1/13/2009 ? BUNZL; RENTON MISC ITEMS
1/14/2009 00488 SYSCO; KENT L16BLY 00100
1/14/2009 00488 SYSCO; KENT P508 02050
1/14/2009 00466 BUNZL; RENTON LRG516 00004
1/14/2009 00457 MCLANE NORTHWEST; TACOMA SE16C 0100
1/14/2009 00499 BUNZL; CLACKAMAS B200 0100
1/14/2009 00444 BUNZL; CLACKAMAS 412TA JB539
1/20/2009 ? LAGASSE SWEET INC; AUBURN 420SI 0041
1/20/2009 ? JOHANNA BEVERAGE CO.; SPOKANE HSJ4RV 00100
1/20/2009 ? UNISOURCE; PORTLAND MISC ITEMS
1/21/2009 ? SYSCO; KENT KH8AYS 6000
1/21/2009 00544 US FOOD SERVICE; FIFE GBX7TW 0007
1/21/2009 00543 MCLANE NORTHWEST; TACOMA X16N 15233
1/21/2009 00543 MCLANE NORTHWEST; TACOMA CG32W 98958

Split data into new sheets for excel
 

Automatically would mean the use of VBA in my estimation.

Manually you can use Autofilter and copy to a new sheet,

To do this via VBA see Ron de Bruin's site for coding.

http://www.rondebruin.nl/copy5_4.htm


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 14:33:01 -0700, Tom
wrote:

I have spread sheet that has several customers listed with different data for
each time a customer is listed. Is there away to take the data by customer
name and have it automatically display on its on tab?

Example
1/8/2009 00448 COSTCO; SUMNER 25090 0001
1/8/2009 00439 US FOOD SERVICE; FIFE 715559 00000
1/8/2009 00421 US FOOD SERVICE; FIFE P516 17857
1/8/2009 00474 WEST COAST PAPER; KENT TLB316 0004
1/12/2009 ? WEST COAST PAPER; BOISE 6R 2050
1/13/2009 ? BUNZL; RENTON MISC ITEMS
1/14/2009 00488 SYSCO; KENT L16BLY 00100
1/14/2009 00488 SYSCO; KENT P508 02050
1/14/2009 00466 BUNZL; RENTON LRG516 00004
1/14/2009 00457 MCLANE NORTHWEST; TACOMA SE16C 0100
1/14/2009 00499 BUNZL; CLACKAMAS B200 0100
1/14/2009 00444 BUNZL; CLACKAMAS 412TA JB539
1/20/2009 ? LAGASSE SWEET INC; AUBURN 420SI 0041
1/20/2009 ? JOHANNA BEVERAGE CO.; SPOKANE HSJ4RV 00100
1/20/2009 ? UNISOURCE; PORTLAND MISC ITEMS
1/21/2009 ? SYSCO; KENT KH8AYS 6000
1/21/2009 00544 US FOOD SERVICE; FIFE GBX7TW 0007
1/21/2009 00543 MCLANE NORTHWEST; TACOMA X16N 15233
1/21/2009 00543 MCLANE NORTHWEST; TACOMA CG32W 98958