How to select or delete a column in excel sheet on the basis of heading in the first row

[Mian]

I wrote a script which deletes a single or range of columns from an excel file, however, I found that the file is frequently modified and the automation is not smooth.

The task can be achieved in two ways, please help me in whichever is simple.

1) Instead of column number, I delete single column or range of columns on the basis of heading in the first cell of the column. This way I will be able to select the desired columns even if the column number changes.

2) I select the columns on the basis of heading in the first cell of each column and paste it in a new sheet or new excel file. This way I will get the desired column where ever they are in the file.

Thanks

 

[water]

The Excel UDF that comes with AutoIt should provide the necessary functions: _Excel_RangeRead and _Excel_RangeDelete.