Is it possible to write Excel formulas and reference the active cell as part
of the formula.
Use:
As you scroll you data, a cell at the top of the spreadsheet would show the
results of a formula that was being calculated based on where the cursor was
(active cell).