I need to set up a For, Next routine that checks each cell in Column J to see if it equals "Average". If it does, I have a series of If commands, otherwise, it needs to move to the next row. I anticipated doing this by defining a counting variable to be the row number and just using J as the Column, but i am not sure how to reference a cell where the Column is known, but the row is variable. Here's my rough sketch of the idea:
For DataRow = 2 to LastRow [LastRow is calculated earlier]
If JDataRow = "Average"
......
Next DataRow
For DataRow = 2 to LastRow [LastRow is calculated earlier]
If JDataRow = "Average"
......
Next DataRow