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


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

Advertisements

E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top