Let's say I have a data table in Excel that consists statistics of a population:
In percentage column, each cell is calculated by taking the ratio of "counts / total counts", in which the total counts is fixed to
Now, if I copy this table to another location, the total counts would still point to the original cell
B$8, while all other relative references update their locations automatically.
Is there an automated/smart way that I can make all formulas in the copied table to know the new location of total counts and use that new cell location instead?