Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to identify offset data and execute multiple formulas | Excel Worksheet Functions | |||
Multiple formulas in Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2003 - Referencing data in a table to use in formulas | Excel Worksheet Functions | |||
Fill Data across multiple Worksheets - Formulas | Excel Discussion (Misc queries) | |||
enter data into multiple formulas at once | Excel Worksheet Functions |