| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching a sorting the exact value in the data list | Excel Discussion (Misc queries) | |||
| Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
Hybrid Mode
