Excel 2003 worksheet connections

E

Eric MacLeod

How do I get a cell in one worksheet to make multiple entries in another
worksheet?
 
E

Eric MacLeod

Hi Mike
Thanks for quick response. It's first time I've used a forum!
Not sure that I explained it well. I am trying to enter a value in a cell
in worksheet 1 that will automatically enter a value in a number of different
cells in worksheet 2. Hope that helps to calrify.
Regards
 
J

Jacob Skaria

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
 
J

Jacob Skaria

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)
 
Top