I have several workbook name extracted to sheet1 that end in .xls or .xlsm
I would like a macro to delete only those rows where the workbook name have been duplicated and contains .xls
Eg M_BR1 TB.xls
M_BR1 TB.xlsm
M_BR2 TB.xls
M_BR3 TB.xls
M_BR3 TB.xlsm
In this example...