I would like a user have the ability to modify a formula with a reference to
an open spreadsheet. I am working on today's spreadsheat named 10-24-08. It
uses the formula: =K52+'10-23-08'!K53 referencing the prior days spreadsheet
10-23-08. I would like the user to input into cell A1 a spreadsheet name (ie.
10-22-08 or whatever spreadsheet they wanted to use) and then use the
variable input into cell A1 as the reference in the formula:
=K52+cellA1variable!K53. The spreadsheet is protected. I tried a
macro....unprotect, find/replace, protect....which works great but doesn't
allow the user to change the find/replace values. Is there a way to do what I
want....Thanks.....