I really appreciate your help.
Thanks!!!

"ufo_pilot" wrote:

=IF(sheet1!$A1<"",sheet1!$A1,"")

say your formula is like the one above,
select the entire area with formula
then go to Replace
type sheet1!
with sheet2!
replace all should take a couple of seconds,

"engineer" wrote:

I have multiple different formulas that I want copied many times. The
formula contains references to particular sheets (tabs at bottom of page).
Everytime I copy the formulas and paste them over a range of cells, I want
the sheet reference to change to a different sheet. How can I do this
without manually changing the sheet reference one by one in these formulas?

Thanks