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