Hi All,
I am after a little help today.
I am wanting a way to be able to hide a line in the Data Validation List Drop Down if a cell equals zero.
So on my spreadsheet i have a stock inventory Control form with items in column F3:F6 on sheet 1 but want to block a line from showing up if the quantity is zero on sheet 2 in column K3:K8 until that item has more stock added to it in the table on sheet 2 in column B so the count doesn't go in the minus in column K on sheet 2.
Thanks
Bookmarks