Hi,

Sorry, i managed to get the file to work after saving it as "Macro-Enabled". Silly me.

But now the trouble is bigger. What i thought would have been a simple macro or some Data Validation tweaks has turned out be a nightmare (for me).

I initially shared just one Topic/Header to find out the solution to my drop down list. But in actual i have 4 Topics which have more selections under each topic. I thought I could easily replicate the solution provided to the other topics.


I have attached the file, with the actual template of my file.

Appraisal - Drop Down (VBA).xlsm

As you can see, Cell A25, A28, A31 & A34 are the Topics, under which the drop down items change. I feel it would be a real tedious task to integrate the macro in the attached format. I have done the write-up for all topics in Comments & Advise sheets, as per the previous file.

Will it be too complicated?