LucyJeanie
New Member
- Joined
- Feb 14, 2019
- Messages
- 1
Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this:
<colgroup><col width="170" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6217;">
<col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;">
<col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;">
<col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;">
<col width="165" style="width: 124pt; mso-width-source: userset; mso-width-alt: 6034;">
<col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="159" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5814;">
<col width="173" style="width: 130pt; mso-width-source: userset; mso-width-alt: 6326;">
<tbody>
</tbody>
and I need it to look like this:
<colgroup><col width="170" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6217;">
<col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;">
<col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;">
<col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;">
<col width="165" style="width: 124pt; mso-width-source: userset; mso-width-alt: 6034;">
<col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="159" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5814;">
<col width="173" style="width: 130pt; mso-width-source: userset; mso-width-alt: 6326;">
<tbody>
</tbody>
I need Period Count, RDF and WMT to be a total sum.
I've tried few variations on a code I have but it's not working properly.
PLEASE HELP!
Financial Year & Period | Incident Start Date | Incident Number | Period Count | Incident Description | Category | WMT | RDF |
2018/19_P03 | 20/05/2018 10:30 | 20705 | 1 | A87 | ABC | 15 | 12 |
2018/19_P04 | 20/05/2018 10:30 | 20705 | 1 | A87 | ABC | 46 | 52 |
and I need it to look like this:
Financial Year & Period | Incident Start Date | Incident Number | Period Count | Incident Description | Category | WMT | RDF |
2018/19_P03 | 20/05/2018 10:30 | 20705 | 2 | A87 | ABC | 61 | 64 |
I need Period Count, RDF and WMT to be a total sum.
I've tried few variations on a code I have but it's not working properly.
PLEASE HELP!