I have tabular data which includes a Date column. Using an Autofilter, I want to show only the rows with dates within a data range. That range is defined elsewhere on the worksheet in two cells - one a start date the other an end date. I cannot see a way to have the Filter refer to cells - the criteria appear to have to be explicit picks. Is there a way around this??
BTW, the date range will be a tax year - which where I come from is 1 July to 30 June.
Not with an Autofilter. You could set up an Advanced Filter and point the criteria cells at your start and end date cells.
Post a sample workbook with the current layout if you want a worked example.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks