Does anyone know how to code a listbox that is contains a list of names from worksheet1 so that when names are added they automatically appear in the listbox, and if a persons name is selected from the listbox their details that are stored
on worksheet2 go automatically to a designated area on worksheet3. Hope this makes sence. By the way I am using Excel 2011 for Mac.
Thanks