I have a worksheet that contains a repeat listing of 15 products with case quantities, weight, delivery address, etc. for a set number of delivery locations. I would like to develop a macro that when activated would populate the bill of lading (based on the information associated with the worksheet) and print it. How would i go about doing this?