Search by Date

[Mickey]

Hi all,
I am using Excel to 'book' a large number of resources to a wide variety of
deployments on an 'ongoing' basis. i.e. The deployment workbook is emailed
to 'customers' on a weekly basis. Currently I hide the rows containing
deployments for weeks other than the following week.

Is it possible to create a search button that will request the user to enter
a date which will then return a list of all deployments for that date. It
would also be useful if the date search could be extended to show a result
from a range of two dates, i.e Search from 10-Aug to 16-Aug. I currently
use one column for dates and a weeks deployment would be listed once for
each day.

If I could add such a function I would then be able to email the workbook
and allow the customer to view future weeks. This is not easy to do at
present as the workbook contains booking for more than 250 staff who are
representing 5 different departments.

Thanks,
Mickey

 

[Tom Ogilvy]

When you say advanced option, did you mean using the custom item in the
dropdown of the Autofilter. there is also an Advanced filter - but I was
recommending using the Autofilter.