Delete columns - Prioritise columns with specific headers

Hi,

I have a macro that import's a csv file with various headers/columns. Sometimes there are slight variations on the columns of data imported and I would like a macro to favour certain columns if they exist, and delete other similar columns.

For example:
If both columns with the headers 'QUANTITY SUBMITTED' & 'ACCEPTED QUANTITY' exist then I want to delete the 'ACCEPTED QUANTITY' column.
However, sometimes only 'ACCEPTED QUANTITY' will exist- in this case I would want to keep it.

Does anyone have any ideas as to how I might achieve this?

Thanks!