M
Merlyn
Greetings, All,
I'm doing gross arithmetic functions on various pivot table results. The
pivot table is Access-driven, and the target cells move around, based on the
query results.
I want to ensure that if a column or row drops out, or, conversely, if rows
are columns are added by the query, the calculations "follow" the target
cells.
I believe this can be accomplished by the "$" in the cell designator, but I
want to ensure I'm using it properly.
Regards,
I'm doing gross arithmetic functions on various pivot table results. The
pivot table is Access-driven, and the target cells move around, based on the
query results.
I want to ensure that if a column or row drops out, or, conversely, if rows
are columns are added by the query, the calculations "follow" the target
cells.
I believe this can be accomplished by the "$" in the cell designator, but I
want to ensure I'm using it properly.
Regards,