Automate shipment routine

[mdshotgun]

Hello all,

Hope you can help.

In the attached i am hoping to create a procedure or function that when i select a company name then their
address will automatically appear in next cell from that the person will be asked to select a courier from dropdown.

Thanks for any help.

[Kyle123]

Have a look at the VLookup() function and validation lists