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

W

walott1

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

Peo Sjoblom

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
 
N

Neil

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