View Single Post
  #1   Report Post  
D.R. - Help
 
Posts: n/a
Default can it be copied instead of referenced

Hello --

i'm working on a spreadsheet form (doc 1) that looks at another spreadsheet
(doc 2 for 07/11/05, doc 2 for 07/12/05, doc 2 for 07/13/05 etc)) to grab
values on specific cells and displays them in the spreadsheet form (doc1).
However, doc 1 is dependant on doc 2 so if i close it the values are no
longer displayed. Since doc 2 will change on a daily basis, is there any way
or function i can use that will reference the cells i need but permanently
copy these values so doc 1 is not dependent on doc 2 but once the values are
referenced for that day it is available permanently. Thank you so much.