Search by Date
 

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

Search by Date
 

Cheers Tom,
I hadn't thought the advanced option would give me the date range facility,
I'll check it out when I get into work tomorrow.

Thanks,
Mickey

"Tom Ogilvy" wrote in message
...
This is already implemented in the form of the Autofilter under the data
menu. Unhide all your rows. Select a cell in the top row of y our data,
then in the menu Data=filter=Autofilter. Make your selection in the
dropdown in the date column.

for a range of dates, you can use the custom setting under the filter.

--
Regards,
Tom Ogilvy

"Mickey" wrote in message
...
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

Search by Date
 

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.

--
Regards,
Tom Ogilvy


"Mickey" wrote in message
...
Cheers Tom,
I hadn't thought the advanced option would give me the date range
facility,
I'll check it out when I get into work tomorrow.

Thanks,
Mickey

"Tom Ogilvy" wrote in message
...
This is already implemented in the form of the Autofilter under the data
menu. Unhide all your rows. Select a cell in the top row of y our data,
then in the menu Data=filter=Autofilter. Make your selection in the
dropdown in the date column.

for a range of dates, you can use the custom setting under the filter.

--
Regards,
Tom Ogilvy

"Mickey" wrote in message
...
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