i have 2 excel file and want to compare it using macro, generated into another file, is it possible to do this?
fileA.xlsx (Sheet1)
<tbody>
</tbody>
fileB.xlsx (Sheet2)
<tbody>
</tbody>
what i want is i want to compare value in cell A2 (under fileB.xlsx) again array A2:A5 under fileA.xlsx, if not found then write to other files
how to create a macro for this purpose?
thx
fileA.xlsx (Sheet1)
| ColumnA | ColumnB |
| Name | ID |
| John | 12345 |
| Lex | 55123 |
| Rex | 88888 |
| Xia | 77117 |
<tbody>
</tbody>
fileB.xlsx (Sheet2)
| ColumnA | ColumnB |
| Name | ID |
| John | 12345 |
| Rex | 88888 |
<tbody>
</tbody>
what i want is i want to compare value in cell A2 (under fileB.xlsx) again array A2:A5 under fileA.xlsx, if not found then write to other files
how to create a macro for this purpose?
thx
