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.
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.