| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating multiple worksheets from one
I have a worksheet as follows:
a1: Header: name a2: name of customer a3: Header: VIP a4: info a5: info a6: info a7: Header: name a8: name of customer a9: Header: VIP a10: info a11: info a12: Header: name a13: name of customer a14: Header: VIP a15: info a16: info a17: info a18: info I want to create multiple worksheets to be as follows: (sheet1) a1: Header: name a2: name of customer a3: Header: VIP a4: info a5: info a6: info (sheet2) a7: Header: name a8: name of customer a9: Header: VIP a10: info a11: info in columns a1 ... (sheet3) a12: Header: name a13: name of customer a14: Header: VIP a15: info a16: info a17: info a18: info in columns a1... I can not autofilter because there is different info under the same column until it finds the next name and the number of rows used is variable, the header that surrounds the name of the customer is the same for all customers, can it be possible to create multiple worksheets from this worksheet? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating new worksheets and appending data from multiple worksheets. | Excel Programming | |||
| Creating Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Creating multiple worksheets... | Excel Worksheet Functions | |||
| Creating a chart from multiple worksheets | Charts and Charting in Excel | |||
| Creating PDF Files from Multiple Worksheets Using VBA | Excel Programming | |||
Threaded Mode
