I have a workbook with a data sheet from which headers are at Row 3 from column A to AT
Below the headers are data of different formatting .
How to copy in vba the headers at row 3 in yellow background and their column data to last row to another sheet named Working keeping their formatting .
Note there may be some in yellow columns headers that have blank cells that is aaa , blank ,blank , aaa and so on .
the data reads from 20000 rows records or more
Attached file with expected results .
Thanks if someone can assist
Bookmarks