View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Advanced Filter when using Date Range Cells

Hey JB - Great Job with Providing examples - I got it to work. Thanks Much!

"JB" wrote:


http://cjoint.com/?bBsaliyufv

JB
http://boisgontierjacques.free.fr

On 25 jan, 17:39, Jim wrote:
Please help explain how to use Advanced Filter if looking to point formula
(criteria) at two cells for date range. If I enter under duplicate (column
headings) =9/18/8 (Dwg Date) and <=1/23/9 (Dwg Date) the filter works. I
can't get it to work by using ='Add Modify Project'!$AJ$24, etc. which are
cells located on other tab. I have spent hours attempting to get this to
work. Any help is greatly appreciated. Jim