Skip to next worksheet/workbook when filtered result is '0' or blank

Hello Excel Experts,

I found some great sets of macro that allows below actions:-

1. From ThisWorkbook, open another workbook containing data
2. In ActiveWorkbook, filter some rows of data based on criteria
3. When filtered results exist, delete those unmatched then copy the matched ones into a new worksheet in ThisWorkbook
4. Do the same step 2 & 3 for next sheet in the ActiveWorkbook (if any)
5. Close ActiveWorkbook without Save
6. Move ActiveWorkbook into folder named "Done"
7. Repeat Step 1 to 6 until no more files in the directory/path

However, what I would like to achieve is if no result during filtering, it supposed to skip that ActiveWorksheet then go to next sheet but if there's no result for entire ActiveWorkbook, it will close without save the ActiveWorkbook but doesn't move it into "Done" folder.

As for now, my macro will stop and prompt me the worksheet that has no result. It will not continue as long as I didn't close it and rerun the macro manually.

Any help would be appreciated as I would need to loop through 800 files at a time without having to wait in front of the PC. Else, it won't be so practical.

Thank you in advance.

DZ

Hi DZ,

If you could share your existing macro, will try to figure out your problem

Thanks & Regards,
Vidhya