VBA script Please

[chadlmiller]

OK MS EXCEL 2003

I know it can be done but my script skills are not savy enough.

I want to use an Excel work book and develop a macro or VBA script that does the following without a great deal of link correction:

I want to click on a button to create a new sheet that is an exact duplicate of a template worksheet (So it has formulas and format consistencies) and be able to enter a NAME for the new Worksheet, the NAME appear in cell:A2 of new NAME worksheet and the NAME appears on the Main sheet in the next available Blank row of cell A? with the NAME and then the row also copies the previous row Formula with the new NAME in the formula:
2 Examples: currently
first: when the new NAME is placed in the next empty cell I would like the NAME to LINK to the new sheet with the same NAME.
Second if the previous row looks like this cell F18=SUM(Kirstin!D282)
Then I want the next row to populate with information like this upon new sheet creation.
cell F19=SUM(NAME!D282)


I know this is a lot, but any part or part of this example would be of great benefit. Thank you, Chad

 

[chadlmiller]

here is the file I am discussing

 

[SkipVought]

link is not good.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]