data table of multiple formulas

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top