I need to generate shipping instructions automatically from 2 excel databases in one workbook. In the first one you have all the information regarding the shipment and in the second one the freights. For each contract a shipping instruction has to be generated. The products are 2 files: one pdf and one word, for each and all the contracts on the list, and are to be saved in a folder . In case I want to generate one shipping instruction manually I should be able to visualice the preview in excel. Most of the information can be pulled with a lookup depending on the ID, which is the contract; but for the freights a multi-criteria search and pick depending on the ports of loading and delivery should be used. since there are diferent offers for the freights, the cheapest one should be picked first. There is a minimum of 2 freight options that should appear on the shippin instructions if generated automatically. In case there are less, the rows should be blank. If I want to create a shipping instruction manually, I should be able to add more rows from the form and choose the best freight from a filtered dropdown menu.
31 freelancers are bidding on average $132 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Willing to take up your project. Thank you, Regards.