I have a macro which refresh a web query in sheet Quotes,
and copy/paste these values in Data. how would you
suggest a better way to have macro paste values in the
last non-blank cell? I am using a row named DayColumn
(B2) to tell macro what column to paste values.

Thanks