Forum Discussion

Copper Contributor

Apr 26, 2023

Dropdown list with multiple selection in cell

I have a item list in sheet 1 of work book, A2 to A47 I would be adding more items to this list. On sheet 2 I have 7 columns A to G which I will have A (name), B (surname), C (mobile), D (email), E (...

Macros and VBA

mm_anc

Copper Contributor

Mar 28, 2024

Hello, Is there a way to do this in a table? In the example above, the target address is a single cell. Can this be applied to a column in a table?
Thanks!

peiyezhu

Bronze Contributor

Mar 28, 2024

Have you tried the file I have uploaded ?
I guess it do apply to a column.