Hi, and thanks in advance for any help.
I need a code that will look an ID in columb A then add all the same ID's assosated values in columb C, it must then transfere this data to a second sheet and lookup the assosiated date and ID a past into the correct cell. "sounds easy"
Sheet1
<colgroup><col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;">
<col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;">
<col width="64" style="width: 48pt;">
<col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;">
<col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;">
<tbody>
</tbody>
Sheet 2
<colgroup><col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;">
<col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;">
<col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" span="3">
<tbody>
</tbody>
IE it will take ID (1154664 ) in sheet 1 Add the "Trans Qty" together for that ID only, the take that value and past it under Mondays 03/12/2018 (Must use the assosiated date to chos the columb) columb in sheet 2 in the row marked (1154664).
Is this possible? I tried but nt evenknow where to start on this one?
Thanks again .
I need a code that will look an ID in columb A then add all the same ID's assosated values in columb C, it must then transfere this data to a second sheet and lookup the assosiated date and ID a past into the correct cell. "sounds easy"
Sheet1
Document Number | 2nd Item Number | Trans QTY | Order Date | Plan Fmly |
1154663 | 01/6029H | 300 | 03/12/2018 | 248 |
1154664 | 01/6059H | 40 | 03/12/2018 | 248 |
1154664 | 01/6059H | 100 | 03/12/2018 | 248 |
1154664 | 01/6059H | 100 | 03/12/2018 | 248 |
1150219 | 01/6224H | 64 | 03/12/2018 | 248 |
1150219 | 01/6224H | 64 | 03/12/2018 | 248 |
1150219 | 01/6224H | 64 | 03/12/2018 | 248 |
1150219 | 01/6224H | 64 | 03/12/2018 | 248 |
Sheet 2
Works order | Component Number | Monday | Tuesday | Wednesday |
03/12/2018 | 04/12/2018 | 05/12/2018 | ||
PDN | PDN | PDN | ||
1165904 | 174/600 | 0 | 0 | 0 |
1155200 | 13/5292 | 0 | 0 | 0 |
1155135 | 13/5057 | 0 | 0 | 0 |
1156552 | 13/7113 | 0 | 0 | 0 |
1155205 | 13/5319 | 0 | 0 | 0 |
IE it will take ID (1154664 ) in sheet 1 Add the "Trans Qty" together for that ID only, the take that value and past it under Mondays 03/12/2018 (Must use the assosiated date to chos the columb) columb in sheet 2 in the row marked (1154664).
Is this possible? I tried but nt evenknow where to start on this one?
Thanks again .
Last edited: