I have a work sheet that has the inventory for our shoe store, Columns A to X and is sub totaled by each vendor.

I want to be able to sort Columns H & J which contains the style # and sizing respectfully for each vendor.The problem is each vendor will have x amount of rows to sort depending on how many items they have, and since the subtotals are by vendor, I must do each vendor down the list to keep the sections in tact.

Please help me with a formula. Thanks.