Help please. I was given this spreadsheet to fix. It works fine in Excel 2003 but not in 2007. I have found that it is to do with the advanced filter but am not sure how to fix it.
The filter is to capture the data with either Start Date or End Date falls within Feb 2011 but the result only shows 5 items (i.e. P,O,A,N and B) missing C, E, F and J.Range("A11:v15000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _ Range("A1:v" & j), Unique:=False
I have attached here image shots of sample data and the result after filtered.
Your help is much appreciated!
Last edited by davesexcel; 10-25-2010 at 07:35 PM. Reason: code tags required please read the forum rules
It would be more practical if you posted the actual workbook or a sample with some typical data.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks