You can put the sheet name in a formula to refer to another
sheet. For example, in A1 on sheet1, use

=Sheet2!A1

to return the contents of A1 on sheet2.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kenny" wrote in message
...
I am trying to setup a worksheet that grabs information from
cells on another
worksheet. I have set up two worksheets that keep track of
different
information. I want to transfer information from one cell in
worksheet one to
another cell in worksheet two...and I can't seem to figure it
out...