I have a similar file but I need a macro that will allow me to have more fields than the normal Excel form allows. I need a form that will accommodate ~100 fields. I would like the User to be able to click a cell with their name or e-mail address and a form pops up for them to input more information, which would populate on the same row as their name.
This example will construct a UserForm with as many columns as your data has fields. It's basic but I was just experimenting with a dynamic userform