Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatic save cell to different cell
I have two worksheet in my excel file. I would like to save data to specific
cell in worksheet 2 when I enter data in worksheet 1. Could anyone help? |
#2
|
|||
|
|||
james
In the cell on sheet2 enter this formula =sheet1!A1 Note the exclamation mark(!) must be entered. When you change sheet1A1 then sheet2 cell will change also. This process is called "linking". For more, see Help on "linking". Gord Dibben Excel MVP On Wed, 5 Jan 2005 08:09:02 -0800, "james" wrote: I have two worksheet in my excel file. I would like to save data to specific cell in worksheet 2 when I enter data in worksheet 1. Could anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Automatic changes in cell entries | Excel Discussion (Misc queries) | |||
This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) |