I need VBA code for the following copy and-paste looping task.
I am using Excel 365.
Problem
The first row is a header row.
Copy a block (range) of data from Sheets1 to Sheets2.
The range to be copied is always 22 rows and 32 columns.
The first block first and last cell: E2, AJ23
Paste special (transpose) on Sheets2.
Always special paste (transpose) on the first empty cell on E column.
Loop through the data until the last block.
The data starts at E2 and ends at AT2839
Thank you!!
I am using Excel 365.
Problem
The first row is a header row.
Copy a block (range) of data from Sheets1 to Sheets2.
The range to be copied is always 22 rows and 32 columns.
The first block first and last cell: E2, AJ23
Paste special (transpose) on Sheets2.
Always special paste (transpose) on the first empty cell on E column.
Loop through the data until the last block.
The data starts at E2 and ends at AT2839
Thank you!!