![]() |
data table of multiple formulas
I am currently calculating various data in a format below for a given month:
Calc1 Calc2 Calc3 A B c So for a given month, I make a number of somewhat involved calculations and these calculations are pulling information from other tabs in my workbook. I have it set up so that I select a month on one of the tabs and I can display all the calculations as shown above for the given month in another tab. What I would like to be able to do is keep this functionality and add another tab that displays a view of all of the sets of calculations for each month. So it would look like this: Jan Feb Mar Calc1 Calc2 Calc2 Calc1 Calc2 Calc3 Calc1 Calc2 Calc3 A B C Is this possible using the data table function or is there another way? Thanks! |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com