logo elektroda
logo elektroda
X
logo elektroda

[Solved] Excel Order Form: Check Item Availability with Customer's Week Selection

bobi70 3231 3
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 17231197
    bobi70
    Level 14  
    Hello.
    Maybe excel is not my strongest side, but I'm doing a bit.
    I have a problem to solve with the customer order form.
    The list of goods contains several hundred items.
    For each item, one of the cells has a list of weeks of the year in which the item is available. For example - 1 2 7 10 15. Weeks are expressed digitally. As one or two digital characters ranging from 1 to 52, and numbers separated by spaces.
    From the drop-down list, the customer selects the week number for which he places the order.
    I wanted to make the appropriate cell appear with each item that does not match the aforementioned availability list, the signature "not available" or "available".
    I am asking for ideas about the method of implementation.
  • ADVERTISEMENT
  • #2 17231709
    waxman
    Level 21  
    If you can't put these week numbers in separate columns, start practicing visual basic for application. If you can have these numbers in separate columns (instead of spaces), you will leave it with formulas - the rest is a matter of googling
  • ADVERTISEMENT
  • Helpful post
    #3 17231718
    adamas_nt
    Moderator of Programming
    For example, with the formula as in the appendix.

    Edit: formula correction
    Code: Text
    Log in, to see the code
  • #4 17231750
    bobi70
    Level 14  
    Thank you adamas_nt.
    I'm not that far in Excel. Your idea does the trick!
    I close
ADVERTISEMENT