G
Guest
I have a rather large spreadsheet (~12000 entries) which contains inventory
data. I have many parts which are in multiple location, but I just want a
subtotal by part number of the quantities in all locations.
I tried subtotal, and the sheet shows the subtotals, but it opens up an
outline view or something to that effect, and I want just the summary
information on that sheet or be able to copy to another worksheet. But no
matter what I do, I either get a grand total entry or all entries, including
each location. How do I obtain just the subtotal data where I can perform
further functions like VLOOKUP (for another sheet).
I tried Pivot Table but it comes back and says something like too many items.
I'll readily admit I'm an amateur at subtotals. Can anyone help?
Thanks in advance,
Dave
data. I have many parts which are in multiple location, but I just want a
subtotal by part number of the quantities in all locations.
I tried subtotal, and the sheet shows the subtotals, but it opens up an
outline view or something to that effect, and I want just the summary
information on that sheet or be able to copy to another worksheet. But no
matter what I do, I either get a grand total entry or all entries, including
each location. How do I obtain just the subtotal data where I can perform
further functions like VLOOKUP (for another sheet).
I tried Pivot Table but it comes back and says something like too many items.
I'll readily admit I'm an amateur at subtotals. Can anyone help?
Thanks in advance,
Dave