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!
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!