| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Active row cell reference
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active cell as a reference to open a worksheet | Excel Worksheet Functions | |||
| Active Cell Reference | Excel Worksheet Functions | |||
| HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
