Copying formulas to multiple worksheets

mmikey45 Posts 6 Registration date Saturday November 8, 2014 Status Member Last seen November 8, 2014 - Updated on Jan 29, 2019 at 08:40 AM
 subodh - Feb 2, 2019 at 11:40 PM
I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet.
I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page referencing the range from only its own cells not the other worksheets.

10 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 8, 2014 at 10:35 AM
mmikey45, Good morning.

Suppose your sheets have the name: Plan1 Plan2 Plan3...Plan31
You want sum an A10 cell about all sheets.

Try to do:
At SUMMARY, any cell: =SUM(Plan1:Plan31!A10)

Is it what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
This is helpful.