Excel: Copy to a new tab but keep formula references from old shee

  • Thread starter Thread starter Cheese man
  • Start date Start date
C

Cheese man

I have a roughly 25 rows of formulas that i need to copy to a new tab that
reference numbers within the same worksheet.

How do i get these newly copied formulas within the new tab to still
reference all of the information in the original tab?
 
I have a roughly 25 rows of formulas that i need to copy to a new tab that
reference numbers within the same worksheet.

How do i get  these newly copied formulas within the new tab to still
reference all of the information in the original tab?
Click to expand...

I ipresume you mean you want the cells to referrence the same cell #s
after the change to the new worksheet? If so, change the = to $$
(find / replace) then copy the cells from the old worksheet and paste
them to the new one. Then find / replace all the $$ to =.

ed
 
Back
Top