Yes I am trying to do this n excel. I am creating a template that will allow users to click on a cell and to be presented with a drop down list. This part I am fine with. However, the user will often need to click on several options in the drop down list and for all options selected to be presented in one cell separated by commas
The file ID is 596230.
It is columns z to AM that I need to add the drop down lists to. sheet 2 shows data that should appear in the drop down list with the relevant headings.
Excellent, thanks Richard
Will the drop down list still be available in each column in the row? If so then that is fine.
This overwrites the selection when i click on the selection. I already know how to do this. What I wanted is to be able to select multiple options from the drop down list and for the cell to record each selection separated with a comma and no spaces. e.g. In column AI additional resources, a user might want to select 2PC's and 1FSE, so if they select both options from the drop down the cell would be populated with 2pc,1FSE
That is what I am doing but it is only saving one selection. E.g In Column AI, I am selecting 1PC, 2FSE then click process but it is only saving 2FSE. I have tried selecting 1PC, then process, then 2FSE then process but again this only displays 2FSE. It is not saving the multiple choices that I am selecting
Got it. however, I need each row to be able to populate the same way as the top row does.
This template will be populated with 1000,s of tasks. For each task the user needs to be able to state what is needed for each task. Therefore, every row will be a different task and I need to be able to see if for each task for example how many FSE's, PC's and PO's are needed to complete the task.
I have seen on a lot of websites it can be done, I am just rubbish with VBA so I have had no luck.
I just need it to show like this:
Row1 = 1pc,2fse,1po
Row2 = 2pc,1fse
Row3 = 3PC,1PO etc etc. Then to be able to do this for each column
So are you saying then that what I want can not be done, or is their an alternative option?
Oh man, so I have just spent £70 to be told that what I want can not be done?
Do you know of any other techniques that can be used to select multiple options?
The process that is currently being used to fill in these task sheets is to manually enter the inputs for each cell. However, the exact same spelling, spaces etc need to be used as the file is being uloaded to a new system which will not recognise the entry if it is not exactly as specified. Which is why i am trying to use pre defines lists to choose from to minimise the error.
Any suggestions on making this better would be most welcome
I misunderstood what you were asking.
This is frustrating as the top row does exactly what I want it to do. Is there any work around you can think of that will give me this for each cell. Can what you have done for the top cell just not replicated for each cell?How easy would it be to do this in access? I could then just export it from access to excel
So is that it then? There is nothing at all that can be done to give me what I want?