Good afternoon,

I am copying a spreadsheet to make summary sheet and I need to change which
sheet the cells are referncing on my copy. Some of the cells refer
to for example, =PRIOR YEAR!B3, some of the cells use a command
to Round(PRIOR YEAR!B3/100), I would like to change all the references that
currently refer to "PRIOR YEAR" sheet and make them "CURRENT YEAR" sheet, so
my references would look like this =CURRENT YEAR!B3 and Round(CURRENT
YEAR!B3/100). I am curious if a paste special, or shortcut exists that can do
this quickly so I dont have to go in and manually change each cell. Any
suggestions? Thanks

Cordailly,