Extracting Matching Data from 2 Excel Spreads

January 20, 2011 at 07:57:23
Specs: Windows 2003
Hello,
I have two spreadsheets containing multiple columns of data. I would like to be able to compare a column in spreadsheet 2 (containing alpha numeric codes) with a column in spreadsheet 1 (containing similar alpha numeric codes) and either extract or highlight the whole row in spreadsheet 1 with a code which matches any of the codes in spreadsheet 2.
Is this possible using Excel 2003?

Any help would be greatly appreciated


See More: Extracting Matching Data from 2 Excel Spreads

Report •


#1
January 20, 2011 at 13:21:54
re: "containing similar alpha numeric codes"

Containing simlilar alpha numeric codes or containing matching alpha numeric codes?

Those are 2 very different things.

re: "either extract or highlight the whole row in spreadsheet 1"

Do you really want to highlight the "whole row"? All 256 cells in the row?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question