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.

This is a common approach, but honestly, you would be better off putting ALL
your data on one sheet and using the AutoFilter and other functions to pick
out the data you want to see........it's LOTS easier........

Vaya con Dios,
Chuck, CABGx3


wrote in message
...
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.

On Mon, 22 Aug 2005 18:53:11 -0400, "CLR"
wrote:

This is a common approach, but honestly, you would be better off putting ALL
your data on one sheet and using the AutoFilter and other functions to pick
out the data you want to see........it's LOTS easier........

Vaya con Dios,
Chuck, CABGx3


Thanks for the reply. I tried something like that, but It did not work
as I planned, I probably did something wrong. I will try again. Thanks
again.

I just had a few minutes to try this and although I would have to
change things around a little, it certainly does what I need...so
thank you.

You're welcome.......I think you will be happier in the long run, both with
this present situation and any future sheets of a similar nature......

Vaya con Dios,
Chuck, CABGx3



" wrote:

I just had a few minutes to try this and although I would have to
change things around a little, it certainly does what I need...so
thank you.