Friends,
First of all thanks for looking.
I my previous post I was trying to get data from a form to my spread sheet so i could use it to fill out a time tracking Worksheet. See Data dump img.
I want to use the date in the second column to find that date column in my WK28 img.
then use the 6:45 in the last column and find the time in the ROW for that Column +1 and enter project Name DD105 T3 then using the 0:30 indicating two 15 min time block are used also put the DD105 T3 in the next time slot
I think a a vlookup or two may be needed but i'm not good with them in excel so I am truly lost here.
Adding my sample excel as well.
Thank you for taking the time to read thru my issue.
First of all thanks for looking.
I my previous post I was trying to get data from a form to my spread sheet so i could use it to fill out a time tracking Worksheet. See Data dump img.
I want to use the date in the second column to find that date column in my WK28 img.
then use the 6:45 in the last column and find the time in the ROW for that Column +1 and enter project Name DD105 T3 then using the 0:30 indicating two 15 min time block are used also put the DD105 T3 in the next time slot
I think a a vlookup or two may be needed but i'm not good with them in excel so I am truly lost here.
Adding my sample excel as well.
Thank you for taking the time to read thru my issue.