I have a workbook that has over 100 + worksheets that has monthly bonus calculation request submitted (one for each employee), as well as few other sheets that has the current monthly data such as employee info like employee ID, name, department, monthly sales results, etc.. Each worksheet has a table that shows the particular employees monthly production for the department, line of business, as well as the production of the people that he oversees.. My question is regarding he employees that he oversees, listed as a 6 digit employee ID number, which could be from 0 to 30 or more, and is always included in column D starting row 2 and down (D2, D3, D4, etc..)
I want to see if there's a way to do a vlookup to a worksheet in the same workbook, by clicking on D2 which is the employee ID # and have the employees name show up in a message box , similar to the data validation message box when you get when you get a data validation error message box, and then the message box disappears when you click elsewhere, or when you move the mouse..
Thank you all in advance..
I want to see if there's a way to do a vlookup to a worksheet in the same workbook, by clicking on D2 which is the employee ID # and have the employees name show up in a message box , similar to the data validation message box when you get when you get a data validation error message box, and then the message box disappears when you click elsewhere, or when you move the mouse..
Thank you all in advance..