I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much