Hello,
I am looking to generate a Packing list (similar to what is in the Packing_List_Template tab in the file attached) based on what checkboxes are ticked in the "Form" Tab. Data is stored in the "Data_PckList" Tab
So, the user will select all puppets needed and click on "Packing List" Button, which will generate a PDF with the Packing list.
In the Packing lits we would need each Puppet separated (their names automatically populated with the names clicked in the Form) and showing their "Main components", "Tech" and "Other" components and then all tools combined from all puppets at the bottom.
Ideally the List would auto-design, depending on how many puppets are selected.
For example, if just one puppet selected, it would show the Puppet name, component list and tool list. If two, would look like as the example in Packing_List tab and if more, it would just add another 2 puppets per page and then the Tools at the bottom.
I use Excel for Mac version 16.40
Any help is welcomed
Thank you
Bookmarks