Hi Experts,
Currently, I have a code to create a validation list that ignore empty cell from Column(B) of Worksheet(Data) at cell "L5" and has a formula at "M5" to lookup left value of "L5".
This is what I want to achieve:
Step 1. Create a validation list at "L5" and return lookup value at "M5"
Step 2. repeat step 1 until the value at cell "A1"
I am not good at this. I appreciate and help that improve this code.
See attached sample excel file.
Bookmarks