View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mariann Mariann is offline
external usenet poster
 
Posts: 7
Default link two workbooks

I would like to do the same thing, but I want to do the whole worksheet and
the workbooks are on a share drive and my personel drive. Can this be done?


--
Mariann


"JulieD" wrote:

Hi Toinett

you didn't say how the information in the two workbooks is to be linked.

But let's assume that you have Book1 with a value in cell A1 of Sheet1 that
you want in Book 2, sheet1, cell A1.

Open both books - ensure that they're both on sheet 1
choose windows / arrange - ok
now you should be able to see them both side-by-side

click in Book2, cell A1 and type an
=
now click on Book1, cell A1 (you need to click twice)
and press enter - your two books are now linked.

Please let us know if this is what you're after.

Cheers
JuileD

"Toinett" wrote in message
...
I would like to link information in two different workbooks. I've never
done
links before, so be easy.
Thanks.