Hi
open both workbook A and workbook B and choose the correct sheet in each -
now choose window / arrange and Ok so that you can see them on the screen at
the same time.
Click in workbook B where you want a piece of information from workbook A
and then type an
=
now click in workbook A (you'll have to click twice) and then press ENTER
the cell in workbook B will be linked to the cell in workbook A.
repeat as necessary.
Hope this helps
Cheers
JulieD
"TBogle" wrote in message
...
I have a Workbook (Workbook A) with multiple Worksheets.
I want to create a separate Workbook (Workbook B) and
link it to one of the worksheets in Workbook A. The goal
being that any updates to the worksheet in Workbook A
will automatically update Workbook B.
How do I do this?
|