Combine 2 drop-down lists into one another

[ulothar]

Hello guys, can someone please help me do what the screenshot explains ? (since it's hard to explain just in words :/)

Thank you in advance!

test1.jpg

[sandy666]

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ulothar]

Thanks a lot Sandy 666 , I will upload it now hope it will help.

So basically what I need is to C17 and C18 cells a drop-down lists (as they already are) but to include both values (attributes) from the selected Aspects in the cells C15 and C16. So if in C15 there is selected "Strong and Resolute" and in C16 is selected "Acurate and Aware" , then C17 and C18 should have the values of "Brawn","Willpower","Awareness","Intelligence". If the user selects other Aspects in C15 and C16 , then C17 and C18 should have the corresponding values of Attributes.

Hope it helps, this is the excel file below :

http://www.filedropper.com/test_233

[ulothar]

Sorry double post.

[sandy666]

Did you read post #2 ?
I think read it again.

[ulothar]

Yes I did read it. I guess you are talking about the BEFORE and AFTER you mentioned. I don't know exactly what you mean by that. I cannot make the "after" part. If what I did wrong was to use another site to upload the file I will try it again.

Please let me know if it's ok now

[sandy666]

BEFORE and AFTER = what you have and what you want to achieve
Yes, now file is correct

[ulothar]

Yes I uploaded the before and I explain what I need for the after hehe sorry my english isn't that good . If you see the file at the cells C17 and C18 the drop-down list includes only the value of one "Aspect", I just need to make these cells have the combined values of attributes from both options

Edit: And if possible to make this without using VBA since I am not familiar with it :/ if there is no other way but to use VBA then ok

[sandy666]

OK, I think here will be good example how to do it : Create Dependent Drop Down Lists

Λυπάμαι, η δήλωση αυτή δεν είναι στην ελληνική γλώσσα (My greek is very poor )

[ulothar]

Yeah it works pretty well thank you for your time and sorry for the inconvenience with the sample file (your Greek seems good to me hehe)

[sandy666]

Glad to help
If problem is resolved Add Reputation star to person(s) who helped you and mark thread as Solved. Thanks