| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create sheets based on data in string and copy to
data in columns a:f
Need to create new sheets for each unique name in column c. Then copy all rows (except header in row1) for each unique name to its unique sheet starting at a11. If sheet exist, keep adding it to the next available row. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create sheets based on data in string and copy to
Wouldn't it be better to keep it all on ONE sheet and use filters, etc to get info? -- Don Guillett Microsoft MVP Excel SalesAid Software "J.W. Aldridge" wrote in message ... data in columns a:f Need to create new sheets for each unique name in column c. Then copy all rows (except header in row1) for each unique name to its unique sheet starting at a11. If sheet exist, keep adding it to the next available row. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create sheets based on data in string and copy to
See
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "J.W. Aldridge" wrote in message ... data in columns a:f Need to create new sheets for each unique name in column c. Then copy all rows (except header in row1) for each unique name to its unique sheet starting at a11. If sheet exist, keep adding it to the next available row. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create sheets based on data in string and copy to
na Don, I needed individual sheets.
Using Ron's code.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create sheet based on value in string | Excel Programming | |||
| Create new sheets based off Data sheet, and template sheet | Excel Programming | |||
| Create a 'text' string based on whether values appear in other cel | Excel Worksheet Functions | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100 | Excel Programming | |||
Linear Mode
