combobox issues

2 issues, appreciate your help: Q1: on user selection of rep name from col CF need to select new cell ref in col CG. code below is not working, fails on worksheetfunction, am open to alternate/simpler method. Q2: in col CF list of rep names I have 'future use' blank cells, I don't want those to show in combobox.

Please Login or Register  to view this content.

Q1:

Please Login or Register  to view this content.

Here's what I came up with. Let me know if you run into any problems.

Please Login or Register  to view this content.