Multiple value find on different sheet on same row

[jimbob121]

Hi All

I am looking for some much need help. Please find attached sample workbook. I am trying to use the date and journey number on sheet Monday to look at the data sheet and find the matching row. I then need to calculate the shift time from the start and finish time, minus the break and return value back to appropriate intersect on sheet Monday.

Many thanks in advance.

regards

[AB33]

Try the attached.

[jimbob121]

Many thanks AB33

Your code works very well, I hope that I can adapt to suit my needs. I am not familiar with VB script, I doth my cap to you excellent code and quick reply.

cheers