Hello, been musing around the forums a little asking questions and giving advice - now I have a new query which I've been stuck on this afternoon.
I have 10 cells in a row going down, each one of those 10 cells have the same data validation in - a drop-down list with values in. Below those drop down boxes is a blank table with three columns (item code, item description and quantity). On a separate sheet, I have each of the options in the drop-down boxes as a separate table - each showing the different item, description and quantity.
Essentially, I need a macro that will take the value from one, a few or all of the drop-down boxes and return the relevant data for the chosen option in the blank table at the bottom.
Is this something which is possible? I nearly make break-through ideas with it, but then something lets it down last minute.
Callum
Bookmarks