Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare columns
I've checked thru the Discussion group and found this subject has been asked
several times, but can't find something I can use. I am using Excel 2003 and have a wb with 2 sheets - 'Exposed' and 'Transactions'. I need to compare Column A in ws 'Transactions' to Column a in ws 'Exposed'. If there is a match, have the data show on the same row in Column b on ws 'Exposed'. The number of rows on both ws can vary anywhere from 500 rows to as many as 5000. I know the simple answer is to use VLOOKUP, unfortunately, there are multiple users (and PCs) using this wb and for whatever reason the formula does NOT always work and the data is being missed so I am looking for VBA. Even if the data in Column A could not be put into Column B, I would be happy if the cell was highlighted. Thanks -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare columns | Excel Programming | |||
Compare two columns | Excel Programming | |||
Compare Two Columns | Excel Worksheet Functions | |||
Compare columns | Excel Discussion (Misc queries) | |||
Compare all following columns when value is same | Excel Programming |