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.
|