Hello, Need help!
I have an excel 2007 sheets and I want to record changes in the cells containing formulas....The highlight changes button or option doesn't do this. Macro / VBA is too advanced for me - although I tried but to no avail.
The sheet gets updated daily with a new inventory data and there are cells which have "IF" function formulas, so for e.g. a cell gets highlighted if inventory increases to decreases from a certain set benchmark. e.g. in cell P3 - if inventory is greater than 100, then return a value in cell T3 by highlighting color to red and text "Check". Similarly if it reduces below 50, same thing happens.
But I cannot track these changes from previous date (yesterday to today), as to which dates changed today from yesterday, so currently this is manual (copy/paste) and look for it manually - I know this can be done automatically but how - I am struggling. Please help. I hope I am able to explain myself issues correctly.
Thank you
Bookmarks