Data Validation Query With Calculation

jayjavina

New Member
Joined
Feb 3, 2009
Messages
34
Hi excel guru's,

I would like to seek your help in creating a dynamic table for the total sale.
Below are a list of store supplies with different categories and vendors.

Here is what I want to happen.
  • Under the VENDOR section, I will have a drop down list that will show the different vendors that we have for the store. When I select that specific VENDOR, the CATEGORY section will only give me the option available based on the VENDOR
  • After I select the VENDOR and CATEGORY, only the PRODUCTS and QUANTITY will show in the table
  • The total price will compute the total quantity of each product based on the price/item
  • By Default, if I only choose a VENDOR or just the CATEGORY, the table will show "ALL" products based on the selected VENDOR or CATEGORY.

Hope this info helps...

Thanks!!!
Jay


CATEGORYPRODUCTVENDORAISLEQUANTITY PRICE/ITEM
FRUITSAPPLEOKCD10$0.25
FRUITSAVOCADOABCD10$0.35
FRUITSBANANACDOD2$2.00
VEGETABLESCABBAGECDOA10$2.50
VEGETABLESCARROTSOKCA4$0.50
HARDWAREDRILLABCC10$1.50
VEGETABLESGARLICABCA3$3.00
HARDWAREHAMMERABCC8$5.00
FRUITSMELONABCD3$2.00
HARDWARENAILCDOC10$0.50
VEGETABLESONIONSABCA4$5.00
FRUITSORANGECDOD5$3.00
VEGETABLESPOTATOCDOA2$2.00
HARDWARERIVETSCDOC6$1.00
HARDWAREWRENCHOKCC4$2.50
VENDOR:
CATEGORY:
PRODUCTSQUANTITYTOTAL PRICE

<tbody>
</tbody>


<tbody>
</tbody>
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top