List matching data from sheet 1 in sheet 2
 

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

List matching data from sheet 1 in sheet 2
 

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

List matching data from sheet 1 in sheet 2
 

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

List matching data from sheet 1 in sheet 2
 

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

List matching data from sheet 1 in sheet 2
 

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