change event for an external link

[vvershas]

hello,
I need to copy and paste a range of data whenever a particular cell's value changes. this particular cell is updated by an external link. I've played around with the change and the calculate event. The change event will only work if I update the cell and click out of it.
I also need this range of data to go to the next column each time the cell is updated so that i can compare changes since the previous update.
any help would be very appreciated

 

[vvershas]

Tom,
yep, thats fine thanks.
I get it now that you mentioned the use of a second cell/sheet for comparison. I was thinking that one of the events had the smarts to monitor a change in a linked cell.

Ta