example
A1 = "C1" A1 is a string created by formula "A"&A4
A2 = "C5" A2 " " "A"&A5

A1 and A2 get changed automatically by the spread sheet input. I want to be able to copy the vaules from e1:e5 to range A1:A2.(which is actually c1:c5).

as teh values of A1 & A2 change to target (value) paste range changes