Sorted list
 

Hi,

I have a worksheet that has the 5 followings columns: Date, Client, P.O.,
Quantity, Price.. The sheet has about 2 000 entries.

On another sheet, I want to pull the informations from the 5 columns
pertaining to a specific P.O. number by using that P.O. number as a
criteria.

Anybody has a suggestion on how to do it. I use Excel 2003.

Thanks

Guy

Sorted list
 

I suggest VLOOKUP- ideal for that application.

Sorted list
 

Sounds like an advanced filter could be used

http://www.contextures.com/xladvfilter01.html#ExtractWs



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"G Chartrand" wrote in message
...
Hi,

I have a worksheet that has the 5 followings columns: Date, Client, P.O.,
Quantity, Price.. The sheet has about 2 000 entries.

On another sheet, I want to pull the informations from the 5 columns
pertaining to a specific P.O. number by using that P.O. number as a
criteria.

Anybody has a suggestion on how to do it. I use Excel 2003.

Thanks

Guy