Adding the same cell across several worksheets...

[Jeff Steele]

...Formula for adding the same cell across several worksheets in the same workbook, including when a new worksheet is inserted...? le:

 

[nevillestoke]

Right click on the tab of any worksheet and "group the worksheets". Then insert whatever you want into any cell and it will be inserted into all worksheets. I think you will have to refresh this when a new sheet is inserted.

 

[Aladin Akyurek]

Insert 2 extra worksheets, name them First and Last, and put all the relevant worksheets between First and Last. Now you can use a 3D formula...

=SUM(First:Last!B10)

Adjust for B10.

 

[nevillestoke]

Sorry -I think I mis-read that you wanted to add a new cell content into each worksheet within a workbook.

 

[Jeff Steele]

Nope, this is exactly what I needed...thank you very much...