Excel 2003 worksheet connections
Hi Eric
In Sheet1 cell A1 enter 'Eric'
In Sheet2 cell A1 enter the below formula; which will refer to sheet 1 cellA1
=Sheet1!A1
(Please note there is a exclamation mark between the sheet name and the
reference cell)
Similarly you can refer a cell in another open workbook like below
=[BOOK1]Sheet1!A1
(unsaved workbook named Book1)
--
If this post helps click Yes
---------------
Jacob Skaria
"Eric MacLeod" wrote:
How do I get a cell in one worksheet to make multiple entries in another
worksheet?
--
Eric
|