Changing the formulas in an entire worksheet at once

[acewriter63]

I have a worksheet with

=IF('Wages Termed'!$P9='Developer List Fields'!$J$54,'Wages Termed'!$B9,0)

relative in every cell....where 'developer list fields'!$j$54 is the year 2013. I am tracking data specific to the year.

I would like to copy the worksheet and change the year for the entire sheet so that I capture the data for 2012 which is the value of 'developer list fields'!$j$53.

Is there any way to do this without going into every cell of the worksheet and changing j54 to j53 manually?

[WinteE]

Select all content of the sheet and press <Ctrl>+<H>

Search for: 'developer list fields'!$j$54
Replace with: 'developer list fields'!$j$53

Success
Erik

[acewriter63]

Of course! Thank you! I was definitely over-thinking it.