| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
| Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
| Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Linear Mode
