Hi,
I've got a basic VBA that means when I enter a value into A1 (sheet 1), that value is remembered, with the time, and recorded in sheet 2. As I manually change the value in A1, the new data is captured and recorded.
But, when I try and automate this (connect A1 to Match Odds (Draw) ), the data does not update as it changes.
Anyone know why?
(calculate is set to automatic)