With both workbooks open, click on the first cell in the DESTINATION
workbook. Let's say it's B2. Type =, then switch to the SOURCE workbook and
click on its B2, and hit Enter. You have now created a hyperlink between the
two.

Presumably, you have many more cells for which you want to create similar
links. Let's say the range of those cells is B2:F20. In B2 of the
destination workbook, you will now see a reference to the other workbook,
but it's an ABSOLUTE reference from which you must delete the dollar signs
($). This changes it to a relative reference. You can now drag right and
down, or down and right, until you have covered the entire range.

Alternative method: click on B2, then shift-click on F2, and issue the fill
right command (Ctrl+R). Then click on B2 and shift click on F20 and issue
the command fill down (Ctrl+D).

"danielle" wrote in message
...
I have 2 workbooks, each with multiple worksheets. I need the data from
workbook 1, sheet 1, to be automatically transferred to workbook 2, sheet
1
when entered, and so on......

How do I do this?


Thanks in advance.