Autofilter Returns No Results, Office 2007
May 18 2017, 02:17 PM
Joined: 18-October 06
I have googled this question and I see it comes up a lot but I don't know how to apply it to my situation. I have a sheet that I am auto filtering and then copying the visible cells to a new sheet, after some other formatting stuff, it returns to the master sheet ("MySheet") and checks for a new criteria and copies that. What I need to do is that if it checks for the filter criteria and it is not there to not copy/create a new sheet but to go to the next filter criteria. Is this possible?
I tried saying if the visible lines are > 1 go ahead and copy if not GoTo a line label but it did not work. I know GoTo isn't the best answer to begin with but I don't know how else to get it to skip all the copy/paste code (along with a bunch of other stuff I do to the copied data) and find my new filter criteria.
I would appreciate any suggestions.
I'm just a beginner...take pity on me.
May 18 2017, 03:49 PM
Utter Access VIP
Joined: 22-June 04
From: North Carolina
You can do a countif type function (or read an actual countif form the spreadsheet) to see how many times the condition is met in the data. If zero, don't do it.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
Please zip and attach samples. It makes life easier for those who have to figure out what you are trying to do. Thanks
|Search Top Lo-Fi||22nd May 2017 - 08:11 PM|