Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 to Excel 2003 (Split data to sheets) | Excel Discussion (Misc queries) | |||
How do I get rid of split screens in emailed spread sheets? | Setting up and Configuration of Excel | |||
Can I split data series in an excel chart? | Charts and Charting in Excel | |||
Split data into new sheets | Excel Discussion (Misc queries) | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) |