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.

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

[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" 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
>
>

[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.

"Thrain" wrote:

>
> thanks for the replies. Unfortunately I cannot manually sort and paste.
> Rather, I need to write a function that auto-fills the worksheet.
>
>
> --
> Thrain
> ------------------------------------------------------------------------
> Thrain's Profile: http://www.excelforum.com/member.php...o&userid=29192
> View this thread: http://www.excelforum.com/showthread...hreadid=490246
>
>