I am trying to set up a workbook for a daily log sheet, one sheet for every day of the month. Into a cell, I want to enter a value, which would be a meter reading, then have the value from the same cell in the previous sheet subtracted from it and entered in an adjacent cell. This gives me the daily total on the sheet. So I can do this the hard way by putting in the formula, =Q10-'Thursday 01-01-2016'!Q10 into cell R10 in sheet 'Friday 01-02-2016', and this works fine, but I have to do this 6 different times for each day/sheet, and again for every month/workbook of the year. I know there has to be an easier way. I've tried setting up a sheet offset macro but I can not get it to work. Can someone walk me through this process, or am I going about it all wrong?
Thank you
Thank you