#1
|
|||
|
|||
new to VBA help comparing two sheets
I know very little VBA (very adept in SQL) and I am hoping someone could assist me so I can learn from this initial effort.
I want to compare two spreadsheets with the same column order and naming convention. However, I want to highlight the differences in the base spreadsheet (Sheet1) that only has a subset of data of the other sheet (Sheet2). There is a primary key (Column A) in both spreadsheets. Desired workflow: IF Colum A id Sheet 1 is in Column A Sheet2, then compare each adjacent column for differences. Example: If Sheet1!Column A1 id = Sheet2!A9 id, then compare Sheet1!B1 to Sheet2!B9, so and so on. Highlight the differences on Sheet1 Also, I have some disparate values for some columns that should be treated as matches. For Example column C in both Sheets need to be equal when the following occurs Sheet1!column C value is “NEW” and Sheet2!columnC value is “Pipeline” they should be a match Any help with this is greatly appreciated and will serve as a basis for me in the future. |
#2
|
||||
|
||||
Hi
Please post a small sample sheet showing what you have and expected results. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to manage some sheets and sub-sheets? | tesoke | Excel | 6 | 11-15-2015 04:54 AM |
Comparing two sentences in two different columns | JoAndRoPo | Excel | 5 | 08-07-2014 07:44 AM |
comparing data | sjp1966 | Excel | 6 | 07-23-2014 11:43 AM |
Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
Comparing Data | leroytrolley | Excel | 1 | 08-09-2008 08:34 PM |