I want data on sheet 1 to input into sheet 2 also
 

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?

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?

Related question and probelm. Whe I do this in sheet2 - for cells that are
blank in sheet1 it returns a value of 0.0.0000 in sheet2. Format of cells is
GENERAL. How do I get rid of?
--
ndd


"Peo Sjoblom" wrote:

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?