I select a row (in this instance row 7). In this row a lot of entity names are listed - UK and none UK.
I want to delete all columns which does not entail a UK entity name.
All my UK entity names are stored in column A in the filed stored as x:\ukentities.xlsx.sheet1
If any cell in row 7 (the current selected row) does not match the entity names in the UKentities workbook the column should be deleted.
This is an operation I need to do continually, and would like to write a piece of code for it.
I want to delete all columns which does not entail a UK entity name.
All my UK entity names are stored in column A in the filed stored as x:\ukentities.xlsx.sheet1
If any cell in row 7 (the current selected row) does not match the entity names in the UKentities workbook the column should be deleted.
This is an operation I need to do continually, and would like to write a piece of code for it.