I have this predicament...
I have several excel files with some similar information, but not the same. I get edited copies of these files every week. There is no way that the people sending me these files will ever change how the files are formatted so I have to take all four files and create a single file with all the information. Basically, it's...
1. A directory of people and their phone/extension/email etc
2: A list of the same people and where they can perform certain tasks
3. A list of the same people and if they are approved for task 1
4. A list of the same people and if they are approved for task 2
What I want to accomplish is to have the file I work on (a 5th file) grab info from those other files.
I have created a workbook with multiple sheets. I put each file on its own sheet and on my sheet I have a copy of the directory. I made it into a table and added additional headers to it for the other fields I need to populate.
List 2 says has an ID (key) first, last then the name of a state license. If the person has more than one license it is on a separate line with only the license different. For example:
ID Last First License Current as of
----------------------------------------------------------
28554 Smith Joe CA License 9/30/2018
28554 Smith Joe FL License 9/30/2018
28554 Smith Joe NV License 9/30/2018
On my worksheet, I have laid out all the states as their own header. I want to grab the license states for each person and put a Yes or No under each state. For example:
ID Last First CA FL NV WI
----------------------------------------------------------
28554 Smith Joe Yes Yes Yes No
So, I need something like - If ID matches last name, and the first two letters in the license column match the state header, then put a yes or a no there.
This is to complex for me to figure out. I've tried, I just can't make it work.
Help, please!
I have several excel files with some similar information, but not the same. I get edited copies of these files every week. There is no way that the people sending me these files will ever change how the files are formatted so I have to take all four files and create a single file with all the information. Basically, it's...
1. A directory of people and their phone/extension/email etc
2: A list of the same people and where they can perform certain tasks
3. A list of the same people and if they are approved for task 1
4. A list of the same people and if they are approved for task 2
What I want to accomplish is to have the file I work on (a 5th file) grab info from those other files.
I have created a workbook with multiple sheets. I put each file on its own sheet and on my sheet I have a copy of the directory. I made it into a table and added additional headers to it for the other fields I need to populate.
List 2 says has an ID (key) first, last then the name of a state license. If the person has more than one license it is on a separate line with only the license different. For example:
ID Last First License Current as of
----------------------------------------------------------
28554 Smith Joe CA License 9/30/2018
28554 Smith Joe FL License 9/30/2018
28554 Smith Joe NV License 9/30/2018
On my worksheet, I have laid out all the states as their own header. I want to grab the license states for each person and put a Yes or No under each state. For example:
ID Last First CA FL NV WI
----------------------------------------------------------
28554 Smith Joe Yes Yes Yes No
So, I need something like - If ID matches last name, and the first two letters in the license column match the state header, then put a yes or a no there.
This is to complex for me to figure out. I've tried, I just can't make it work.
Help, please!
