+ Reply to Thread
Results 1 to 2 of 2

evaluate and add points then update a sheet

  1. #1
    Forum Contributor
    Join Date
    06-18-2015
    Location
    Milton Keynes
    MS-Off Ver
    2016
    Posts
    101

    evaluate and add points then update a sheet

    Hi Guys,

    I have an issue.

    I have a sheet with a user ID and a list of courses.

    The courses all have the same syntax. The course name, the level then 2 digits and then - Success if passed.

    If i've been successful I have uploaded my two files for reference. First is a csv that the results download in.

    The second has a macro, macro1. In this I'm trying to evaluate the course name.

    If it has success in it I want it to add up the "points" for all the passed modules and then write this info onto sheet1.

    Everything I have tried keeps failing. Can you have a look at the macro and find out why the case and look up isnt working?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,349

    Re: evaluate and add points then update a sheet

    I just don't understand what you are trying to do.

    You would receive more response, if you upload a workbook with before/after out of the data(csv) you provided and the clear reason why.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-20-2018, 01:13 AM
  2. VBA - Evaluate returning #Value although working in a test sheet
    By myDomDom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2017, 06:56 AM
  3. Replies: 4
    Last Post: 01-26-2016, 05:08 AM
  4. [SOLVED] Using Offset function, want automatic update of 30 points of most recent data
    By BigBobBobson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2015, 09:30 AM
  5. Evaluate Multiple Data Points Against Single Criteria
    By fmulvaney in forum Excel General
    Replies: 3
    Last Post: 08-31-2010, 03:26 PM
  6. Format a chart to automatically update with last 26 data points?
    By laf2day in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-28-2005, 02:40 PM

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