Hi,
As you are looking for dynamic drop down based on the list in your excel file and want to implement VBA macros, I will do these for you. Please let me know details of the vba macro that you are looking for. I have checked the file attached. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project.
Quality work with high accuracy and 100% customer satisfaction is guaranteed.
Thanks and regards,
Peter