| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script to Split up Worksheet into Multiple Sheets based on a Columnof Data
Hi, need help on the following...
If I have a worksheet with the data as follows: Fruit Color Price (Header Row) Apple Red $1 Apple Green $2 Banana Yellow $3 How do I write a script to: - Based on ColA, create a new worksheet named "Apple", "Banana"... etc - Within the new worksheets, keep the same formatting as the master worksheet (headers etc.), and copy only the relevant rows there? e.g. in "Apple" worksheet, it shows Fruit Color Price (Header Row) Apple Red $1 Apple Green $2 Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Script to Split up Worksheet into Multiple Sheets based on a Column of Data
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data in single column split to multiple col's based on header | Excel Worksheet Functions | |||
| Split data from 1 workbook into multiple workbooks based on criter | Excel Worksheet Functions | |||
| script to send data from worksheet to multiple workbooks | Excel Programming | |||
| pull data from multiple sheets based on input | Excel Worksheet Functions | |||
| Data from One Worksheet split into Multiple Worksheets | Excel Programming | |||
Linear Mode
