please see attached workbook.
currently, i have built this template and made it automatic with formula for example if you select any name in C2 all the other cells will be filled automatically.
i am looking for a VBA based solution where, the same operation is done without formulas in those cells. and they are done with worksheet change event. for example if i type any name or i select any name in the C2 then all of those cells populate as values and then if no match found then it should be left blank.
thanks for your usual help.