View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
just replace the cell/range reference. Easiest way: Open both workbooks
and select the source range with your mouse

--
Regards
Frank Kabel
Frankfurt, Germany

"chris w" <chris schrieb im Newsbeitrag
...
I have made a quote sheet where I have a cell that represents a price

of raw
materials. I would like to have that cell lookup a value to a

workbook that
may be on another computer in the network. How can I do this? And

how can I
have the prices be updated on the individual quote sheets.