I am trying to copy formula for one worksheet onto another within the same book
I wanting to take the whole row but when I paste it the formulas alter to refer to the cells upon the new worksheet.
How can I get them to reference the cell from where they are copied as in
!sheet blah blah blah?
Thx
Nicki
I wanting to take the whole row but when I paste it the formulas alter to refer to the cells upon the new worksheet.
How can I get them to reference the cell from where they are copied as in
!sheet blah blah blah?
Thx
Nicki