If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
set up a stock ordering system in excel working backwards
I am trying to set up a stock ordering system for my new business. I sell
gift hampers. The hamper is made up of several products. So, for example, I have sold 1 'sweet' basket [column B] I need the applicable columns that represent the individual items in the hamper [C - G] to automatically show quantities. Am I asking for the impossible. In my head it works. I am used to formulas going the other way. I would appreciate your feedback. |
#2
|
|||
|
|||
set up a stock ordering system in excel working backwards
Couple of methods depending upon how you're set up.
1. If entering basket types down column B you could use a cell with a COUNTIF formula for each type of basket. In X1 enter =COUNTIF(B:B,"sweet") Then in C2:G2(assuming titles in C1:G2) enter =$X$1 Same pattern for "fruit" or "canned goods" 2. Have Data Validation dropdown list in B2 with fruit, sweet and canned goods. Worksheet event code to add 1 to X1 when sweet is chosen from B2 dropdown. Gord Dibben MS Excel MVP On Fri, 16 Oct 2009 22:52:01 -0700, Devil's Isle Devil's wrote: I am trying to set up a stock ordering system for my new business. I sell gift hampers. The hamper is made up of several products. So, for example, I have sold 1 'sweet' basket [column B] I need the applicable columns that represent the individual items in the hamper [C - G] to automatically show quantities. Am I asking for the impossible. In my head it works. I am used to formulas going the other way. I would appreciate your feedback. |
Thread Tools | |
Display Modes | |
|
|