Using multiple Advanced Filters/different ranges?

Hi Rob,

Sure, you can have multiple Advanced Filters in the same workbook. I used Named Ranges for my data and criteria (Dynamic Named Ranges really) and plug in the name in the Advanced Filter dialog. If you can show us a sample of what you have and/or tell us what error you are finding, we can help more.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Rob,

You are working on some advanced stuff with a userform that is modeless and trying to drive an Advanced Filter with it. I'm not sure of the exact order of steps you are doing but I hang when the column head doesn't get to Y4 on the Projects sheet. Advanced Filters needs to have the column head word spelled correctly above the filter value(s) in the criteria range. It doesn't look like your macro builds the criteria range correctly.

Another possible problem is you are programming using "CurrentRegion" which I think only is found on the active worksheet. You need to select that worksheet and then a cell to make the CurrentRegion work correctly. I also worry about your merged cells above where you want the current region to be. If the merged cells are taken to be the column heads for your filter, it won't work either. Another possible problem is having two column heads spelled exactly the same (or no text at all). I see you have Requirement for one table and Requirements (plural) for the other. Little differences like this can throw an error. IE, you filter for "Requirement" but the column head is "Requirements". Error as spelling is off.

I hope the above helps you find the Advanced Filter problem. I'd need to study a lot more and step through your code to be more specific, but I don't know what steps you are doing and what order.