excel data requirement

[linga]

Dear all,
The sample data will be in below format,
Month Plant Material Vendor X Y Z B
01.2014 AAA 1234 100000 1000 500 100 600000
02.2014 BBB 5689 100001 2000 1000 100 550000
03.2014 AAA 5689 100000 3000 1500 100 533333.3
04.2014 BBB 5689 100001 4000 2000 100 525000
05.2014 AAA 1234 100002 5000 2500 100 520000
06.2014 BBB 5689 100003 6000 3000 100 516666.7
07.2014 AAA 5689 100000 7000 3500 100 514285.7
08.2014 BBB 5689 100001 8000 4000 100 512500
09.2014 AAA 1234 100013 9000 4500 100 511111.1
10.2014 BBB 5689 100014 10000 5000 100 510000
11.2014 AAA 5689 100000 11000 5500 100 509090.9
12.2014 BBB 5689 100001 12000 6000 100 508333.3
Plant and month combination:
Requirement
Case:1
Input From To
Month 01.2014 12.2014
Plant AAA
Material
Vendor
Output should be in below format:
Month Plant Material Vendor X Y Z B
01.2014 AAA 1234 100000 1000 500 100 600000
03.2014 AAA 5689 100000 3000 1500 100 533333.3
05.2014 AAA 1234 100002 5000 2500 100 520000
07.2014 AAA 5689 100000 7000 3500 100 514285.7
09.2014 AAA 1234 100013 9000 4500 100 511111.1
11.2014 AAA 5689 100000 11000 5500 100 509090.9
Case:2
Plant, material and month combination:

Input From To
Month 01.2014 12.2014
Plant AAA
Material 1234
Vendor
Output
Month Plant Material Vendor X Y Z B
01.2014 AAA 1234 100000 1000 500 100 600000
05.2014 AAA 1234 100002 5000 2500 100 520000
09.2014 AAA 1234 100013 9000 4500 100 511111.1
Case:3
Plant, material,vendor and month combination:

Input From To
Month 01.2014 12.2014
Plant AAA
Material 1234
Vendor 100002
Output
Month Plant Material Vendor X Y Z B
05.2014 AAA 1234 100002 5000 2500 100 520000

How to acheieve above requirement kindly suugest solution

Regards,
U.Linganathan