Searching a list of names, with corsponding data across to another worksheet

[Butch-196]

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)

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

<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)

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

<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

 

[Butch-196]

All sorted thanks for your help.

Regards
Richard

 

[Fluff]

You're welcome & thanks for the feedback