ok
I had assumed you wanted to run the macro from the raw data sheet. To run it from lookup, copy this code into the code area for the lookup sheet (not the module).
The other macro will need a bit of modification if you want it to run when you click "yes" in the lookup sheet. For simplicity I have set the macro to select the raw data sheet to run the macro, as the addresses it refers to are all in the active sheet. this could be changed if necessary.
2) the time problem was an error - the macro was reading the wrong column. This should be fixed.
3) The user will not have to tick references again in this file once they are checked and the file is save, but they will if you copy the code to a different file.
4) I'm not sure why its going to deleted items - it doesn't when I run it. Could it be because you are not using a real email address?
Bookmarks