Advanced Filter when using Date Range Cells
Hi,
For calculated criteria do not use the same title as in the database, make
up anything else. this may be what the web sites told you but I don't have
time to read them.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"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
|