Pulling info from a list
 

I have 3 sheets. First sheet has data, consisting of names in left column,
followed by dates.

I want the second and third sheets to have a person's name, and to pull show
only the rows from the first sheet with the person's name in them. I know I
could filter the data in page 1, but i need to have the list on the second
sheet (and third) with the person's name on the tab.

Is there an easy way to do this? I have thought about VLOOKUP, and that
works for one row of data, but not multiple rows.

Thoughts?

Thanks, Patrick

Pulling info from a list
 

Nick Hodge has a webpage that explains how to use parameters in Excel to
query an Access database. That explanation works equally well for a database
maintained in Excel.

The page starts out with several examples of importing data, but the
paramater query info is at the bottom

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

"Patrick" wrote:

I have 3 sheets. First sheet has data, consisting of names in left column,
followed by dates.

I want the second and third sheets to have a person's name, and to pull show
only the rows from the first sheet with the person's name in them. I know I
could filter the data in page 1, but i need to have the list on the second
sheet (and third) with the person's name on the tab.

Is there an easy way to do this? I have thought about VLOOKUP, and that
works for one row of data, but not multiple rows.

Thoughts?

Thanks, Patrick

Pulling info from a list
 

Beautiful. Thanks for the help.

"Duke Carey" wrote:

Nick Hodge has a webpage that explains how to use parameters in Excel to
query an Access database. That explanation works equally well for a database
maintained in Excel.

The page starts out with several examples of importing data, but the
paramater query info is at the bottom

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

"Patrick" wrote:

I have 3 sheets. First sheet has data, consisting of names in left column,
followed by dates.

I want the second and third sheets to have a person's name, and to pull show
only the rows from the first sheet with the person's name in them. I know I
could filter the data in page 1, but i need to have the list on the second
sheet (and third) with the person's name on the tab.

Is there an easy way to do this? I have thought about VLOOKUP, and that
works for one row of data, but not multiple rows.

Thoughts?

Thanks, Patrick