| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare 2 x files with same colum labels but different aranged da
My files have the same data
ie File 1 Record Num Value Year..... 101 12 2007 file 2 Year Value Record... 2007 101 11 We are talking about 100 colums I do have the exact corelation between File a and 1 ie Column 1 - Column 3 Column2- Column 2 Column 3- column 1 What i want is to run a macro on File 2 and find the rows and cells that are different form file 1 remeber that the code should be the sama but what we are most interested are the values. The files have about 100 column long but I just added the first 3 What I got is compare tools that compare cell by cell but not in a relative manner ie they require that the colums ar in the same order |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINKING PDF FILES HAVING NAMES IN COLUM TO A PDF FILE IN A FO | Excel Discussion (Misc queries) | |||
| How to merge 2 Excel files that need to match on 2 different colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
| lookup in colum a and compare values in colum b | Excel Worksheet Functions | |||
Threaded Mode
