Hi guys
I have three data validations in OUTPUT sheet in columns B,C,D , linked with columns B,C,D for INVOICE sheet like this
=INVOICE !$B$2:$B$100,=INVOICE !$C$2:$C$100,=INVOICE !$D$2:$D$100
what I look for when shows any data validation should not show any empty and any duplicates items , also I want populate the items into data validation dynamically without increase the range manually when I need add more items more than row 100 for each column .
thanks
I have three data validations in OUTPUT sheet in columns B,C,D , linked with columns B,C,D for INVOICE sheet like this
=INVOICE !$B$2:$B$100,=INVOICE !$C$2:$C$100,=INVOICE !$D$2:$D$100
what I look for when shows any data validation should not show any empty and any duplicates items , also I want populate the items into data validation dynamically without increase the range manually when I need add more items more than row 100 for each column .
thanks