Hello,
I recorded a Macro using the Consolidation tool however when I run the Macro, it does not complete the task.
Here is what it looks like:
Sub Consolidate()
'
' Consolidate Macro
'
'
Sheets("Inventory Value Report").Select
Range("D1").Select
Selection.Consolidate Sources:=Array( _
"'C:\Users\ddep9969\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\U7MD7TOU\[Inventory Value Report 06062019 (002).xls]Inventory Value Report'!R1C1:R914C2" _
, _
"'C:\Users\ddep9969\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\U7MD7TOU\[Inventory Value Report 06062019 (002).xls]Inventory Value Report'!R1C1:R1200C2" _
), Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False
End Sub
Can someone help me with creating a Module that locates the duplicates in column A and sums the values in column B:
<colgroup><col span="2"></colgroup><tbody>
</tbody>
This list will vary in size so I would like for it to look for the last row with data and complete the task within that range.
Any help would greatly be appreciated!!
I recorded a Macro using the Consolidation tool however when I run the Macro, it does not complete the task.
Here is what it looks like:
Sub Consolidate()
'
' Consolidate Macro
'
'
Sheets("Inventory Value Report").Select
Range("D1").Select
Selection.Consolidate Sources:=Array( _
"'C:\Users\ddep9969\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\U7MD7TOU\[Inventory Value Report 06062019 (002).xls]Inventory Value Report'!R1C1:R914C2" _
, _
"'C:\Users\ddep9969\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\U7MD7TOU\[Inventory Value Report 06062019 (002).xls]Inventory Value Report'!R1C1:R1200C2" _
), Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False
End Sub
Can someone help me with creating a Module that locates the duplicates in column A and sums the values in column B:
Item Number | Quantity on Hand |
3029891 | 1 |
5101078 | 1.08 |
7002294 | 0.5 |
7002294 | 3 |
0671677 | 0.75 |
5469259 | 1.5 |
2404135 | 1 |
2404135 | 0 |
1283456 | 4 |
7544737 | 1 |
1829748 | 0 |
2822383 | 0 |
2822383 | 1.25 |
8953028 | 0 |
6259477 | 1.58 |
4507214 | 2 |
2006559 | 1.35 |
4507234 | 0.5 |
4507263 | 1 |
5518529 | 0.83 |
4069870 | 0 |
1142381 | 0.67 |
4838704 | 0 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
This list will vary in size so I would like for it to look for the last row with data and complete the task within that range.
Any help would greatly be appreciated!!