View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Twishlist Twishlist is offline
external usenet poster
 
Posts: 54
Default Link to range of cells, so formulas are retained

Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?