one way, =Sheet1!A1, will show whats in sheet1 cell A1, you don't have to
type the formula in just select a cell in another worksheet and type = then
select sheet1 cell A1 and enter.
--
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
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.