Hi Mark

If I understand you correct

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"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