98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3d tables
3d tables
Resolved · Low Priority · Version 2007
Thu 26 Jun 2008, 16:27Delegate Jourdan said...
Jourdan has attended:
Excel Intermediate course
3d tables
is possible to combine data from differtly formatt5ed work sheets eg in sheet 1 colum b and in sheet 2 colum 2
Thu 24 Jul 2008, 10:42Trainer Rajeev said...
RE: 3d Formula
Dear Jourdan
Thank you for attending Excel 2007 Intermediate course. I hope you enjoyed the course and are finding the topics covered during the training useful.
The short and sweet answer to your question is that it is possible to use different data in the different columns which are located in different worksheets.
But in some cases when you have data for different Qtrs, Months, Years, Regions, etc.. in different worksheets then 3 D formula is most efficient. Please note that the alternative to 3 D formula is Consolidate feature. It is most efficient in situations when the row and column headings are similar across the worksheets. However, you can still apply this feature if the data you want to calculate is not the similar in all the worksheets.
I hope this answers your question.
If this has answered your questions may I request you to mark this post as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |
