First of all I have never used VBA. Second of all My previous macros/formulas were simple by the standards of all the posts I have read and I need step by step instructions. I have read several posts that seem to answer my question, but being the MEGA NEWBIE I don't know how to make it work.
I have a spreadsheet with drop down menus of Status item in three categories in Colums E, G and I. Column M is labeled 'Date'. What I need is a formula that will change the date in column M when I change the status of a cell (via dropdown) under E, G or I. I know this is simple but no luck so far.
If you can provide steps to paste code/formula it would relly help.
Thanks
I have a spreadsheet with drop down menus of Status item in three categories in Colums E, G and I. Column M is labeled 'Date'. What I need is a formula that will change the date in column M when I change the status of a cell (via dropdown) under E, G or I. I know this is simple but no luck so far.
If you can provide steps to paste code/formula it would relly help.
Thanks