I need to perform automation between two excel files
1. ID's (First Excel file contains ID, Date etc...)
2. Employees ID with other details (Second Excel file contains Employee ID too and other details )
With ID i have to look for its details in 2nd excel file.. manually we can copy ID n look for details into another excel file but I have to Automate this process to ID column in 1st Excel file a link, like when user click on a ID from 1st excel file the information related to that ID has to be display on a dialog or window from 2nd Excel file.