Let's say I want to create a vendors list that I save on one sheet and update it everyday when I deal with new vendor
Then in one project , I want to issue a new PO for one Vendor , I want to create drop-down ready list that show all the vendors in one list , so I could select one of the list easily and not write /add the new vendor every time
Is there any way to create that ready list / or pre-defined range
'Thanks
