Drop down based on another cell

[madamson86]

Hello

I hope someone can help me. On the worksheet "To be Paid" In colum C I enter an account number, then in column F I need a drop down box that shows all the addresses that relate to that account number.

The account details are located within "AC details" sheet with the account number in column A and the address are in column C there is one line for each account and the address is seperated by a comma.

There is already validation setup to ensure the account number exsists when the user enters this onto the "To be Paid" sheet.

Best Regards
Mike

 

[texasalynn]

have a look here
http://www.contextures.com/xlDataVal02.html and here
http://contextures.com/xlDataVal13.html

 

[madamson86]

Spot on, thanks for pointing me in right direction.

Cheers

 

[texasalynn]

Glad it was helpful. Thanks for the feedback