Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting a sheet between multiple new sheets
Hi,
Does anyone know of a link, FAQ or example that could help me with the following? I have single sheet that contains timesheet information across multiple projects. I'd like to programmatically split this sheet, by project, across as many new sheets as it needs, one per project. Even better, but ideally I'd like both options, would be to split the projects across multiple new workbooks, i.e. files, one per project. Any help would be great. Thanks, Jon C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting a sheet between multiple new sheets
Hi Jon
Start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jon C" wrote in message ... Hi, Does anyone know of a link, FAQ or example that could help me with the following? I have single sheet that contains timesheet information across multiple projects. I'd like to programmatically split this sheet, by project, across as many new sheets as it needs, one per project. Even better, but ideally I'd like both options, would be to split the projects across multiple new workbooks, i.e. files, one per project. Any help would be great. Thanks, Jon C |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting a sheet between multiple new sheets
Brilliant. Thanks Ron.
"Ron de Bruin" wrote in message ... Hi Jon Start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jon C" wrote in message ... Hi, Does anyone know of a link, FAQ or example that could help me with the following? I have single sheet that contains timesheet information across multiple projects. I'd like to programmatically split this sheet, by project, across as many new sheets as it needs, one per project. Even better, but ideally I'd like both options, would be to split the projects across multiple new workbooks, i.e. files, one per project. Any help would be great. Thanks, Jon C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summary sheet across multiple sheets | Excel Discussion (Misc queries) | |||
Splitting a Worksheet into Multiple Sheets | Excel Worksheet Functions | |||
multiple sheets vs. 1 sheet | Excel Worksheet Functions | |||
splitting 1 sheet to multiple sheets | Excel Discussion (Misc queries) | |||
Combine multiple sheets into one sheet? | Excel Discussion (Misc queries) |