+ Reply to Thread
Results 1 to 3 of 3

Macro for adding a number to a cell determined by a vlookup

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Perth, Australia
    MS-Off Ver
    365
    Posts
    6

    Macro for adding a number to a cell determined by a vlookup

    Hi all,
    Really hope someone can help.
    Putting together a spread sheet for entering the results of a school sports carnival.
    Want to be able to enter a student number into a cell then click a button for 1st, 2nd, or 3rd that activates a macro to cumulatively add the respective number of points onto their score. Having trouble with the macro if anyone can help.
    Many thanks

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro for adding a number to a cell determined by a vlookup

    Not enough information. Submit an example workbook which clearly demonstrates what you are tryting to accomplish.

  3. #3
    Registered User
    Join Date
    12-10-2014
    Location
    Perth, Australia
    MS-Off Ver
    365
    Posts
    6

    Re: Macro for adding a number to a cell determined by a vlookup

    Sorry. Just to clarify.
    Student number 7 comes 2nd.
    On the spreadsheet are a list of students with their associated numbers and scores.
    There is a cell where the number 7 can be entered whereby a vlookup can access their score which is say 10.
    There are 3 buttons on the page for 1st, 2nd and 3rd. When the 2nd button is clicked I want it to add 2 points onto their score so it is now 12 and clear the cell where 7 was entered.
    Hope this clarifies.
    Many thanks.

+ 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. [SOLVED] Construct a formula on a pre-determined cell for a pre-determined duration of cells
    By Shaun Gemiver in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2013, 11:14 AM
  2. [SOLVED] Sum a Range Determined by Two Vlookup formulas
    By bwaite87 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-14-2012, 02:11 PM
  3. Need macro to jump to specific cell determined by date.
    By mhelmers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 06:19 PM
  4. Adding Value of Cells, but Cell Determined by Dropdown List
    By concretetsunami in forum Excel General
    Replies: 4
    Last Post: 03-09-2010, 04:19 PM
  5. Macro - Hiding Columns determined by cell values
    By Stammski in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2007, 01:54 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