Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if i have a simple excel file listing like:
SKU SUPPLIER
12345 A
45678 A
23456 B
55678 A
How do i create a button to only show SKU's that are associated with supplier A?
Thanks for your help!
Is this what you are looking for? PFA
Best,
S
see image, add an action to the button
Do you want to select SUPPLIER=A or select SKU's associated with SUPPLIER A?
To select SKUs associated with SUPPLIER A, use Select in Field as the Action.
Field: SKU
Search String: ='=SUPPLIER=' & chr(39) & 'A' & chr(39)
The search string is a bit awkward because of needing to get the quotes in there.
-Rob