Hi

I currently have a workbook containing thirteen sheets; one cumulative, YTD sheet and twelve monthly sheets that copy the information from the YTD sheet.

I need to take monthly meter readings and enter them into a spreadhseet. My customer wants a monthly report for each machine. With each monthly report I have a formula to take the previous month's figures from the YTD reading to obtain the current month's reading.

Eg., My cumulative spreadsheet will show Aug 100, September 250, October 325 and so September's monthly spreadsheet will show as 150, October's as 75 and so on. I have to change the formula for each monthly spreadsheet so it looks at the correct cell on the cumulative spreadsheet.

My question is, is there a formula I could enter that will not require changing each month?

Thank you.