I’m looking to createa workflow tool that helps our team identify when a document is ready forreview. I have a preparer column and reviewer column for each item forevery month the task is in (so up to 12 times). If a user enters an “x”in a cell, I wanted MS Excel to look to the cell to the right of the “X”, whichwould then lookup the value in that cell to find an email address in a table ona different sheet and email that person saying the task has been completed. Thank you/
Sheet1:
ColumnB already has values exist in it and the preparer adds an “x” to indicate thetask in Column A has been completed. Then the macro would look to thecolumn to the right of the most recent “x” entered and looks to Sheet2 and doesa VLOOKUP to send to the email address in column B that the task iscomplete. There would be up to 12 different columns that the macro wouldneed to be performed on depending on the month of completion.
Sheet2: Coloum A: Initials ex TM. Coloum B: E-mail address ex tom.cruise@hollywood.com
Thank you.
Sheet1:
ColumnB already has values exist in it and the preparer adds an “x” to indicate thetask in Column A has been completed. Then the macro would look to thecolumn to the right of the most recent “x” entered and looks to Sheet2 and doesa VLOOKUP to send to the email address in column B that the task iscomplete. There would be up to 12 different columns that the macro wouldneed to be performed on depending on the month of completion.
Sheet2: Coloum A: Initials ex TM. Coloum B: E-mail address ex tom.cruise@hollywood.com
Thank you.
