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?

 

[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'