If you in sheet 2 put

=Sheet1!A1

then whatever you put int sheet 1 A1 will also be in the where cell you put
the above in sheet2


Regards,

Peo Sjoblom

"walott1" wrote:

I cannot remember how to input data on one worksheet and have that info
transpose onto sheet 2? I need the same worksheet for two different
applications, but need some info hidden on the second sheet. How do I do this?