Thank you for everything StephenR!

If I may ask for a bit more, is it possible with an array formula to simply copy data to another place?

This is for a new sheet in my workbook,
I need to create a macro that will, once again search for a car number and then a pit number, but then I "simply" needs it to copy all the lap time cells corresponding to a specific column in a third sheet "Stints" and for each pit number to use the next column (so 7*6 columns from B to AQ + column A which has lap number in it)

I have been trying quite a few things this afternoon, from the code you already gave me before and other stuff as well but I either get codes which run indefinitely or zeros all over the sheet.... something is obviously wrong and I cannot find what....


Thank you so much again for all your help