F
florinel
Hi!
I have 2 worksheets. In the first one I enter data regularely and i
the second one never because it gets data from the first one (bu
rarely is changed something here since it keeps track of maximum an
minimum values from first worksheet). I want a way to know at the tim
I enter data in worksheet 1 if something has changed in worksheet
(the way I would prefer the alert here would be a beep or an autopla
of a little .wav file) then when I go to worksheet 2 I want to easil
locate the newly changed values by having their cells background in re
for a certain amount of time (lets say 24 hours - so only if thei
values changed today, or in red until the workbook is closed). Th
cells in worksheet 2 I'm talking about are D3
23. How do I do that ?
Thanks
I have 2 worksheets. In the first one I enter data regularely and i
the second one never because it gets data from the first one (bu
rarely is changed something here since it keeps track of maximum an
minimum values from first worksheet). I want a way to know at the tim
I enter data in worksheet 1 if something has changed in worksheet
(the way I would prefer the alert here would be a beep or an autopla
of a little .wav file) then when I go to worksheet 2 I want to easil
locate the newly changed values by having their cells background in re
for a certain amount of time (lets say 24 hours - so only if thei
values changed today, or in red until the workbook is closed). Th
cells in worksheet 2 I'm talking about are D3
23. How do I do that ?Thanks