booleanboolean
New Member
- Joined
- Feb 25, 2017
- Messages
- 37
Hi guys. Working on a project here and need your help.
I have one excel workbook with employee information. This is the main one I will be working from. Currently, when I enter in an employees ID number, it gives me their name, location, etc based on a VLOOKUP formula that extracts from a hidden worksheet in the same file.
The columns left blank without data are the employees: 1) Shift Start Time, 2) Call Out Type, and 3) Time Off Date -- the information on these columns are found in another workbook/file.
What I want to do is this: By entering the employees ID number in the first workbook, it will populate their 1) Shift Start Time, 2) Call Out Type, and 3) Time Off Date from another workbook.
The only problem I see here is that the other workbook is a Call Log, where entries are manually being put in every so often. The columns will always be the same in this workbook, but I am not sure if this can actually be done.
Process (how I want it to work):
1) In the call log workbook, I have to manually enter everything in here so it inputs all data in respective columns.
2) In my personal workbook, enter in the employee ID, and have all necessary fields populate from information put in the call log workbook (above.)
I have one excel workbook with employee information. This is the main one I will be working from. Currently, when I enter in an employees ID number, it gives me their name, location, etc based on a VLOOKUP formula that extracts from a hidden worksheet in the same file.
The columns left blank without data are the employees: 1) Shift Start Time, 2) Call Out Type, and 3) Time Off Date -- the information on these columns are found in another workbook/file.
What I want to do is this: By entering the employees ID number in the first workbook, it will populate their 1) Shift Start Time, 2) Call Out Type, and 3) Time Off Date from another workbook.
The only problem I see here is that the other workbook is a Call Log, where entries are manually being put in every so often. The columns will always be the same in this workbook, but I am not sure if this can actually be done.
Process (how I want it to work):
1) In the call log workbook, I have to manually enter everything in here so it inputs all data in respective columns.
2) In my personal workbook, enter in the employee ID, and have all necessary fields populate from information put in the call log workbook (above.)
