Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer data from worksheet to another
How do I transfer data in a cell from worksheet 2 back to worksheet 1?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer data from worksheet to another
On sheet 1 you could enter a formula like:
=Sheet2!A5 that assumes that worksheet 2's name is Sheet2 and that the cell you want to get the data from is at A5. Another way to do it is to let Excel do the work for you: select worksheet 1 and click in the cell where you want the value from worksheet 2 to show up and type an = in the cell, then choose the other sheet and click in the cell that you want to transfer data from and simply press the [Enter] key. "dave" wrote: How do I transfer data in a cell from worksheet 2 back to worksheet 1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Worksheet transfer of Data | New Users to Excel | |||
Transfer and save data from one worksheet to another. | Excel Discussion (Misc queries) | |||
Automatic transfer of data from one worksheet to another | Excel Discussion (Misc queries) | |||
Transfer cell data from one worksheet to another === URGENT | Excel Discussion (Misc queries) | |||
How do I automatically transfer data to a 2nd worksheet page? | Excel Worksheet Functions |