Hi, I appreciate the help.
I would like a vba code to populate the list of email addresses in column B and additional fields in columns C - H based on the account that is selected in cell c1 from a drop-down list that are located on the tab called "Survey Data Lookup". The column numbers that i want to pull are listed in Row 5 in the screen shot below. I don't necessarily need a button but it would be nice. Also, every month new accounts are added so the list of accounts changes. If its possible to create a new list of accounts (where there are no duplicates, that would remove a step as well but my main ask is to create this list below.
I wrote a formula but it is very slow and causing the workbook to crash. I am looking for a short code that will quickly populate the data more efficiently.
below is a version of the data file that lays out how I have it set up.
I don't write code, although I'd really like to learn. Thanks again for the help.
I would like a vba code to populate the list of email addresses in column B and additional fields in columns C - H based on the account that is selected in cell c1 from a drop-down list that are located on the tab called "Survey Data Lookup". The column numbers that i want to pull are listed in Row 5 in the screen shot below. I don't necessarily need a button but it would be nice. Also, every month new accounts are added so the list of accounts changes. If its possible to create a new list of accounts (where there are no duplicates, that would remove a step as well but my main ask is to create this list below.
I wrote a formula but it is very slow and causing the workbook to crash. I am looking for a short code that will quickly populate the data more efficiently.
below is a version of the data file that lays out how I have it set up.
I don't write code, although I'd really like to learn. Thanks again for the help.