Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to create new workbook and sheets
MS: XP
Excel: 2002 I have written macros to rearrange the data the way its needed to create a database. The sheet name is Table. The workbook will be open. Now I need to do the following and need some help to get it done. 1) Column B contains names, the names are unique and in sorted order. 2) I wish to: a) Create a new workbook named Schedule. If workbook Schedule already exists then it needs to be deleted. b) Create a new sheet in the workbook Schedule for each different name found in column B. c) Each newly created sheet to be named the value in column B. d) Move all rows with the same name to the newly created sheet that has that name. e) Finished. Thanks in advanced for any help. -- Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to create new workbook and sheets
hi Richard
Start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard" wrote in message ... MS: XP Excel: 2002 I have written macros to rearrange the data the way its needed to create a database. The sheet name is Table. The workbook will be open. Now I need to do the following and need some help to get it done. 1) Column B contains names, the names are unique and in sorted order. 2) I wish to: a) Create a new workbook named Schedule. If workbook Schedule already exists then it needs to be deleted. b) Create a new sheet in the workbook Schedule for each different name found in column B. c) Each newly created sheet to be named the value in column B. d) Move all rows with the same name to the newly created sheet that has that name. e) Finished. Thanks in advanced for any help. -- Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro to protect choosen sheets in workbook | Excel Discussion (Misc queries) | |||
CREATE MULTIPLE WORK SHEETS IN A WORKBOOK | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
How to create workbook with multiple sheets | Excel Discussion (Misc queries) |