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

G

Guest

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

Guest

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
auto fill certain data from sheet1 to sheet 2 2
how to update a worksheet and have data copied to another sheet? 2
Dependent drop down dynamic range formula, off sheet. 7
matching and entering data 3
How do I copying data from a cell on sheet to a diff cell/sheet 1
Required solution for an vlookup exception. 0
add hyperlink using sheet names and cells(i,j) 3

Top