The social services agency I work for uses a single-sheet [budget] workbook
to track the expenditures of our customers. There are 600 discreet copies of
the workbook in a single folder on our server and all are named with the
convention smithjoe.xls. I have just created a second and third sheet
([quarterly report] and [annual report]) in smithjoe.xls that uses cell
references from [budget.] Now I want to insert my two new sheets into all my
existing workbooks. The only way I can figure out how to do it is to copy the
sheets from smithjoe.xls into an existing workbook (we'll call it
jonesjohn.xls) and then use "find and replace" to get rid of the external
references to smithjoe.xls in all the formulas. I feel certain there's a much
less time consuming way to do this. Can someone help me out? Thanks in
advance.