-
autofilter with a cell as the criteria
Hi
I would like to be able to use an custom auto filter using the information from a static cell as the criteria.
Example; column a = order number
b = description
c = date (dd/mm/yy)
cell d1 will have a date - will be changed often
i would like to autofilter the date column 'C' but using the data in cell D1 as the filter criteria
Ideally I would like to use the <= value in D1
Any help will be appreciated
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules