saving data from referenced cells

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
 
D

Dave Peterson

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

is one way
 
Top