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).
Essentially, 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'm not entirely sure how difficult this is going to be or if there's a specific way to go about it. Can anyone advise me on the best way to start this?
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!
Bookmarks