Hi there

I am trying to create a formula that looks in cell A1 in sheet B for a
matching value in A. When it finds the value in sheet A, I want it to copy
the next 10 cells in the corresponding row into cells B1, C1 etc...

Any advice appreciated.

Thanks