Hi,

First, the source code for your data validation is currently sitting at Column BJ2:BJ5. You may as well use J3:J6 instead. Putting the validation list so far outside of the range of your actual table will increase the size of your workbook unneccessarily.

I'm not quite sure on what you'd expect the macro to do. Can you explain what you want the user to input and what the expected outcome of the macro should be?