I have a workbook with 32 sheets, one sheet for each day, multiple formulas on each sheet. Then I have one sheet that is the monthly totals.
I want to copy cell information from each of the 31 sheets and put them on the monthly.
ex. sheets 1-31 has a cell for total hours, on the monthly I have a column with 31 rows and I want data from the daily sheets to go here.
each sheet (1-31) hours are in the same cell. I can type in each (=sheet1!a1), but there should be an easier way. Ive tried using =sheet1!$a1, but I'm not for sure how to make it advance one sheet.Thanks
I want to copy cell information from each of the 31 sheets and put them on the monthly.
ex. sheets 1-31 has a cell for total hours, on the monthly I have a column with 31 rows and I want data from the daily sheets to go here.
each sheet (1-31) hours are in the same cell. I can type in each (=sheet1!a1), but there should be an easier way. Ive tried using =sheet1!$a1, but I'm not for sure how to make it advance one sheet.Thanks