Sunday, April 10, 2016

Creating an Order Acknowledgment, Packing List & Bill of Lading in Excel 2016

In this video, I show you how to create an order acknowledgement, packing list and bill of lading in Microsoft Excel 2016. This allows the user to enter the information in one location and have it transfer to the appropriate places on the other forms. This was by special request from viewer Mike K and I hope this helps many people accomplish this task. Formulas used were vlookup and iferror; also used was data validation to create drop-down lists, set print area, insert page breaks, hide zero values, hide NA error messages, insert worksheet, and much more. Access my Excel workbook from this video here: http://bit.ly/1XplPoG Don't forget to subscribe to my channel for more tutorials! Check out my website at http://bit.ly/1TKzTtT Video recorded using Screencast-O-Matic (http://bit.ly/1XplPoI) Thanks for tuning in!
Creating an Order Acknowledgment, Packing List & Bill of Lading in Excel 2016