I have a worksheet full of transaction information about expenses. It's set
up to have date, description, amount, etc. as well as the name of the person
who was responsible for making the transaction. This worksheet will
basically become a data base of transactions made by various individuals. I
want to be able to create a statement of funding available by the person
responsible. The statement of available funding would be on a separate
worksheet. It will list all the transactions just that person made by
pulling them from the data sheet.

When you enter the person's name who is responsible, it will list all the
transactions from the other worksheet every time it encounters that person's
name in the column from the data worksheet. I've seen it work years ago but
can't figure out what formula to use.

If you've done this, please let me know how. Thanks for your help. Cyndi