Trying to move data in contigious way .
Columns A shows Headers at row 8 and 9.
At row 38 shows page no .
When the going to next page no there is a difference of 6 and the pattern remains same between page nos.
How to move the actual data of column A in vba to a new sheet (test)in same workbook by transposing the headers to row 1 as well as data with it page numbers.
The data can reach 100 pages as shown in column A