saving data from referenced cells

[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

 

[Dave Peterson]

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

is one way