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 [TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]January[/TD]
[TD="width: 64"]February[/TD]
[TD="width: 64"]March[/TD]
[TD="width: 64"]April[/TD]
[TD="width: 64"]May[/TD]
[TD="width: 64"]June[/TD]
[TD="width: 64"]July[/TD]
[TD="width: 64"]August[/TD]
[TD="width: 64"]September[/TD]
[TD="width: 64"]October[/TD]
[TD="width: 64"]November[/TD]
[TD="width: 64"]December[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]
NEW
[TABLE="width: 704"]
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]February[/TD]
[TD="width: 64"]March[/TD]
[TD="width: 64"]April[/TD]
[TD="width: 64"]May[/TD]
[TD="width: 64"]June[/TD]
[TD="width: 64"]July[/TD]
[TD="width: 64"]August[/TD]
[TD="width: 64"]September[/TD]
[TD="width: 64"]October[/TD]
[TD="width: 64"]November[/TD]
[TD="width: 64"]December[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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 [TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]January[/TD]
[TD="width: 64"]February[/TD]
[TD="width: 64"]March[/TD]
[TD="width: 64"]April[/TD]
[TD="width: 64"]May[/TD]
[TD="width: 64"]June[/TD]
[TD="width: 64"]July[/TD]
[TD="width: 64"]August[/TD]
[TD="width: 64"]September[/TD]
[TD="width: 64"]October[/TD]
[TD="width: 64"]November[/TD]
[TD="width: 64"]December[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]
NEW
[TABLE="width: 704"]
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]February[/TD]
[TD="width: 64"]March[/TD]
[TD="width: 64"]April[/TD]
[TD="width: 64"]May[/TD]
[TD="width: 64"]June[/TD]
[TD="width: 64"]July[/TD]
[TD="width: 64"]August[/TD]
[TD="width: 64"]September[/TD]
[TD="width: 64"]October[/TD]
[TD="width: 64"]November[/TD]
[TD="width: 64"]December[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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