Just in case...

I'd use two worksheets in the same workbook--just because I like it that way.

But you could modify these lines:

Set InputWks = Worksheets("sheet1")
Set CalcWks = Worksheets("sheet2")

to point at any worksheet in any open workbook...

Set InputWks = workbooks("book99.xls").Worksheets("sheet1")
Set CalcWks = workbooks("book888.xls").Worksheets("sheet2")



wrote:

On Apr 9, 5:41 pm, Dave Peterson wrote:
How about this.

Create two worksheets--one the calc sheet and one the input sheet.


Does this mean one .xls file with Sheet1(calc) and Sheet2(input)? or
two seperate .xls files?

--

Dave Peterson