Hi Brandy,

Yes you can. Here is an example

Sheet1
info in cell A1

Sheet2 the sheet you want to print
If you wanted the info in the cell in sheet1 a1 to show up in sheet2 c2
then you would enter this formula into cell c2 on sheet2


Code:
--------------------

=sheet1!a1

--------------------


If you have named the sheets replace the sheet1&2 with the names of the
sheets.

Hope this helps


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=385850