Macro To Copy Specific Columns from Excel with Pictures using Column Names

[Neonovaz]

Hello All

Problem:
The Excel I have has some pictures embeded at start (A1:H10) which can vary in different templates

below this there is header, below which is a table (headers for column names start from A12)

Since column number can change , I need a way to extract whatever data is there under column using column names.

The Table may not always be present from A12, therefore I need a solution where no matter where the columns are located in the worksheet it can be extracted

Sample Columns names :

Client Name

Client Code (DDS)

Client Code

Brand Name

Brand Code

<colgroup><col width="200"><col width="126"></colgroup><tbody>[TABLE="width: 833"]
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

</tbody>[/TABLE]


Please advise

 

[Neonovaz]

Also the extracted columns with their data should be written into a new workboox.xlsx starting from A1 with thier headers