Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
lkd lkd is offline
external usenet poster
 
Posts: 6
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to identify offset data and execute multiple formulas davensocal Excel Worksheet Functions 1 September 23rd 08 01:04 AM
Multiple formulas in Pivot Table The Cherub Excel Discussion (Misc queries) 3 September 17th 08 02:04 PM
Excel 2003 - Referencing data in a table to use in formulas Rocketman Excel Worksheet Functions 8 February 28th 08 11:07 AM
Fill Data across multiple Worksheets - Formulas heater Excel Discussion (Misc queries) 1 February 22nd 08 11:05 PM
enter data into multiple formulas at once Fen Excel Worksheet Functions 1 October 18th 05 05:39 PM


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"