Thread: populate a separate sheet with rows found using a single value

Hello,

I'm trying to:

A) search for a value in a column (i.e., a person's last name)
B) in another place, print the whole row where each instance of the value is found.

In other words, the goal is to have a list of a list of rows plucked from the whole document, each of which was chosen because of a common value.

Can anybody give me a quick overview of how I'd do this? Even if you can't give me specifics, I'd love to know what I should be researching.

I really appreciate it.

Sam

If this something you'll be doing often, then you will probably want a VBA solution which will loop through a list of names. However, for a non-VBA approach that may work for you, take a look at using Advanced Filter with crtieria.

Start with this link: Extract Data to Another Worksheet