Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Input
I have a spreadsheet that contains shipment info. For each shipment there is
a route origin. Right now there a possiblity of 4 route origins and any number of shipments. I have written code to group the shipments by Route Origin, capture the route origin, insert two new lines, and place the route origin below the grouped shipments. Example below. A B C D 1| Shipment | Route Origin | Weight | Pieces | 2| 12 | EWR | 5000 | 20 | 3| 45 | EWR | 6000 | 40 | 4| Route Origin | EWR | | | 5| | | | | 6| 16 | ORD | 7000 | 30 | 7| 18 | ORD | 8000 | 40 | 8| 20 | ORD | 500 | 5 | 9| Route Origin | ORD | | | 10| | | | | Again above is what I already have code to do. For some reason I am strugling with the silly part of summarizing the pieces and weight for each Route Origin. So in addtion to what you see above I would like for cell C4 to show 11000 (5000+6000), D4 to show 60 (20+40), C9 to show 15500 and D9 to show 75. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |