Hi Experts,
I am stuck again and could use some help. I think this is possible but I have not been able to get this to work. I have a column N (starting in row 5) that has a dropdown list in the cell. That dropdown list is tied to column CD. That is all working fine. What I need is VBA so that when a user clicks in Column N5 to the end of the list (could be any number of items) Excel automatically copies the value in Column J and places it in CD4 which will automatically update my dropdown list. Below is what I have tried which is not working at all. Any help at all would be greatly appreciated. Let me know if you need more detail.
Thanks
Please Login or Register to view this content.
Bookmarks