I know I can filter, but I want to create a report based on the rows that
apply to a specific name. I'd like to report on a separate worksheets for
other users who don't know how to filter.

Can you explain what find tools.is?

"nader" wrote:

you can use the filter or find tools.is this your means?

"Cyndi513" wrote:

Good morning. A couple of years ago I saw a formula that would allow you to
look up info in a column (the NAME column below) and return all the data in
any row that found a match. So, you could have a separate worksheet that
would return all rows that had the name "Smith" or whatever in the Name
Column. Can somehow help me figure out that formula? Thanks. Cyndi

Jnl Date Trans# Description Account Amount Name
7/1/08 09-000001 Grad Lunch 623812 75.00 Smith
7/2/08 09-000002 Conf Reg Fees 623868 112.00 Smith
7/3/08 09-000003 Telephone 611111 66.00 Jones
7/1/08 09-000004 Staff Lunch 623812 88.00 Jones
8/1/08 09-000005 Cell phone 611150 99.99 Jackson
7/14/08 09-000006 Telephone 611111 108.10 Jackson