I have auto filter in macro then copy the filtered file to a different sheet. However, what if there is nothing filtered? He cannot copy anything. How should the script be that it will skip to the copying code and jump to the next filter that has data?