Thread
:
Consolidating Data from Multiple lines
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Consolidating Data from Multiple lines
Have a look in the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Bob" wrote in message
...
What I would like to do is take the follwoing data:
Inventory Tag Item Location Qty
22 H00016 770 20
100 H00016 770 10
76 H00016 ATO01 5
99 H00047 770 50
300 H00101 BOH01 22
and end up with with the following in a new worksheet:
Thanks,
Bob
Item Location Qty
H00016 770 30
H00016 ATO01 5
H00047 770 50
H00101 BOH01 22
Basically I now have one line per location with the quantities summed up
into a new worksheet or workbook. Now I can upload the data to the
inventory
system.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett