Hi, I need help as follows:
I have a Summary Sheet to display fixed data from adjacent sheets with same cell location i.e A8.
Each sheet name represents day of month (1, 2, 3---31)
Each sheet (Day) has data in Cell A8 that I need to display on the Summary sheet (='1'!$A$8) but now I would like to auto fill "Summary Sheet" having sheet number increment from 1 to 31 but cell ref to remain A8 therefore I us $A$8.
Doing it manually is time waist. Thanks.
I have a Summary Sheet to display fixed data from adjacent sheets with same cell location i.e A8.
Each sheet name represents day of month (1, 2, 3---31)
Each sheet (Day) has data in Cell A8 that I need to display on the Summary sheet (='1'!$A$8) but now I would like to auto fill "Summary Sheet" having sheet number increment from 1 to 31 but cell ref to remain A8 therefore I us $A$8.
Doing it manually is time waist. Thanks.
