Someone help please, i'm going grey.
I'm trying to find a macro that:
a) Runs another macro if any cell value in the range B6:BF68 changes, and then reselects the cell that changed.
or, even better
b) If any cell value in the range B6:BF68 changes, then remember which column (we'll call this "T") this change occured in, then copy data from T101:T106 to T72:T77
If possible, without the user knowing the change happened!
Any ideas?
Thanks all
I'm trying to find a macro that:
a) Runs another macro if any cell value in the range B6:BF68 changes, and then reselects the cell that changed.
or, even better
b) If any cell value in the range B6:BF68 changes, then remember which column (we'll call this "T") this change occured in, then copy data from T101:T106 to T72:T77
If possible, without the user knowing the change happened!
Any ideas?
Thanks all