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
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
