List matching data from sheet 1 in sheet 2

[Thrain]

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!!

 

[Dave Peterson]

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.

 

[William Horton]

Either Excel's AutoFilter or Advanced Filter functionality should work for
you. check out the help on both of those. Excel menu path Data / Filter /
XXX

Hope this helps.

Bill Horton

 

[Thrain]

thanks for the replies. Unfortunately I cannot manually sort and paste
Rather, I need to write a function that auto-fills the worksheet

 

[William Horton]

You'll have to use VBA code for that I believe. The VBA code would probably
utilize the autofilter steps that Dave & I presented.