I have a macro that does an initial autofilter of my data based on a specified date range in column 1. I need to do a second sort and deletion of rows that have dates greater than my end date in column 2 and where column 3 equals --, New, Imported, Assigned or Error. Seems simple enough, but I'm stuck and haven't been able to get this to work.
here's what I have:
Please Login or Register to view this content.
You have a sheet I can apply this to? Do you have a sample "Final Result" page in this sample book?
Click GO ADVANCED and use the paperclip icon to post up your workbook.
NOTE: I only have Excel 2003, so can't do an Autofilter by 4 criteria at once like it appears you can.
Also, did you mean to put the two date1 and date2 values into the same cell, or was that an error?
Please Login or Register to view this content.
Last edited by JBeaucaire; 08-28-2009 at 06:20 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks