Hi


I am developing a little spreadsheet where i have a worksheet where i have a list of names. When i new name is added a new worksheet is inserted into the workbook with the new name.

i.e

if Joe Bloggs where added a new worksheet will be added called Joe Bloggs.

I want to do this in VB script does any one know any useful tutorials?

Howdy. I assume that the new name will go to the end of the list. As a starting point, record a macro to add a new worksheet and rename. See what code is produced. Then we can work from there.
________
Honda Civic (Seventh Generation) Specifications (http://www.honda-wiki.org/wiki/Honda_Civic_(seventh_generation))

Hi


I found a site after hours of searching which put me in the right direction. I am picking VB up very slowly. I have uploaded an example so know one else goes through the pain of searching.

Basically you add a value to the sheet in A1 and it will change the worksheet to the value you entered.

My next challenge is creating a if statement into a macro.....