Have been trying to solve this for some time with no success. Nothing found via Google, so thought I would try here.
I have a table that lists requirements for software design. For each requirement there is one or several associated SW products.
I have a column for the associated SW products and can use data validation and a list to allow the user to pick one product.
What I want to achieve is the ability to select say "Product1" from the validation list, and then add another product, say "Product2" - so the relevant cell would contain Product1 Product2.
I have tried using an array to concatenate the content of the current cell with the list to produce a new list, but get an error.
Any ideas anyone?
I have a table that lists requirements for software design. For each requirement there is one or several associated SW products.
I have a column for the associated SW products and can use data validation and a list to allow the user to pick one product.
What I want to achieve is the ability to select say "Product1" from the validation list, and then add another product, say "Product2" - so the relevant cell would contain Product1 Product2.
I have tried using an array to concatenate the content of the current cell with the list to produce a new list, but get an error.
Any ideas anyone?