Reference "Cell Contents"

[mwhit]

Hello,

I have a worksheet with 25 different tabs by product line. All tabs are set up exactly the same. Depending on what time frame I am analyzing, the date range may change. Since all cells are set up the same, I have to change all tabs to be consistent.

For example, my formula is (C5*A2)+(B3*A3)
This formula may change but again it will apply across all tabs.

My issue: In addition to the 25 tabs, each tabs have 10 columns that must reference the formula. Of course the formula it will chnage accordingly

Is there a way for me to "reference" a cell contents by a formula and apply it to cells that I desiginate. In other words, my hope is to change the formula once and make a formula in the 10 columns on all tabs and have it update.

Any ideas would greatly be appreciated.

Thanks!

 

[drsarao]

I don't think it is possible without using VBA.

Create a 26th template sheet.

Edit any formula changes in this template ONLY.

After ANY changes, run the VBA macro which will copy all these formulas to the other 25 sheets.

The template can of course include even fixed text like heading etc also - which can again be programmed to be copied to other sheets.

The macro will be something on the line of:

Sub Refresh()
For i = 1 to 25

Sheets(i).Range("A1")=Sheets("Template").Range("A1")

'etc etc

next i
End Sub

 

[Titian]

In answer to the first part of your question - is it as simple as "grouping" all your tabs together e.g. Click Sheet1, hold down "Ctrl" and click Sheet 25.

Then in say cell "A1" enter =(C5*A2)+(B3*A3) and that formula will appear in cell "A1" in each tab.

Remember to "un-group" your spreadsheet immediately, by clicking on any sheet tab, or anything you continue to do will appear on every tab.

The same technique may help with the second part of your question also.