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.
Hope this info helps...
Thanks!!!
Jay
<tbody>
</tbody>
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
CATEGORY | PRODUCT | VENDOR | AISLE | QUANTITY | PRICE/ITEM | ||||||||||||||||||
FRUITS | APPLE | OKC | D | 10 | $0.25 | ||||||||||||||||||
FRUITS | AVOCADO | ABC | D | 10 | $0.35 | ||||||||||||||||||
FRUITS | BANANA | CDO | D | 2 | $2.00 | ||||||||||||||||||
VEGETABLES | CABBAGE | CDO | A | 10 | $2.50 | ||||||||||||||||||
VEGETABLES | CARROTS | OKC | A | 4 | $0.50 | ||||||||||||||||||
HARDWARE | DRILL | ABC | C | 10 | $1.50 | ||||||||||||||||||
VEGETABLES | GARLIC | ABC | A | 3 | $3.00 | ||||||||||||||||||
HARDWARE | HAMMER | ABC | C | 8 | $5.00 | ||||||||||||||||||
FRUITS | MELON | ABC | D | 3 | $2.00 | ||||||||||||||||||
HARDWARE | NAIL | CDO | C | 10 | $0.50 | ||||||||||||||||||
VEGETABLES | ONIONS | ABC | A | 4 | $5.00 | ||||||||||||||||||
FRUITS | ORANGE | CDO | D | 5 | $3.00 | ||||||||||||||||||
VEGETABLES | POTATO | CDO | A | 2 | $2.00 | ||||||||||||||||||
HARDWARE | RIVETS | CDO | C | 6 | $1.00 | ||||||||||||||||||
HARDWARE | WRENCH | OKC | C | 4 | $2.50 | ||||||||||||||||||
<tbody> </tbody> | |||||||||||||||||||||||
<tbody>
</tbody>