You'll need to do it cell by cell.

But once you create the formula for A1 (and change it to relative addressing
(losing the $ signs in the address), you can copy down and copy across.


Steven M. Britton wrote:

I would like to try to link a worksheet or tab in a workbook to an external
excel file. I know that we can link cells that reference other workbooks,
but is it possilbe that just the entire tab could reference another worksheet
from an outside workbook?

-steve

--

Dave Peterson