Hey people,
I'm pretty new to this forum and equally as new to VBA.
So here's my problem...
I receive a csv via FTP on a daily basis that has a single row of data with headings. The data is counts for the previous day of various metrics (please find an attached example).
In simplest terms, I want to write a script that checks the number of counts for every metric against the previous week's counts (so 6 previous reports), and sends a report/notification to me when there is a =>10% fluctuation of the count number for any metric. All of the daily reports will exist in the same folder and the file names will be yyyy-mm-dd_XXXCounts.
I have no idea how difficult this is or if there's a better way of doing this. Can anyone advise me on the best way to start this? What I should do first?
I'm not looking for someone to do all the work for me as I do want to learn, more so a push in the right direction!
Your help is much appreciated!
I'm pretty new to this forum and equally as new to VBA.
So here's my problem...
I receive a csv via FTP on a daily basis that has a single row of data with headings. The data is counts for the previous day of various metrics (please find an attached example).
In simplest terms, I want to write a script that checks the number of counts for every metric against the previous week's counts (so 6 previous reports), and sends a report/notification to me when there is a =>10% fluctuation of the count number for any metric. All of the daily reports will exist in the same folder and the file names will be yyyy-mm-dd_XXXCounts.
I have no idea how difficult this is or if there's a better way of doing this. Can anyone advise me on the best way to start this? What I should do first?
I'm not looking for someone to do all the work for me as I do want to learn, more so a push in the right direction!
Your help is much appreciated!
