Copying formulas to multiple worksheets

Solved/Closed
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
Hi,
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 replies

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
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
3
This is helpful.
0