Retrieve rows in Excel 4

[newbiewonkinobie]

On sheet 2 there are 7 columns:
A1 is Job #
B1 is Client Name
C1 is Product Ordered
etc.
On Sheet 1, in cell A1 I want to enter a job #, then it will copy all rows with the matching job #'s from Sheet 2 to Sheet 1. Any suggestions?

Flores

 

[sdraper]

Dale,
If you don't mind, could ya send me a copy of the file as well?
sdraper@ilsos.net
thanks!

Sam

 

[newbiewonkinobie]

Sdraper,
it is sent.

Flores

 

[sdraper]

newbiewonkinobie,
I received the workbook. Thanks! Pretty nifty. I need to play around with advanced filters.

Sam