Creating a Button

[#1]

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!

[sunny_talwar · Accepted solution]

Is this what you are looking for? PFA

Best,

S

[maxgro]

see image, add an action to the button

[rwunderlich]

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