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
 

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

Similar Threads

Referencing text in merged cells 1
Sheet Referencing - autofilling sheet names 2
Excel Move or Copy Stopped Working? 0
Cross workbook referencing based on cell input 1
formulas copying from sheet to sheet 6
How can I reference a worksheet in a formula based on a cell value 2
One Formula Referenced In Many Cells 6
Pulling data from Sheets in A workbook 2

Back
Top