Hi , i have done some research and found out that you can link comboboxes, so for example if you enter monday you can select only dates that are a monday.How to do it exactly is a mystery to me, but i know it can be done.
But my question now is : Can it be done with DYNAMIC ranges? If yes how?
What is the problem:
In column A i have numbers : For example 639 ,640 , 641 etc.
These are always in Column A but the position of this number is variable because sometimes people add another prod.number so 1 row extra. And in between the numbers there are some blank cells.
Then in column D i have prod.numbers which are linked to that (641) number ( also some blank in between cells). All prod.numbers are unique.
I want 1 combobox that selects the 639etc. numbers . And the second combobox with the Prod.numbers and not all of them only the ones linked to the picked(639) number.
This how i did it before , only all values would enter and wrong data could be entered/selected. ( A 639 number to a prod.number that is not behind it)
Same for the 639 values
Example worksheet: Here you can see the layout , and what i mean. Now there is only 3 rows in-between 639 and 640 but this changes all the time.
Bookmarks