Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate multiple worksheets
How can I write a maco/code that wil distribute data from one worksheet into
multiple worksheets within the same workbook? For instance column I need a separate worksheet for each 'Name' (Column A). So, all the data pertaining to ADAMCZYK, DARCY will transfer into a separate worksheet, etc. Name Mod 2006 Min 2006 Max ADAMCZYK, DARCY CT 0.00 0.00 ADAMCZYK, DARCY DG 0.00 14,148.00 ADAMCZYK, DARCY MG 2.00 10,090.00 ADAMCZYK, DARCY MR 0.00 0.00 ADAMCZYK, DARCY OS 8.00 3,860.00 ADKINS, MARK CT 0.00 0.00 ADKINS, MARK DG 0.00 0.00 ADKINS, MARK MR 0.00 0.00 ADKINS, MARK OS 0.00 0.00 ADKINS, MARK RF 0.00 0.00 AMRAMI, KIMBERLY CT 0.00 0.00 AMRAMI, KIMBERLY DG 1.00 30,424.00 AMRAMI, KIMBERLY MG 0.00 0.00 AMRAMI, KIMBERLY MR 5.00 30,482.00 AMRAMI, KIMBERLY OS 0.00 0.00 AMRAMI, KIMBERLY RF 0.00 0.00 ANDREWS, JAMES CT 0.00 0.00 ANDREWS, JAMES DG 0.00 0.00 ANDREWS, JAMES OS 75.00 2,627.00 ANDREWS, JAMES RF 0.00 0.00 ANDREWS, JAMES US 49.00 7,207.00 ANDREWS, JAMES V&I 12.00 7,527.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to populate same cell on multiple worksheets | Excel Discussion (Misc queries) | |||
Populate central worksheet template from multiple worksheets | Excel Discussion (Misc queries) | |||
how to populate many worksheets in a workbook | Excel Discussion (Misc queries) | |||
populate multiple worksheets in one workbook | Excel Discussion (Misc queries) | |||
How do you populate one spreadsheet from multiple worksheets in a. | Excel Worksheet Functions |