Advanced Filter when using Date Range Cells

J

Jim

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
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top