Hi,

Can you explain a bit more in terms of "Want to do it for multiple cells"?

Cheers,

Grant.

"Gupta A." wrote:

If I have a cell A1 in which the value dynamically changes and in cell A2 i
want it to record that value what should i do? An earlier response i got was
to use this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$1" Then Exit Sub
If Range("a1") Range("a2") Then Range("a2") = Range("a1")
End Sub

However i need to do it for multiple cells. Not knowing VBA i tried adding
more "IF" statements but that didn't work. I treid copying and pasting and
changing the values (IE from A1 to B1) but i got an ambigious error for
"Worksheet_change"
Any help would be appreciated thanks.