Thanks for the response. I was hopeful I could forego filtering as the
master spreadsheet gets refreshed every day, so any additions I make to it
are removed when its refreshed. I really want this to be a continuous loop
to read the records and give me particular fields for the rows which meet the
criteria. Eventually, I'm needing to concatenate the fields so the output
can be put in a text form for a client report. I'm trying to move away from
having to copy/paste these fields each time as there are now too many and
changes occur too often. If you need more info or if I'm not being clearn,
please let me know. Thanks again. The search is on.

"bakes1" wrote:


In a separate column to the right, I would write a flagging formula such
as:

=IF(AND(A1="GTO",TEXT(B1,"mmm")="Feb"),"Y","N")

Then you can use filter buttons at the top to filter for the Y's. My
formula assumes that you are looking for all February entries and
column B is formated as a date.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=517988