Hi,
I know very little about VBA therefore I need your help. This is my problem.
Main Issue:
I download a csv report every day. This csv file has got 1000's of entries. I need to compare Column J of new.csv(downloaded today) vs Column J of old.csv(downloaded yesterday) on a daily basis. I also need to compare Column K of new.csv vs Column K of old.csv
Both columns contain numbers. Therefore, the comparison would involve a calculation of Column J of new.csv -(minus) Column J of old.csv & Column K of new.csv -(minus) Column K of old.csv
If the result of the calculation is greater than 0, display the results on the workbook that contains the macro. If the results are 0 or less than 0(negative), display the phrase "NO CHANGES". The results need to be displayed alongside Column B,C,D & E taken from any one of the csv files which contain additional info regarding the numbers in Column J & K.
The end result should look like this in the workbook that contains the macro:
<table>
<tr>
<td>Column B</td><td>Column C</td><td>Column D</td><td>Column E</td><td>Column J</td><td>Column K</td>
</tr>
<tr>
<td>England</td><td>London</td><td>Albany Park</td><td>Bexley</td><td>5</td><td>6</td>
</tr>
<tr>
<td>England</td><td>London</td><td>Aldwych</td><td>Westminster</td><td>NO CHANGES<td>3</td>
</tr>
</table>
I appreciate your help. Thanks.
I know very little about VBA therefore I need your help. This is my problem.
Main Issue:
I download a csv report every day. This csv file has got 1000's of entries. I need to compare Column J of new.csv(downloaded today) vs Column J of old.csv(downloaded yesterday) on a daily basis. I also need to compare Column K of new.csv vs Column K of old.csv
Both columns contain numbers. Therefore, the comparison would involve a calculation of Column J of new.csv -(minus) Column J of old.csv & Column K of new.csv -(minus) Column K of old.csv
If the result of the calculation is greater than 0, display the results on the workbook that contains the macro. If the results are 0 or less than 0(negative), display the phrase "NO CHANGES". The results need to be displayed alongside Column B,C,D & E taken from any one of the csv files which contain additional info regarding the numbers in Column J & K.
The end result should look like this in the workbook that contains the macro:
<table>
<tr>
<td>Column B</td><td>Column C</td><td>Column D</td><td>Column E</td><td>Column J</td><td>Column K</td>
</tr>
<tr>
<td>England</td><td>London</td><td>Albany Park</td><td>Bexley</td><td>5</td><td>6</td>
</tr>
<tr>
<td>England</td><td>London</td><td>Aldwych</td><td>Westminster</td><td>NO CHANGES<td>3</td>
</tr>
</table>
I appreciate your help. Thanks.