Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two worksheets and would like to be able to parse a column of
data in the first worksheet and search for each value contained in the column in the second worksheet. If it is located, it would take the entire row from the second worksheet and copy it to a third worksheet. This would basically create a new worksheet containing only rows of data from the second worksheet which contained a value listed in the first. Is this possible? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The easiest would be to use datafilterautofilter
or look in vba help for FIND and FINDNEXT -- Don Guillett SalesAid Software "ClayShooters" wrote in message oups.com... I have two worksheets and would like to be able to parse a column of data in the first worksheet and search for each value contained in the column in the second worksheet. If it is located, it would take the entire row from the second worksheet and copy it to a third worksheet. This would basically create a new worksheet containing only rows of data from the second worksheet which contained a value listed in the first. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
use value in texbox to search through worksheet | Excel Discussion (Misc queries) | |||
better search: "make worksheet visible" | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |