Hi
I have a table in Sheet II
<tbody>
</tbody>
I want a report in Sheet I, when i choose a vendor from the dropdown list (which i have created), I want the sum of the respective item against each month.
Eg: I choose Vendor XYZ
Vendor: XYZ
<tbody>
</tbody>
Please help.
Thanks in advance
I have a table in Sheet II
Month | Vendor | Diesel | Water | Cleaner |
Jan | XXX | 1000 | ||
Jan | XYZ | 1000 | ||
Feb | XYZ | 1000 | ||
Feb | YYY | 500 | ||
Feb | XYZ | 2000 | ||
March | XXX | 1500 |
<tbody>
</tbody>
I want a report in Sheet I, when i choose a vendor from the dropdown list (which i have created), I want the sum of the respective item against each month.
Eg: I choose Vendor XYZ
Vendor: XYZ
Month | Load | Item |
Jan | 1000 | Water |
Feb | 3000 | Water |
March | 0 | Water |
<tbody>
</tbody>
Please help.
Thanks in advance