Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidating Data from Multiple lines
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating data from multiple spreadsheets... | Excel Discussion (Misc queries) | |||
Merging or Consolidating Data from Multiple Workbooks | Excel Discussion (Misc queries) | |||
Consolidating data from multiple sheets. | Excel Discussion (Misc queries) | |||
need help in consolidating multiple data | Excel Discussion (Misc queries) | |||
Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming |