Macro Dynamic Select

[BRRLL99]

Hi

I have following data

G/L	G/L Acct
100	House Keeping Charges -  General
101	Consumption of tools and Spares
102	Maintance Expenses - Others
103	House Keeping Charges -  General
104	Consumption of tools and Spares
105	Maintance Expenses - Others
106	House Keeping Charges -  General
107	Consumption of tools and Spares
108	Maintance Expenses - Others

I have used Formula Tool to get the output:

Formula used :

 IF Contains([G/L Acct ], "HouseKeeping")
THEN "House Keeping"
ELSE "R&M"
ENDIF

I'm looking build a macro tool where I can have drop down list , in the above formula it is shown

THEN "House Keeping" .. I would like to replace it with "House marking" or "Dashboard " and so on

ELSE "R&M" I would to replace it with "A&B" and so on

I would like to have end user to select from drop down of lists.

G/L	G/L Acct	Results
100	House Keeping Charges -  General	House Keeping
101	Consumption of tools and Spares	R&M
102	Maintance Expenses - Others	R&M
103	House Keeping Charges -  General	House Keeping
104	Consumption of tools and Spares	R&M
105	Maintance Expenses - Others	R&M
106	House Keeping Charges -  General	House Keeping
107	Consumption of tools and Spares	R&M
108	Maintance Expenses - Others	R&M

[Christina_H · Accepted solution]

Here's a basic macro that will replace the values in your formula with others selected from a dropdown