I will check this out. Thank you very much for the idea! (I've never used
the indirect function before.) Brenda

"Kevin Vaughn" wrote:

Perhaps you can use the indirect function so that instead of changing all
formulas everytime, you only need to change one cell (which indirect will
then point at.) Let me see if I can find an example where I have done
similar ...
Couldn't find one but here is one I just created to do a vlookup on a sheet
that was referenced by cell B68.

=VLOOKUP(A69, INDIRECT( B68 & "!a1:f50"),2,FALSE)

Would need a couple changes if there were spaces in the sheet name.

=VLOOKUP(A71, INDIRECT("'" & B68 & "'!a1:b18"),2,FALSE)


--
Kevin Vaughn


"Bruizer8" wrote:

I prepare reports that have VLOOKUP formulas that pull data from another
file. Each time I create a new report, I pull the data from a new file where
the only change is the date in the file name looking to.
First, it seems to work better if I do the "Ctrl ~" to show the formulas
first, then highlight the range of formulas I want to change.....then I did
the Find/Replace to change the date.
Lately it has not been working on "replace all" at all. Even with less than
1,000 formulas to change, when doing "replace all" it stops responding
completely. I have to do "replace" and sit there clicking enter for each
cell for it to work.
As a work around, I have changed the top formula and have been copying it
down on each row, which still takes forever.
What can I do to get the Find/Replace feature to work as it should?