Search and Find Macro

[Brian Hearty via OfficeKB.com]

I have an Excel2002 worksheet with several hundred entries (rows), each entry
consists of several cells, the key cell entries being A = Ref Number; B =
Work Item, C = Received Date and E = Deadline Date.
I need to be able to search the list for those entries that contain a
Deadline Date equal to or earlier than today’s date and have all the results
listed in a separate tab, each result in the new worksheet (tab) to display
the Ref Number, Work Item and Received Date.
My limited knowledge tells me that this is too large a task for a normal
formula function and may require a Macro to be written.
I guess this would be an ideal job for a database but the users who access
this worksheet seem to be allergic to using databases!
Does anybody have any ideas as to writting a macro that would carry out this
task?


--
Message posted via http://www.officekb.com

[Norman Jones]

Hi Brian,

Try using Excel's built in Advanced Filter feature.

If you are not familiar with the intracasies of Advancd Filter, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xladvfilter01.html

Note particularly the section entitled: 'Extract Data to Another Worksheet'

---
Regards,
Norman



"Brian Hearty via OfficeKB.com" <u15211@uwe> wrote in message
news:56a6c544e4465@uwe...
>I have an Excel2002 worksheet with several hundred entries (rows), each
>entry
> consists of several cells, the key cell entries being A = Ref Number; B =
> Work Item, C = Received Date and E = Deadline Date.
> I need to be able to search the list for those entries that contain a
> Deadline Date equal to or earlier than today's date and have all the
> results
> listed in a separate tab, each result in the new worksheet (tab) to
> display
> the Ref Number, Work Item and Received Date.
> My limited knowledge tells me that this is too large a task for a normal
> formula function and may require a Macro to be written.
> I guess this would be an ideal job for a database but the users who access
> this worksheet seem to be allergic to using databases!
> Does anybody have any ideas as to writting a macro that would carry out
> this
> task?
>
>
> --
> Message posted via http://www.officekb.com