Excel 2002
I am setting up a Day End report of sales and expences to pull information
from various spreadsheets.
If the source sheet row moves the result is not accurate. For example if
within the source sheet rows are added or deleted and the "total" row moves
up or down, the report gives the wrong answer or a 0.
Is is possible to make a reference to a cell that is not static?