Hi

I have a 'for i = 1 to 3' loop running through the first 3 sheets where I am applying a filter for non blanks in column H then copying all non blank rows of columns B:H.

I am trying to paste the data from Sheet1 in to cell A4 of sheet 4 then paste the data from Sheet2 in to K4 (i.e. 10 columns to the right of column A) of sheet4 then paste the data from sheet 3 in to U4 (i.e. 10 columns the right of column K).

Thanks in advance