la90292
07-11-2010, 11:33 AM
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.
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.