If that isn't clear.
I want this formula to change the Row reference $G$533, to the value in cell AK1.
When I change the value in AK1, to 534, I want the formula to change the row 533 to 534. Automatically, on change, a macro button, whatever.
=COUNTIF(DATA!$C$524:$G$533,AE2)
Ideas? Thanks.