Good morning FDibbins,
Thank you for your comments, and sending me another solution that works excellent (Buran having sent one too)
The information about the wild cards, while I was aware of this, it was good that you included it for the benefit of others, and myself had I not been aware.
In my case, the spreadsheet information that I used in my submittal was only a test worksheet. In the actual worksheet, the words being looked for are not always in the same format (i.e. I might be looking for 'Received' and the person entering the data in column 'A' might in one instance enter "12/16/13 - Received", while in another instance "Received Only Part Of Payment") Hence, you can see the need of the Wild Cards.
Bottom line, you gave me a second solution and probably the one I will use. Thanks again![]()
Bookmarks