global5665
New Member
- Joined
- Apr 2, 2017
- Messages
- 2
There are five particulars in summary sheet, and i want data accordingly from RCU MIS Sheet.
Particular:
1. Date (C2) - I want data here as per data from RCU MIS, let's say if i select 03-03-2017 then No. and Value should be populated as per RCU MIS data.
2. MTD Sum (E2) - Here MTD stands for Month till date, if i select date in cell Q1 and Q2 than i want sum of Total No. and Value during these period from the RCU MIS Sheet.
3. MTD Avg (G2) - As mentioned above here i want Average of No. and Value instead of sum from the RCU MIS sheet.
4. YTD Sum (I2) - Here YTD stands for Year till date, here if i select drop down from Cell T1 and T2 than i want sum of total No. and value during these period from the RCU MIS sheet.
5. YTD Avg (K2) - Same here, i want average of No. and Value instead of sum from the RCU MIS Sheet.
Guys please help me solve this issues ASAP.
Thanks.....
Particular:
1. Date (C2) - I want data here as per data from RCU MIS, let's say if i select 03-03-2017 then No. and Value should be populated as per RCU MIS data.
2. MTD Sum (E2) - Here MTD stands for Month till date, if i select date in cell Q1 and Q2 than i want sum of Total No. and Value during these period from the RCU MIS Sheet.
3. MTD Avg (G2) - As mentioned above here i want Average of No. and Value instead of sum from the RCU MIS sheet.
4. YTD Sum (I2) - Here YTD stands for Year till date, here if i select drop down from Cell T1 and T2 than i want sum of total No. and value during these period from the RCU MIS sheet.
5. YTD Avg (K2) - Same here, i want average of No. and Value instead of sum from the RCU MIS Sheet.
Guys please help me solve this issues ASAP.
Thanks.....