Reference "Cell Contents"

mwhit

Board Regular
Joined
Feb 20, 2006
Messages
163
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!
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

drsarao

Well-known Member
Joined
Sep 9, 2009
Messages
1,143
Office Version
  1. 2007
Platform
  1. Windows
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

Well-known Member
Joined
Dec 17, 2004
Messages
567
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,331
Messages
5,601,006
Members
414,420
Latest member
Richie77777

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top