Copy and transpose data from sheet2 into next empty row in sheet1

11:52 18 Apr 2026

I have a mass of data in A:F of Sheet2 that needs to be looped copy and paste special transpose into the next empty spot of A:A in Sheet1.

excel vba