I'm new at my job, and I'm working on a "project"
consisting of 12,665 lines in a spreadsheet. I want to
try to consolidate because this needs to be printed,
On the worksheet, column G is "sales acct #s", and column
H are "quantities". Some sales accounts have multiple
locations which are listed on individual rows, but I only
need the total qty per acct #. Is there a way I can
instert column I and have excel sort through column G and
subtotal qty (col h) according to the acct #? I hope that
was clear enough. I've been going through and doing it
manually, but this will take a week. I don't know enough
about macros or formulas to set it up myself.
Thank you in advance for your help - it is most
appreciated!!!