G
Guest
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
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