I have a workbook with 10 sheets.

Sheets 1-5 contain a cost model for a single state. Sheets 5-10 contain
input data to the cost model for 35 different states. Sheets 1-5 have lookup
functions, etc. that access the correct input data in sheets 5-10 based on
the value in a cell, say "state".

What I ultimately want is 35 different workbooks, one for each state. None
of the 35 should have sheets 5-10 (I'll have to do copy, paste values).
Also, none of the 35 should have any macros or named ranges.

What's the best way to do this? I know how to do most of it I think. What
I'm struggling with is...if I delete all sheets 5-10 and save it as "Texas",
then how do I get the original workbook with all of the formatting and
references back? I'm sure there's an elegant way to do this.

Through Windows explorer copy the workbook and paste 35 copies; rename
the copies and amend/delete as you need in eact one.

I don't think that this is what your looking for but it might be.

Good luck

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=526084