previous sheets

In Excel, how do I reference a cell in a previous sheet within a workbook? Each sheet is a day of the year starting with Jan 1st. I record my sales in a cell and a month-to-date in the next cell. On the Jan 2nd sheet, I want to take month-to-date and add to my daily amount. In Jan 3rd sheet, i want to take month-to-date from sheet Jan 2nd and add to Jan 3rd daily,etc.

Almir's picture

Use pivot table instead

I recommned putting all days together with a column of a day. Then create a pivot table based on that data. You can get MTD(month-to-date) figures using "Running Total" field settings.

Referencing Cell in another Sheet

In Sheet2 in D1,type this:
='Sheet1'!A1
This will give you pull the data from A1 of Sheet 1 and will put in D1 of Sheet2.