saving data from referenced cells

  • Thread starter Thread starter karl
  • Start date Start date
K

karl

i have a work book that has an input sheet from many other
(better formatted) sheets reference in order to generate
reports. i would now like to delete the input sheet but
not lose the referenced values in the other sheets.

is there anyway to do this?

thanks
 
Convert your formulas to values by
select your range
edit|copy
Edit|paste special|values

is one way
 
Back
Top