Automatically replacing a value in an excel report

Report
Posts
10
Registration date
Monday March 25, 2019
Status
Member
Last seen
August 6, 2020
-
Posts
2646
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 1, 2020
-
Hello,
I have a CAB Report template with a column called "Change Type"
When I extract information the data in this column comes in as either Normal or Standard

I would like Excel to automatically convert "Standard" to "Request for a New Standard Change" every time the report is populated.

Could someone help me out with this, please? I was thinking of adding a macro to the report template but not sure what code to put in.

Many Thanks



System Configuration: Windows / Chrome 81.0.4044.129

1 reply

Posts
2646
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 1, 2020
432
Hi Nazcarr,

Could you show us how your CAB report looks?

Best regards,
Trowa