View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kiersten L Kiersten L is offline
external usenet poster
 
Posts: 1
Default Copying a block of cells so that it updates automatically

I need to copy a block of cells into another worksheet so that it references
the existing file so that it will automatically update when I open the
document. I would prefer to not link each cell individually because that
will take forever and if I embed the range of cells as an object or a link,
the values won't update automatically. Is there anyway to do this?