B
Bob
What I would like to do is take the follwoing data:
INPUT TABLE
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:
OUTPUT TABLE
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.
One suggestion was to use an advanced filter to get the unique
Item/Locations and the do a sumif to get the numbers put together. I have not
been able to get a sum if to do this. How do I do it? In order to get the
unique Item/Location combinations, I had to comebine them into a string. I
presume I would continue using this string for the SUMIF.
Thanks
Bob
INPUT TABLE
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:
OUTPUT TABLE
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.
One suggestion was to use an advanced filter to get the unique
Item/Locations and the do a sumif to get the numbers put together. I have not
been able to get a sum if to do this. How do I do it? In order to get the
unique Item/Location combinations, I had to comebine them into a string. I
presume I would continue using this string for the SUMIF.
Thanks
Bob