Forum Discussion
Dropdown list with multiple selection in cell
Hi NikolinoDE
Thank you so much for your assistance...
I am not conversant with what code is and don't have the understanding ...
I was successful with the testing though when I named sheets did not work...
After inserting rows above to insert picture and freeze panes for "Headings" Sheet 1 is renamed to members ... data entry rows start at G9 and sheet (1) name is Members ....
So in essence Sheet 1 "Members" entry of dropdown would be from G9 to G108
Sheet 2 is renamed to Industry...
Also as multiple entries will be in G9 is there a way to view as a window if possible please
Regards,
@Charlie_The_Connetcor
In order to accomplish this, at least basic knowledge of VBA is required.
Here is another example,
...but in order to get a more precise solution, I recommend that you insert a file (without sensitive data) and explain step by step what exactly you want to do.
In addition, I recommend the Excel version, operating system, storage medium, etc. to inform.
All of this would make things a whole lot easier for everyone.
- NikolinoDE,
Thank you for your assistance and patience ...
I am learning how to do this and coding is way out of my league LOL
Please find example file as requested and what I would like to achieve
https://docs.google.com/spreadsheets/d/1bEu2Hz-Ir4gKE6qzIsIYS1oge0yl9TOU/edit?usp=share_link&ouid=110997921015607293648&rtpof=true&sd=true
I could not figure out how to add .xls file
I am using a Office 2016 ...
Regards,
Charlie_The_Connector- Additionally，I can not download your file from google.com because of network reason.
if you can Open full text editor to upload file here,more people may have chances to get what exact you want。