Home

Looking for Help to Design a Freight Loading Sheet

ustray
Occasional Visitor

I have come up with with a spreadsheet that shows an empty freight trailer.  Due to our palletized product being infinite amount of available sizes for product, I want to make a macro that would be able to draw an pallet with the dimensions I put in each time.  Right now I have it done with 2 macros that draw a predetermined pallet size.  Since our products vary in size each pallet going out will be different sizes and we are manually drawing on a sheet of paper how to best load the trailer.  

 

I have included the spreadsheet I have so far.  I would need to be able to put in any combination of dimensions for the pallet and press the button and it would produce the shape based on the scaling I have for the spreadsheet.  I would then be able to drag the shape and place it in the square (trailer bed) picture and move all these different shaped items around to I get the most efficient way to load each trailer leaving here.

 

Maybe macros aren't the best way to do this.  I am using Excel 2016.  I am open to any suggestions.  

Any help on this is appreciated.  

 

Thanks!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies