I know very little about programming macros but I really need a macro or
something to solve the following: How do I search Column A in
spreadsheet A and keep ONLY matching values that are found in
Spreadsheet B? In other words, go through each cell in spreadsheet B
and see if that value exists in spreadsheet A (let's say in column A).
If it does not exist, delete that cell and go on to the next one. If it
DOES exist in spreadsheet A, simply go on to the next cell and repeat
the process.


--
jeff5656
------------------------------------------------------------------------
jeff5656's Profile: http://www.excelforum.com/member.php...o&userid=25605
View this thread: http://www.excelforum.com/showthread...hreadid=471096