I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed.
I add new data entries per column and want "date changed" entries automatically displayed and updated in row 7 after columns A and B but only after those two header columns, and let's say if row 7 isn't blank or made blank, I want automatic date keeping to expand for a new entry.
I've looked for a solution and found the NOW() formula, but that's not quite right. I've found a few similar things, but I don't know enough about macros to change them to my desired effect.
How do I do what I've described? It may be a macro or formula.
Thanks in advance for any help.