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
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)
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)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
