I want to be able to copy (from one worksheet to another) all the cells in
row37 (up to column R) where the value in R37 is greater than 6000.

I'm thinking a vlookup function (or similar) would be the way to go, but I'm
not quite sure.

Any ideas?