Problem solved!!!! The reference numbers had extra text on the end which I hadn't noticed. Apologies!

I have put a LEFT(xxxxx, 6) so it searches the first 6 numbers. That works fine now.


I do have one more question though.

Everytime I run the macro, it returns the headers in 1 row, and the values in the row below.

What can I do to make it just return the values?

Thanks in advance