Excel 2010: Notification Macro
Posted on 2012-08-31
I have a spreadsheet that is nothing more than a change request spreadsheet. User's simply enter in any changes they'd like to see in this one application I work with. I then go out to the shared location on the network periodically and look at this spreadsheet for any new entries made.
I'm curious, if we could add a macro control button in column H starting on row 3. I can then just copy that button down to H4, H5, H6 etc. When they finish entering their request, they can simply click this "Notify" control button it then emails me making me aware a change has been made to the spreadsheet. Is this possible?