Hello
I uses a data validation list to select the item i want.
This Data Validation List is built by a table and the items in the table is a defined name so that when i insert an item to the list, this new item is automaticcaly available in the data validation list without adjusting the look-up range.
Now i want that this validation list shows a default value.
Can someone help me with this.
And additional feature that i want if possible is that this default value is always shown also after that this validation is used and and and an item was chosen the previous time.
Thanks in advance
My best regards.
Bookmarks