I working on a baseball scoresheet. I want cell Q2 to read the cell contents
in column H of the active row, as I move the active cell up and down the rows
(i.e., if active cell is Y36, I want Q2 to read data in H35 (note it is
offset by one row).)

Cells G6:G53 = players names (batting order)
Cells H5:H52 = current data for the players, based on VLOOKUP formula,
which updates with each at-bat
Columns K:CE = results of each at-bat as the game is played

I don't believe I can use the active cell as a reference within a formula,
so I'll probably need a VB macro....any ideas? I saw a similar question on
this forum, but wasn't quite what I was looking for.