Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A searching query
SHEET 1
record number access 1 red 2 yellow 3 blue 4 grey 5 white 6 black SHEET 2 record number access a thecatwasblue b blackdogs c red d twoblackdogs e onewhitesock I need to find every occurance of each cell in the the 'Access' column of SHEET 1 in the 'Access' column of SHEET 2. I then want to copy the entire row of SHEET 1 into SHEET 3 and then copy all the rows that the text appears in within SHEET 2 into SHEET 3 - bellow the SHEET 1 Copy. RESULT SHEET 3 record number access 1 red c red 3 blue a thecatwasblue 5 white e onewhitesock 6 black b blackdogs d twoblackdogs Can anyone help me please. Many Thanks, Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching a range with MS Query | Excel Worksheet Functions | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) |