I have a dropdown box with order numbers in a cell, well cells as i have multiple customers each with orders in their own drop down box. On another sheet i have a table with the orders for every customer with the order number and the details about that order (say item, quantity etc)

What i would like is that when i choose one of the numbers in the drop down box it autofills the columns to the right with the data. So i'm guessing this would be some kind of lookup in a macro that activates when whats in the cell changes, but i dont know what the code would be. Can anyone help?

Also for the main page where the drop downs are, in the columns for the details are more drop downs where if the order is not existing the details can be put in manually. Would having a macro for this purpose affect having those drop downs?

Any help will be appreciated. If my explanations are off then i can provide more info and i can attach a cutdown version of the spreadsheet if that helps.