Sorry vase quantity was meant to be 5.

The macro is only copying the column titles, i.e row 1.