Use the Advanced filter from Data=Filter=Advanced filter. The cell where
you put the 123 and the cell above it (filled with the word Model) will be
your criteria range. Start from the sheet where you enter the 123 and want
the output.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
I am having trouble figuring out how to extract certian
data from one sheet and display onto a different.
I have:
model # desc
123 11 aaaa
123 02 ssss
456 63 dddd
456 78 ffff
789 98 gggg
789 97 hhhh

On a seperate worksheet I want to put Model-123 in A1 and
have all #'s and desc's populate that match 123.

any help will be appreciated