Yes! Here'a an example of how:

Assumptions:
Sheet1 contains the source list (with appropriate column headings)
Column Headings: Make, Model, Color, Other1, Other2, etc
Sheet2 is the destination for the filtered list.

Using Sheet2
A1: Color
A2: Red

C1: Make
D1: Model
etc..for the rest of the col headings

Select C1 through the last column heading you want returned
DataFilterAdvanced filter
Check: Copy to another location
List Range: (Switch to Sheet1 and select all of the data list)
Criteria Range: (Select Sheet2 range A1:A2
Copy to: Select the Sheet2 column headings beginning on C1
Click the [OK] button

That should return all of the referenced data for Red vehicles.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499837