Hi,
I am fairly new with VBA. I can work with simple macro functions but this one is a doozy.
I have a sample workbook attached and, The raw data contains timelogs and i need in figuring out a way to find the time in Column F in relation to the Personal Break in column G.
I have multiple variables for the lookup which made it difficult for me
Name (Column C)
Date and Time (Column F)
Type (Column G)
On the workbook, I have created a pivot table that gives the desired result somewhat but is not accurate to a tee. If the person went out at lets say 9:49AM and went back at 10:01AM The pivot will show them as separate actions instead of one.
So a macro can help, Can someone help me pull the data of Personal Break IN to match the Personal Break out? Put blanks instead if the person did not time in/out.
On the sample workbook, I have the RAW Data on one tab and the desired result on the OUTPUT tab.
Thank you.
Bookmarks