PDA

View Full Version : Select Row Based off remote cell value



futbalfantic
09-18-2010, 12:21 PM
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?

someboddy
09-18-2010, 12:31 PM
With Sheets("scoring page").Cells(Sheets("selection page").Range("C1").value,<column>)
.value=.value+1
End With

Where <column> is the number of the column you want to increase by 1.

futbalfantic
09-18-2010, 01:32 PM
Awesome will work like a charm