| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search 2 spreadsheets and compare a value.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 spreadsheets | Excel Worksheet Functions | |||
| Compare spreadsheets | Excel Worksheet Functions | |||
| Compare Two Spreadsheets | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| How can I compare to spreadsheets | Excel Worksheet Functions | |||
Threaded Mode
