Sunshine4u
New Member
- Joined
- Mar 26, 2019
- Messages
- 1
Good Morning Everyone;
I am somewhat proficient in excel. I have an workbook that I am working on. I have a invoice template on one sheet with 2 columns that have a drop down box. The other 3 have qty., unit price and total. The second sheet has a list of products and the fragrance they come in. Chart type. What I am trying to do is when I have a customer buy something with a fragrance I use the drop box to locate the fragrance. The second drop down box has what the items come in ex. bath bombs, hand cream, etc. what I would like to do as I enter what the customer buys I would like to keep count in my product sheet of how many of that item sells. Hope this makes sense what I want to do. Thank you for help.
I am somewhat proficient in excel. I have an workbook that I am working on. I have a invoice template on one sheet with 2 columns that have a drop down box. The other 3 have qty., unit price and total. The second sheet has a list of products and the fragrance they come in. Chart type. What I am trying to do is when I have a customer buy something with a fragrance I use the drop box to locate the fragrance. The second drop down box has what the items come in ex. bath bombs, hand cream, etc. what I would like to do as I enter what the customer buys I would like to keep count in my product sheet of how many of that item sells. Hope this makes sense what I want to do. Thank you for help.
