I have a format for an Excel workbook, but the number and names of the worksheets will change from use to use. Two questions:

1) Is there any way to automate creating the worksheets with the appropriate names? (e.g., reading from a text file)

2) Is there any way to automate creating formulas which use the worksheet names? (I'll have a summary sheet giving results for all of the worksheets together. I would like to automate the setup so it knows initially that there are 15 worksheets, say, and that it totals the bottom lines from all 15.)

Thanks!

 

Couldn't you create a Macro? Don't know how varied your text files are but it would seem you could do this.

 

[QUOTE]Originally posted by jedwards
[B]Couldn't you create a Macro?

 

[QUOTE]Originally posted by magician
[B]

I tried this and the crux of the problem seems to be getting the name of a worksheet as the value of a variable in VB.

 

[QUOTE]Originally posted by edasaurus
[B]I'm not sure I understand your issue, but if you're trying to read in the names of the worksheets, you could do something like this:
[CODE][COLOR=darkblue]

 

To create a new sheet using another as a template you could do something like this:

[CODE]