Advanced Filter when using Date Range Cells

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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

Similar Threads

Hlp! Named range Advanced Filter Criterion 10
Advanced filter 7
advanced filter issue 5
Excel Advanced filter - Filtering using dates 6
Data validation list using filtered range 3
unique records by advanced filter 10
Excel Sumproduct 0
Advanced filter using dates 2

Back
Top