Search and Find Macro
 

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

Search and Find Macro
 

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