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

[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?

 

[ed]

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