
Originally Posted by
Harribone
So let's say a user enters the values A B C and D for each of these - (Dimensions);(Material);(Color);(Classification). You want another cell to output A;B;C;D ?
If so then its just a case of typing =B1&";"&B2&";"&B3&";"&B4 which will join the values together.
As for a drop down selection you can create a list in excel with each option you want to be able to choose. Then select the cell which will have the drop down list and click on Data Validation. Choose limit to list and set it to the range which contains your values (=A1:A10 for example). You can check 'limit to list' so that the user can only choose/type values contained within that range if so required.
Does that help with your needs?
Bookmarks