K
K. Georgiadis
I have three worksheets of identical layout (and in the
same workbook), the 3rd sheet being the where I aggregate
the numbers of the previous two. I am mystified by the
fact that the cell in the same position in sheet one is
assumed to be a relative reference (e.g., Sheet1!B24)
whereas cell B24 in the second sheet is automatically
assumed to be an absolute reference (e.g., Sheet2!$B$24.
Any ideas why this happens?
same workbook), the 3rd sheet being the where I aggregate
the numbers of the previous two. I am mystified by the
fact that the cell in the same position in sheet one is
assumed to be a relative reference (e.g., Sheet1!B24)
whereas cell B24 in the second sheet is automatically
assumed to be an absolute reference (e.g., Sheet2!$B$24.
Any ideas why this happens?