The course you'll have to follow then is this:

change your formula
='V:\Production Reporting Summaries\Tammy\April 05\[Production
Summary.xls]4_04'!$B$4

to
=SUMPRODUCT(INDIRECT("'V:\Production Reporting Summaries\Tammy\April
05\[Production Summary.xls]"&A1&"'!$B$4"))

and then put your 4_04 value in cell A1





"SMullins" wrote:

Changes formulas that I do not want changed

"Duke Carey" wrote:

Have you tried using Search & Replace? Ctrl-H is the shortcut key


"SMullins" wrote:

This is a formula I us daily

(example)
='V:\Production Reporting Summaries\Tammy\April 05\[Production
Summary.xls]4_04'!$B$4

each day I have to make a copy the previous days worksheet and then go into
multiply cells and change 4_04 to the next day, which would be 4_05.

I want to be able to enter 4_05 into one cell and have it update 4_04
automatically so I am not manually changing the formula daily.