Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Search Macro? | Excel Discussion (Misc queries) | |||
Find and search by column | Excel Discussion (Misc queries) | |||
search a row to find the column | Excel Worksheet Functions | |||
how to use the search dialog via a macro? | Excel Worksheet Functions | |||
Looping Macro to Find and Mark | New Users to Excel |