Multiple Sheets in Excel
 

I would like the info in any cell in sheet1 to appear in a specific cell in
sheet2. Example cell A2, or possibly B3, in sheet1 will always appear on
Sheet2 cell A10.

CAN ANYONE HELP!

N Davis

Mr Norm, you can ref. a cell in sheet1, A2, like this in sheet2 cell A10

=Sheet1!A2
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mr Norm" <Mr wrote in message
...
I would like the info in any cell in sheet1 to appear in a specific cell in
sheet2. Example cell A2, or possibly B3, in sheet1 will always appear on
Sheet2 cell A10.

CAN ANYONE HELP!

N Davis