magician

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!

jedwards

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

magician

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

edasaurus

[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.

magician

[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]

edasaurus

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

[CODE]