Home » Forums » Open Source Learning Center » Question and Answer

previous sheets

Submitted by twinluvr on 28 January, 2014 - 02:55

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.

‹ Creating a 2nd list that is dependent on the 1st list VLOOKUP & IF together ›
»
Almir's picture

Use pivot table instead

Submitted by Almir on 31 January, 2014 - 08:14.

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

Submitted by pmyk on 28 January, 2014 - 09:42.

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.

»