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

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