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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare 2 x files with same colum labels but different aranged da
On Nov 16, 9:32 am, stratis wrote:
My files have the same data ie File 1 Record Num Value Year..... 101 12 2007 file 2 Year Value Record... 2007 101 11 I'm not really sure what you are asking. But if you just want to find the different values, create a new sheet on file 2 and subtract the proper file 1 column values from the file 2 columns. Any value not equal to zero is different. Use conditional formatting to highlight those cells. No coding required. SteveM 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare 2 x files with same colum labels but different aranged
Maybe I was misunderstood
The 2 Xl file have the same data but layout differently All colums have a heading in both files . each record has a distict key So I want to compare the columns that are laouut in different order and spot the difference "SteveM" wrote: On Nov 16, 9:32 am, stratis wrote: My files have the same data ie File 1 Record Num Value Year..... 101 12 2007 file 2 Year Value Record... 2007 101 11 I'm not really sure what you are asking. But if you just want to find the different values, create a new sheet on file 2 and subtract the proper file 1 column values from the file 2 columns. Any value not equal to zero is different. Use conditional formatting to highlight those cells. No coding required. SteveM 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 |
Reply |
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 |