Consulting

Results 1 to 3 of 3

Thread: Select Row Based off remote cell value

  1. #1

    Select Row Based off remote cell value

    Back ground:
    I am building an easy to use score sheet for volleyball matches. The way I want to build the sheet is as follows: On the right side of the "selection page" is the list of players names, activeX buttons 1-9. When player "1" prefroms action "x" you press player 1's button then press action "x", and it is incrimented up one number on the "scoring page."

    So far I have the the "player buttons" working. When the player button is pressed the value in "C1" changes to reflect that it is active and via conditional formating the cell behind it turns green as well.

    What I want is a macro to look at "C1" and based off of that value move to the "scoring page", go to the acompaning row, move right the correct amount of cells and incriment the number the by 1. What I can not find is the code for the macro to look at the value in "C1" and do this. Any help?

  2. #2
    [VBA]
    With Sheets("scoring page").Cells(Sheets("selection page").Range("C1").value,<column>)
    .value=.value+1
    End With
    [/VBA]
    Where <column> is the number of the column you want to increase by 1.

  3. #3
    Awesome will work like a charm

Posting Permissions

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