So what I am trying to do is take information from an imported text document, in this case it is time keeping, and move the information to another sheet in the related box. Below is what the imported document looks like in excel. Untitled.png
I am trying to take the hours seen as "11:39 REG" under the employee name "DREW" and place them in the 2nd column of another sheet where i paste the employees daily hours. Now i did this easily by having the column A point to the number in column B, so in the other sheet i can just do a VLOOKUP function. The only problem with this is some employees clock in multiple times a day or under different job titles which shifts the entire imported text file. I can solve this with an IF statement, but if the employee does not clock in that day, their name will not appear on the report. If anyone can help with this, it would be greatly appreciated.