I have two fields Product category and Product...We have seperate sheet for each category and have default selections while opening the sheet...
While opening the Cat1 sheet, Product which comes under Product category="Cat1" will be selected. We have 15 Products under "Cat1" and totally 50 prodcuts...
And in the current selection it is showing like Product: 15 of 50...
Instead of showing the number(15 of 50) can we show the text like "Cat1 Products" in the current selection...