I am venturing into very new waters with some Code.
What I want is to enter a name and e-mail list through the form. The name is then entered into a column E and copied into column A that automatically alphabetizes the list for a dropdown list and a column reference is entered in the next column B using vlookup so the column references remain with the proper name.
Ideally when a new name is entered in column E, column F is updated to the next column references, the name is copied to column A and the lookup formula in column B is copied down.
I hope this makes some sense. If you have any questions let me know.
Thanks, Jim O
Bookmarks