Hi Team
I have following data
| A/C | Account Details |
| 100 | Civil Work |
| 101 | Civil Work |
| 102 | Civil Work |
| 103 | Equipments |
| 104 | Equipments |
| 105 | Equipments |
| 106 | Equipments |
| 107 | Tools and Spares |
| 108 | Tools and Spares |
I have used Formula tool and written this Argument
IF Contains([Account Details], "Civil work")
THEN "AA"
ELSEIF Contains([Account Details], "Equipments") THEN "BB"
ELSE "CC"
ENDIF
I would like to create Macro tool. Where I can select Account details and output dynamically.
