Hi Guys,
I've been following for years and now i encountered a serious problem and i need your help.
It's about a VBA code /excel macro/ that compares the data from 2 different workbooks based on months/dates
i.e.
Example: 2 workbooks, this is a one sheet / i have several in the wb/
OLD
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>NEW
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>
I'd like the macro to compare find the month and compare it to the data in the NEW wb and if there are differences - highlight them.
Is this possible?
Thank you in advance!
Regards
I've been following for years and now i encountered a serious problem and i need your help.
It's about a VBA code /excel macro/ that compares the data from 2 different workbooks based on months/dates
i.e.
Example: 2 workbooks, this is a one sheet / i have several in the wb/
OLD
January | February | March | April | May | June | July | August | September | October | November | December |
5 | 7 | 7 | 8 | 7 | 3 | 8 | 4 | 4 | 7 | 10 | 8 |
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>
February | March | April | May | June | July | August | September | October | November | December |
2 | 2 | 6 | 4 | 8 | 8 | 6 | 5 | 2 | 4 | 1 |
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>
I'd like the macro to compare find the month and compare it to the data in the NEW wb and if there are differences - highlight them.
Is this possible?
Thank you in advance!
Regards