dear sir,
I have a worksheet with live data of a currency values that updates every seconds in cell (B2,B10). I would like to record (B2,B10) values each 5 minutes in another worksheet (B2,B10),(C2,C10),(D2,D10)............and saved value not change when updates.(past special, values only). I do not have knowledge of macros please help me with full code.
I have a worksheet with live data of a currency values that updates every seconds in cell (B2,B10). I would like to record (B2,B10) values each 5 minutes in another worksheet (B2,B10),(C2,C10),(D2,D10)............and saved value not change when updates.(past special, values only). I do not have knowledge of macros please help me with full code.