I have a CountA formula:
=COUNTA('0 Data Summary'!B10:B108)
and a macro that creates a new client data row in row 10 every time and all other client data shifts down by one row. It works fine but, when a new row is inserted in row 10 via macro (for a new client add) the formula changes to:
=COUNTA('0 Data Summary'!B11:B109)
I want it to keep the B10
and not change to B11
. The change to 109
is fine because I want it to remain within the range.
I tried putting in the dollar signs but it didn't work.
=COUNTA(INDIRECT("'0 Data Summary'!B10:B108"))
.=COUNTA(INDIRECT("'0 Data Summary'!B10:B"&ROW(108:108)))
=COUNTA(INDEX(B:B,10):B108)