Delete data records with a specific value in Column E in each worksheet of several files
Posted on 2013-12-12
I got hundreds of excel-files in a folder in C:\MyData
Each file has dozens of worksheet, all with the same make-up
I would like to delete data records (entire row) in all of these files using VBA with the following requirement:
Open each excel-file in C:\MyData
Go to each worksheet in each excel-file and ...
delete all data records which have the value 'NZ' in Column 'E'
Thank you very much in advance.