I messed up a sheet i have and want to fix by copy pasting formulas from a prior version of the same sheet. When i do This the formula links to the older version sheet. How do i Copy paste without the linked (older sheet)?
I messed up a sheet i have and want to fix by copy pasting formulas from a prior version of the same sheet. When i do This the formula links to the older version sheet. How do i Copy paste without the linked (older sheet)?
Have you tried copy/paste special/value?
Quang PT
Ok I think i just figured it out. I copy past most of the sheet containing the formulas. Then clicked edit links and changes the source form the old sheet to the existing sheet. Does this sound about right? I rechecked the formulas and now they seem to be referencing that sheet (not the on I copied from)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks