I have a very large worksheet that I would like to apply filters to (using VBA) and copy selected columns to a new sheet - in a different order.
Each time the report is run, I would like the previous content on the Report sheet to be cleared (leaving the headers in place)
I have created a very simplified sample workbook (which should be uploaded).
In the Criteria sheet, the two filters are selected from the dropdowns.
The Data sheet contains the data I wold like to filter and then copy selected columns to the Report sheet.
From looking at the Data & Report sheets, you will see that once the filters are applied, I only want to copy columns A, B, C, D, E and H. In the Report sheet, I need them to appear in the order A, C, D, E, H, B.
This is a very simplified example, the 'live sheet' I am working with contains c. 150 columns and hundreds of rows.
I have tried various combinations of Autofilter and Union, but I can't get it to work.
Is anyone able to help please?