I need help with the finer points of retaining closing prices for a group of
mutual funds on a weekly and monthly basis. I have a large Excel 2007 file
containing 70 worksheets and the solution has to work well within this file.

Using data/get external data/from web, I have been able to download closing
prices to a new worksheet in the file. For this discussion, suppose A1 is
Fund X and A2 is 40.00, the closing price. I then need to populate the 40.00
price to various other worksheets in the file, at the end of every week and
month.

I know how to do that with a formula directly referencing the worksheet and
A2, and I have figured out how to use VLOOKUP to do much the same thing. So
far, so good.

But I can foresee problems when the day comes that row A in the download
worksheet no longer refers to Fund X. Perhaps it has been sold and I am no
longer tracking it. In that case, any previously entered formula referring
to cell A2 is going to give another value or generate an error. That's not
good because all my historical data will show errors or erroneous values as
well. Unfortunately, when the formula does its thing, the cell contains a
reference back to A2, rather than the 40.00 value per se. If A2 changes, the
displayed value in any cell containing a formula referencing A2 changes as
well. I want to be able to retain my historical weekly and monthly prices,
even though the download worksheet may have been significantly altered or
even deleted, for that matter.

My Excel skills are modest. Not a novice, but hardly an expert. I have never
used VLOOKUP until today, and have never used macros or anything slightly
exotic. I have always used ordinary formulas such as
=((weeklydata!N233/weeklydata!N232)-1)*100 and too much copy and pasting,
which I am trying to minimize.

How do I work around this?? I hope my explanation is lucid. If not, I will
try to clarify.