Hi folks,
I need your help.
I have the following situation.
In a sheet2, I need to create drop-boxes (based on another Sheet1), one listing names of retailers, one some criteria (called "A"), one criteria "B", one "C", one "D".
One is supposed to select one OR MORE names from each list (each list is "independent" from the others).
Then I am supposed to create a button to generate a Sheet3, displaying what has been selected in the drop-boxes (list of retailers and criteria) and the corresponding text (all included in Sheet1).
My first question is "how to create drop-boxes with a multiple selection"? I use Data->Data Validation to create them, but I can select only one each time.
The second problem is how to create a macro (or VBA code) to display the results.
I am really under pressure for this work, so any help or suggestion is really appreciated.
Thanks
I need your help.
I have the following situation.
In a sheet2, I need to create drop-boxes (based on another Sheet1), one listing names of retailers, one some criteria (called "A"), one criteria "B", one "C", one "D".
One is supposed to select one OR MORE names from each list (each list is "independent" from the others).
Then I am supposed to create a button to generate a Sheet3, displaying what has been selected in the drop-boxes (list of retailers and criteria) and the corresponding text (all included in Sheet1).
My first question is "how to create drop-boxes with a multiple selection"? I use Data->Data Validation to create them, but I can select only one each time.
The second problem is how to create a macro (or VBA code) to display the results.
I am really under pressure for this work, so any help or suggestion is really appreciated.
Thanks