Forum Discussion
IF formula & Lookup Formula Help to create semi automatic packing slip
Hi I am trying to create a packing slip tab in my excel workbook which when I enter the unique order number will then populate the packing slip lines. I have managed to so this for the customer ...
Hi Gemma Telfer
I would propose a Power Query solution, it's easy to implement, very straight forward and should work with all Excel versions from 2016 on.
Attached please find my solution. All you need to do is to trigger a refresh once you have changed the order reference number in your packing slip:
(the first time, you would also need to click on the "enable content" button)
To implement this solution, the list of orders and the products list have been converted into formatted tables (menu "Home | Format as table".
And for the cell with the order reference number, I have defined a name:
This way, everything can be loaded and combined in Power Query, the result is loaded directly in the packing slip sheet.
Hope this helps.
Kind regards,
Martin
Martin_Weiss thankyou that works perfectly and is so simple to use. This will make my life so much easier.
