I would like something like a drop down box with a list above a certain column.
when an item on that list is selected, i would like a column from a different sheet to be inserted into the column below the drop down box.
Is this achievable ?
look forward to your reply
thank you