Macro multiple exclude values

[#1]

Hello

Can someone help me to create a macro that will exclude from a field those 3 values

AMS Dealer

EMEA Dealer

APJ Dealer

in this field there is 100 other customer name

thanks

Franck

[Anil_Babu_Samineni]

Why do you need Macros, Macros not good at all. If you want forcibly then you may go ahead. But, I won't recommend you to do

You can achieve by help of Button with search sting

1) Create button and give Title and then create actions

     - Select in Field {FieldName and Search String like below -- ("AMS Dealer"|"EMEA Dealer"|"APJ Dealer")}

2) Select Excluded {Give FieldName}

[#3]

HI Thanks

I need to make a macro to paste a lot of graph to an excel, I must change the values in the field using macro

[marcus_sommer · Accepted solution]

I suggest to replace/remove those field-values within the script maybe within an extra field like [Customer Name for Export] and to use this within your exporting-task.

- Marcus

[#5]

HI

thanks but I don't understand how I can do this and than run it in the macro?

[#6]

I didn't make this report

but the field that choosing dealer or normal customer is like this

=IF(MarketingCustomerName='AMS Dealer' OR MarketingCustomerName='APJ Dealer' OR MarketingCustomerName= 'EMEA Dealer' , 'Dealers', 'Customers')

This is what you mean?

How I can select only Dealer for this field?

[#7]

Hello

I get it thanks a lot