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?
|