|
Report Taking Me Too Long
I have a worksheet containing many rows of data. What I need to be able to do
is after I update the information on the main spreadsheet, I need to be able to create a new worksheet in my workbook for each section of data on the main worksheet - by the way, each worksheet that is generated must have a unique worksheet name. Does anyone have any code that can do this? If so, can you explain exactly how it works? Many thanks ~ -- Me! cypher |
Report Taking Me Too Long
See the workbook example on this page
http://www.rondebruin.nl/copy5.htm This one http://www.rondebruin.nl/copy5.htm#workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "cypher" wrote in message ... I have a worksheet containing many rows of data. What I need to be able to do is after I update the information on the main spreadsheet, I need to be able to create a new worksheet in my workbook for each section of data on the main worksheet - by the way, each worksheet that is generated must have a unique worksheet name. Does anyone have any code that can do this? If so, can you explain exactly how it works? Many thanks ~ -- Me! cypher |
Report Taking Me Too Long
See the workbook example on this page
Oops: See the worksheet example on that page http://www.rondebruin.nl/copy5.htm#all -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... See the workbook example on this page http://www.rondebruin.nl/copy5.htm This one http://www.rondebruin.nl/copy5.htm#workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "cypher" wrote in message ... I have a worksheet containing many rows of data. What I need to be able to do is after I update the information on the main spreadsheet, I need to be able to create a new worksheet in my workbook for each section of data on the main worksheet - by the way, each worksheet that is generated must have a unique worksheet name. Does anyone have any code that can do this? If so, can you explain exactly how it works? Many thanks ~ -- Me! cypher |
Report Taking Me Too Long
Thanks Ron,
What I see on the page you referenced seems to be exactly what I need. I will give it a try. -- Me! cypher "Ron de Bruin" wrote: See the workbook example on this page Oops: See the worksheet example on that page http://www.rondebruin.nl/copy5.htm#all -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... See the workbook example on this page http://www.rondebruin.nl/copy5.htm This one http://www.rondebruin.nl/copy5.htm#workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "cypher" wrote in message ... I have a worksheet containing many rows of data. What I need to be able to do is after I update the information on the main spreadsheet, I need to be able to create a new worksheet in my workbook for each section of data on the main worksheet - by the way, each worksheet that is generated must have a unique worksheet name. Does anyone have any code that can do this? If so, can you explain exactly how it works? Many thanks ~ -- Me! cypher |
| All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com