Hi,

Been working away at this for a few days now and starting to get quite complicated. Not a pro when it comes to VBA but i can read it and write it a bit.

So heres what I need. Currently Im creating a database at work which will save time and effort once its complete. On my first sheet I have listed all the parts (Devided into sections) that we stock into tables. I then give each section a name (example table 1 to table 12). On my second sheet I have used the data validation tool and defined each list as their section name.

Therefore on the second sheet I have drop down lists of the tables I created on sheet 1. What I want to do is, from each drop down list I would like to be able to pick multiple Items and for these Items to go onto a third sheet which will be used as an order sheet. I dont mind if I have to use a button to forward these items to the third sheet but I can not work it out at all. Just a little bit of code to get me started and that should be great.. Thanks very much!!