DrParmeJohnson
New Member
- Joined
- Feb 28, 2019
- Messages
- 44
Hello, I'm quite awful at VBA and am trying to make a macro that does this:
<tbody>
</tbody>
For this format, with the letters on top being default excel columns, I am trying to have the macro go through column E (Item#) and column G (Qty), look for similar Item#'s (i.e 1000) and add up the value in Qty, so for Item# 1000, 3 and output that total in the last cell of the row, in Column H, containing Item# 1000. It would then continue looping through until the end of the Item# column.
I would assume this might be done using like assigned ranges, end of row, and a sum function all bundled into a loop but, I lack the knowledge to do so. So, if someone can assist me in doing this, I would greatly appreciate the assistance.
If there is any need of clarification, as I tend to be bad at explaining things, please do let me know.
Thank you,
DPJ
E | F | G | H | I |
Item# | Item Name | Qty | Total | Tracking |
1000 | xxxx | 2 | xxxx | |
1000 | xxxx | 1 | 3 | xxxx |
2000 | xxxx | 1 | 1 | xxxx |
<tbody>
</tbody>
For this format, with the letters on top being default excel columns, I am trying to have the macro go through column E (Item#) and column G (Qty), look for similar Item#'s (i.e 1000) and add up the value in Qty, so for Item# 1000, 3 and output that total in the last cell of the row, in Column H, containing Item# 1000. It would then continue looping through until the end of the Item# column.
I would assume this might be done using like assigned ranges, end of row, and a sum function all bundled into a loop but, I lack the knowledge to do so. So, if someone can assist me in doing this, I would greatly appreciate the assistance.
If there is any need of clarification, as I tend to be bad at explaining things, please do let me know.
Thank you,
DPJ