mwstorms21
New Member
- Joined
- Sep 13, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hello,
I am new to this forum, but ran across MickG's code for using VBA to merge duplicate rows and sum values in certain column. I was hoping someone might be able to help me edit this code to suit my needs.
The original thread is here: VBA to merge duplicate rows and sum values in certain column
The following data (headers titles) starts on row 12 of my spreadsheet. (row 13 is the first row that I want to process)
I would like to identify unique values in column 5 ("Description"), delete duplicate rows, and sum column 6 ("Quantity") while leaving the other columns (1,2,3,4,7,8,9,10) unchanged.
Thank you so much for your help and please let me know if there is any other information I need to provide.
I am new to this forum, but ran across MickG's code for using VBA to merge duplicate rows and sum values in certain column. I was hoping someone might be able to help me edit this code to suit my needs.
The original thread is here: VBA to merge duplicate rows and sum values in certain column
The following data (headers titles) starts on row 12 of my spreadsheet. (row 13 is the first row that I want to process)
I would like to identify unique values in column 5 ("Description"), delete duplicate rows, and sum column 6 ("Quantity") while leaving the other columns (1,2,3,4,7,8,9,10) unchanged.
Thank you so much for your help and please let me know if there is any other information I need to provide.
Line | Price List | Part Number | Manufacturer | Description | Quantity | Pro-Rated Price | Extended Price | Start Date | End Date |
1 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 365 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 400.00 | $ 400.00 | 9/11/2020 | 9/11/2021 |
2 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 365 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 400.00 | $ 400.00 | 9/12/2020 | 9/11/2021 |
3 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 365 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 400.00 | $ 400.00 | 9/12/2020 | 9/11/2021 |
4 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 283 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 300.00 | $ 300.00 | 12/3/2020 | 9/11/2021 |
5 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 283 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 300.00 | $ 300.00 | 12/3/2020 | 9/11/2021 |
6 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 283 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 300.00 | $ 300.00 | 12/3/2020 | 9/11/2021 |
7 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 283 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 300.00 | $ 300.00 | 12/3/2020 | 9/11/2021 |
8 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 162 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 200.00 | $ 200.00 | 4/3/2021 | 9/11/2021 |
9 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 162 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 200.00 | $ 200.00 | 4/3/2021 | 9/11/2021 |
10 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 162 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 200.00 | $ 200.00 | 4/3/2021 | 9/11/2021 |
11 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 155 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 150.00 | $ 200.00 | 4/10/2021 | 9/11/2021 |
12 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 137 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 100.00 | $ 100.00 | 4/28/2021 | 9/11/2021 |
13 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 137 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 100.00 | $ 100.00 | 4/28/2021 | 9/11/2021 |
14 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 137 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 100.00 | $ 100.00 | 4/28/2021 | 9/11/2021 |
15 | PRICE LIST 123 | PART1 | ManufacturerA | Annual Maintenance for Apple iPad including: 137 days unlimited Verizon data plan (DTL at 15GB) | 1 | $ 100.00 | $ 100.00 | 4/28/2021 | 9/11/2021 |