Based on the Location & Quantity, Locations to be grouped & corresponding sum

[vasu2007]

Hello Friends,


I need to summarize data based on the locations & Quantity.
Truck will go to different locations & loads the Quantity.
Requirement will better understood by looking at the picture.


Sorry guys, I have searched lot of forums but unable find the solution.
As I am a beginner in vba, I know, I cant do this. Seeking your help.

[SamT]

What picture. I don't see it.
Create a book with a sheet of example Listing with about 12 items for at least two locations and a sheet with how you want them sorted.

Also, there should be a "Load order" so the trucks can be loaded in a FILO, (First In Last Out,) method.

At the bottom of the "Go Advanced" page here, you will find a "Manage Attachments" button to upload the example book.