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
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