Populating row of data based on Listbox selection!!!

[cory0789]

I am trying to figure out how to get my spreadsheet to populate the other columns of data based on the listbox selections row of data in a master list...
To explain better I have a order sheet that I select the order number on, once selected it allows me to select products that are with that order inside the listbox on the order sheet itself... When I select say Apples, I want everything from the master list to populate in the corresponding columns on the order sheet... price, location, date, so on....


I dont see where the upload button is so I cannot attach my file..

 

[Andrew Poulsom]

Can't you just use AutoFilter?

 

[cory0789]

Can you explain? I am pretty sure I cannot, if possible how can I upload an attachment so it will be easier to see what I am trying to do...

Thanks,

 

[Andrew Poulsom]

Here's a tutorial on AutoFilter:

http://www.contextures.com/xlautofilter01.html

 

[teiente]

I need some suggestions on the best method to pull unique text. Not sure if am explaining this well. But here is how my data is laid out


Del1 Del2 Del3 Del4 Del5

Ras Beo Wen Mas Pas
Pas Wen Cri Cas Ras
Mas Clas Wen
Wen
Cri


I would like to show all the Del that has "Wen". Any suggestions?