Advanced Filter Problem

**M_Easty** · 11-19-2013, 04:28 PM

I am trying to use advanced filter to pull data from one of my company reports regarding employee worked hours. I've done this before but it's been a few years in a previous version of Excel and I am only getting half the info I need at this point.

I have a company report that lists all the worked hours for each employee for the previous week. I need to filter by their status, either full or part time as indicated by F or P, as well as total worked hours IE <40. I am also moving the data to a separate tab in the workbook since I have to create 4 different filters.

my problem is that when I apply the filter it just pulls all the data from the data source without applying either filter, the criteria is correct and I even checked for phantom spaces and that didn't make a difference. All of the header labels match. Any thoughts?

**daffodil11** · 11-19-2013, 05:05 PM

Can you paste an example of your source code?

I've written about a dozen of these things, so I could probably tell just by looking at your VB.

Something like:

Please Login or Register  to view this content.

If you're willing to attach an example workbook with sensitive data removed, I'll gladly send it back with the working macro. (I hope!)

**M_Easty** · 11-19-2013, 05:18 PM

I don't how to pull up the source code but I can send the file if you PM me an email address

**daffodil11** · 11-19-2013, 05:23 PM

I'll take a crack at it and post any pertinent technical information that may assist others with whatever issues I find.

**daffodil11** · 11-19-2013, 06:42 PM

Having reviewed OP's file, it appears the filtering issue was caused by strange exporting formats.

Values and strings were both being stored in non-recognized formats.

I was able to work with the data by copying sample cells from the source data into the filter cells to acquire the same formats. Then, I entered an extraneous 1 in an empty cell and selected all of the source data and used Copy -> Paste Special -> Multiply to force Excel to evaluate all numbers and string values.

Advanced Filter Problem

LinkBack

Thread Tools

Rate This Thread

Display