Can we changing the cells of another sheet once the cells value of a sheet is changed?

[holycome99]

What i want to ask is that is it possible that once the cells (A1) value of sheet(1) changed, the cells (C4) value of sheet(2) will be updated immediately by using VBA?
I have assigned name for both cells, so it will be better if it is possible to use the name of the cells instead of range or Row and Column.
Thanks a lot!!!!

 

[Candyman8019]

You could do this with VBA, or a very simple formula.

In Sheet 2 cell C4: =Sheet1!A1

 

[Candyman8019]

In VBA, it would look something like this:
Worksheets("Sheet1").Range("A1").Copy Worksheets("Sheet2").Range("C4")
and would go in the Sheet2 object so that it will execute as soon as you navigate to Sheet2...so this would not be immediate.