davidmyers
Board Regular
- Joined
- Jan 29, 2017
- Messages
- 88
- Office Version
- 2016
- Platform
- Windows
Hi,
I have an Excel form for people to fill, in one of the columns I need people to select several items from a list.
I would like this list to be visible on the sheet (for reference only) so people could copy/paste from it. The problem is if I include this list of items in a column and a row was added or deleted then the list would be corrupted. Is it possible to have an excel sheet and a list that appears separately that is not part of the sheet - but from which I could copy from.
I would like to keep this a simple xlsx sheet and not have to add code for a multiselect dropdown list.
Thanks for any help
David
I have an Excel form for people to fill, in one of the columns I need people to select several items from a list.
I would like this list to be visible on the sheet (for reference only) so people could copy/paste from it. The problem is if I include this list of items in a column and a row was added or deleted then the list would be corrupted. Is it possible to have an excel sheet and a list that appears separately that is not part of the sheet - but from which I could copy from.
I would like to keep this a simple xlsx sheet and not have to add code for a multiselect dropdown list.
Thanks for any help
David