View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Merlyn Merlyn is offline
external usenet poster
 
Posts: 6
Default Absolute Cell References in Excel

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,