+ Reply to Thread
Results 1 to 1 of 1

Script to check counts in a csv daily and send notification when there's a >10% variation

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Lightbulb Script to check counts in a csv daily and send notification when there's a >10% variation

    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!
    Attached Files Attached Files
    Last edited by lindomsm; 05-28-2013 at 10:40 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1