I'll make this as simple as I can (for my sake :-) ,not yours )
Lets say I have a workbook with a sheet for each month.
Each months sheet has four colums.
DATE, NAME, CHECK NUMBER, AMOUNT
Now I want to set up 13th worksheet.
I want to have on this worksheet a list of one particular name and all
corresponding check numbers and amounts each time this name is used.
So basically I want to search for a particular payee and return the
check number and amount each time we send a check to this payee.
I want to end up with one sheet with a list of however many entries
that particular payee is used.
I hope this is enough info...and thanks in advance for any help.