All,
Thank you for letting me join your forum. My excel skills are okay in terms of vlookups, pivots and recording macros but i'm struggling with the query below:
I have sales data which is split quarterly into 4 periods. It broken down into product and actual quarterly sales and year to date sales. (year to date sales adds up the actual cumulative sales).
<tbody>
</tbody>
My question is that i want to retrieve the actual sales for Qtr 3 and the year to date sales for qtr 3 for each product by selecting the quarter in CELL C7 and bringing back the Quarter 3 data into the relevant product and sales category in cells C10 to D12.
I really hope that this makes sense and that my table helps.
I really appreciate your help.
Monce!
Thank you for letting me join your forum. My excel skills are okay in terms of vlookups, pivots and recording macros but i'm struggling with the query below:
I have sales data which is split quarterly into 4 periods. It broken down into product and actual quarterly sales and year to date sales. (year to date sales adds up the actual cumulative sales).
Row/Column | B | C | D | E | F | G | H | I | J |
1 | Actual Quarterly Sales | Year to date sales | |||||||
2 | Product | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
3 | A | 123 | 35235 | 7456 | 35437 | 123 | 35358 | 42814 | 78251 |
4 | B | 2423 | 3523 | 75457 | 5843 | 2423 | 5946 | 81403 | 87246 |
5 | C | 3453 | 55645 | 75475 | 9765 | 3453 | 59098 | 134573 | 144338 |
5 | |||||||||
6 | |||||||||
7 | Quarter | 3 | |||||||
8 | |||||||||
9 | Actual Sales | Year to date sales | |||||||
10 | A | ||||||||
11 | B | ||||||||
12 | C |
<tbody>
</tbody>
My question is that i want to retrieve the actual sales for Qtr 3 and the year to date sales for qtr 3 for each product by selecting the quarter in CELL C7 and bringing back the Quarter 3 data into the relevant product and sales category in cells C10 to D12.
I really hope that this makes sense and that my table helps.
I really appreciate your help.
Monce!
Last edited: