Im trying to create a scoring sheet to score my daughters basketball games.
I'm stuck, the score sheet is basically a table with 4 columns (periods 1
thru 4) and 12 rows (the 12 girls on the team).

In a cell (input cell 1) outside of the table, I manually enter 1,2,3 or 4
depending on the period we are playing.

I need the macro to select the column in the table(1 thru 4) based on the
period number I entered in input cell 1, next I need the macro to go down a
given number of rows (also specified in another cell; input cell 2)

Please Help !!!!