Here is the new sample attached.
Columns B to F --> These are the Quarterly numbers that are summed up based on the data query numbers in the range (G to AD)
Columns G to AD --> Month on Month numbers to be queried based on the drop down selection
Columns AE to AM --> These are the Quarterly numbers that are summed up based on the data query number in the range (G to AD)
Team 1 Sheet:
Exact same data range replicated in the Team1 to Team 9 (for sample I have put only 1).
However I need to display or query only these number rest I will calculate using sum or other formulas. Also there will be some calculation in the rows as well. I mean to say Row 1 should be queried by formula but Row 2 has a % calculation and based on the values from Row 1 and Row 2 I will calculate the value in the Row 3,
Row 4, 5,6 to be queried by formula.
Hope you can help on this.
Thanks in advance.