vba for checking comparing the two files
Budget: $10 – $30 AUD
Hi Friends,
Hope you can help me, I got two excel files, x1 & X2 both contains identical columns (date ,reference number and amount), I need your help in regard to
1) Sort on the basis of Date & Reference Number (each files) -As same reference will repeat on different date
2). Open X!.xls add together amounts in accordance with same reference number and date, store this amount in another cell (may be end of this set), say xamt
3). Open x2.xls Do the same process as in the step 3, store in different name yamt
4) Copy both files in single sheet with all columns (Including xamt & yamt)
5. Check these calculated figures (xamt & Yamt ) are matching each other with same reference number & date loop , if matching just highlight, otherwise write not "Matching"
Please file attached files, thanks in advance , the result should be as in the third file, I also need VBA source code for this, as i need to check
Hope you can help me, I got two excel files, x1 & X2 both contains identical columns (date ,reference number and amount), I need your help in regard to
1) Sort on the basis of Date & Reference Number (each files) -As same reference will repeat on different date
2). Open X!.xls add together amounts in accordance with same reference number and date, store this amount in another cell (may be end of this set), say xamt
3). Open x2.xls Do the same process as in the step 3, store in different name yamt
4) Copy both files in single sheet with all columns (Including xamt & yamt)
5. Check these calculated figures (xamt & Yamt ) are matching each other with same reference number & date loop , if matching just highlight, otherwise write not "Matching"
Please file attached files, thanks in advance , the result should be as in the third file, I also need VBA source code for this, as i need to check