Hi,
I have a very large spreadsheet and dont want to do thousands, literally, of find and replacees to update references to external workbooks.

I'm not sure of the best way to do this...

I have the following formula:
Please Login or Register  to view this content.
In the same sheet i'd like to have the following variables as inputs the formula above will place into itself. make sense????

20080723
persons name
Sheet1

How do I get this done???