Spreadsheet 1 is the list of names, dates, meter readings I have started with and I need to split the names on to new worksheets as per spreadsheet 2
Spreadsheet 1 (master worksheet)
<colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 8587;">
<col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2676;">
<col width="181" style="width: 136pt; mso-width-source: userset; mso-width-alt: 6330;">
<col width="163" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5678;">
<tbody>
</tbody>
Spreadsheet 2 (SMITH Worksheet)
<colgroup><col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4375;">
<col width="91" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3188;">
<col width="135" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4701;">
<col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 4887;">
<tbody>
</tbody>
Regards
Richard
Spreadsheet 1 (master worksheet)
Name | Date | Meter Reading | |
Start | End | ||
SMITH | 12/03/2019 | 796908.30 | 796943.30 |
OUTRAM | 13/03/2018 | 796943.30 | 796982.10 |
WILSON | 14/03/2018 | 796982.10 | 797120.00 |
DUCKER | 15/03/2018 | 797120.00 | 797140.00 |
FRYATT | 16/03/2018 | 797140.00 | 797155.00 |
IBBOTSON | 17/03/2018 | 797155.00 | 797222.00 |
KIRBY | 18/03/2018 | 797222.00 | 797289.00 |
SMITH | 19/03/2018 | 797289.00 | 797389.00 |
WILSON | 20/03/2018 | 797389.00 | 797489.00 |
WOODCOCK | 21/03/2018 | 797489.00 | 797589.00 |
SMITH | 22/03/2018 | 797589.00 | 797689.00 |
WITHERS C | 23/03/2018 | 797689.00 | 797789.00 |
WILLIAMS | 24/03/2018 | 797789.00 |
Spreadsheet 2 (SMITH Worksheet)
Name | Date | Meter Reading | |
Start | End | ||
SMITH | 19/03/2018 | 797289.00 | 797389.00 |
SMITH | 19/03/2018 | 797289.00 | 797389.00 |
SMITH | 19/03/2018 | 797289.00 | 797389.00 |
Regards
Richard