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