I am trying to open particular folder and apply filter for each excel sheet and delete particular rows based on filter condition and save file, please suggest where i am going wrong, please find below details.
My requirement is to just delete rows where column “Fare” contains “GDS”
Schedule backup.xaml (11.6 KB) Test1 - 2).xls (32.5 KB) Test1 - 3.xls (32.5 KB) Test1 - 3.xls (32.5 KB) Test1.xls (32.5 KB)
C:\Users\Shivkumar.Atnure\Desktop\Schedule Email storage
Remove row where Column J contains ‘GDS’
Save file and repeat for next sheet. (All test files are stored in folder)