I have two separate spreadsheets. One with just the EmployeeName and EmployeeID. The other lists the sales each employee made but that one only has EmpID (which is the Employee's ID numbers). How do I link the EmpID from the Sales spreadsheet to the EmployeeID in the Employee Spreadsheet so that selecting the Employee's name will automatically find that employee's sales through his or her ID number?
I'm loading the data through ODBC from two Excel spreadsheets.
