Hi Everyone!
I've been working on this problem for a while and I still can't figure it out. Essentially I will be taking a snapshot of data, and then comparing it to new data months later to find out what changed. I need a VBA code to highlight these differences even when rows/columns are inserted.
<colgroup><col span="5"></colgroup><tbody>
</tbody>
<colgroup><col span="6"></colgroup><tbody>
</tbody>
Anyone have suggestions? Index-match doesn't work because it won't recognize then rows/columns are inserted, so I guess I need some kind of two dimensional lookup? (Mary-Height was 66 now 68 = highlight)
Thanks!
I've been working on this problem for a while and I still can't figure it out. Essentially I will be taking a snapshot of data, and then comparing it to new data months later to find out what changed. I need a VBA code to highlight these differences even when rows/columns are inserted.
Original Data: | ||||
Age | Gender | Height (in) | Weight (lb) | |
Jim | 21 | M | 72 | 182 |
Sally | 23 | F | 69 | 120 |
Bob | 35 | M | 70 | 175 |
Rachel | 31 | F | 65 | 140 |
Mary | 27 | F | 66 | 147 |
Greg | 27 | M | 69 | 205 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
New Data (differences bolded): | |||||
Age | Gender | Shoe Size | Height (in) | Weight (lb) | |
Jim | 21 | M | 10 | 72 | 181 |
Sally | 23 | F | 7 | 69 | 120 |
Bob | 35 | M | 9.5 | 70 | 180 |
Brian | 29 | M | 9 | 70 | 186 |
Rachel | 31 | F | 6.5 | 65 | 140 |
Mary | 28 | F | 8 | 68 | 147 |
Greg | 27 | M | 11 | 69 | 205 |
<colgroup><col span="6"></colgroup><tbody>
</tbody>
Anyone have suggestions? Index-match doesn't work because it won't recognize then rows/columns are inserted, so I guess I need some kind of two dimensional lookup? (Mary-Height was 66 now 68 = highlight)
Thanks!