Multiple Sheets in Excel

M

Mr Norm

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
 
P

Paul B

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
 

Ask a Question

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.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Formula fill series? 1
Excel does not accept text format! 0
Crating User Form to Add Names 1
Excel - Wich Function should I use? 1
how to increment sheets in an excel formula with auto fill 1
Use multiple sheets to display and edit data? 0
Excel 2002 SP3 Copy Worksheet with another sheet named range now # 0

Top