Select your range
data|filter|autofilter
use the filter arrow to choose f$n4w4 to show just those rows.

Copy the visible rows and paste to a new worksheet.

Thrain wrote:

Sheet 1 looks like this:

f$nXwX adj NIT HAND BOARD P PRWIN PRTIE
f$n4w4 2.00 100k AcAd AhAs2c 1 1.00 0.00
f$n4w4 1.50 100k AcAd AhAs2c 2 1.00 0.00
f$n4w2 1.33 100k AcAd AhAs2c 3 1.00 0.00
f$n4w2 1.25 100k AcAd AhAs2c 4 1.00 0.00
f$n4w2 1.20 100k AcAd AhAs2c 5 1.00 0.00
f$n4w3 1.17 100k AcAd AhAs2c 6 1.00 0.00
f$n4w4 1.14 100k AcAd AhAs2c 7 1.00 0.00
f$n4w3 1.12 100k AcAd AhAs2c 8 1.00 0.00
f$n4w4 2.00 100k Ac2c 3c9cQc 1 0.98 0.00

I want to create a sheet that lists all the rows with f$n4w4, like
this:

f$nXwX adj NIT HAND BOARD P PRWIN PRTIE
f$n4w4 2.00 100k AcAd AhAs2c 1 1.00 0.00
f$n4w4 1.50 100k AcAd AhAs2c 2 1.00 0.00
f$n4w4 1.14 100k AcAd AhAs2c 7 1.00 0.00
f$n4w4 2.00 100k Ac2c 3c9cQc 1 0.98 0.00

I have tried many things but am having a real problem figuring this
out... any clues? Thanks a million!!

--
Thrain
------------------------------------------------------------------------
Thrain's Profile: http://www.excelforum.com/member.php...o&userid=29192
View this thread: http://www.excelforum.com/showthread...hreadid=490246

--

Dave Peterson