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)

[TABLE="width: 501"]
<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>[TR]
[TD="width: 246, bgcolor: transparent"]Name [/TD]
[TD="width: 77, bgcolor: transparent"]Date[/TD]
[TD="width: 344, bgcolor: transparent, colspan: 2"]Meter Reading[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Start [/TD]
[TD="bgcolor: transparent"]End [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]12/03/2019[/TD]
[TD="bgcolor: transparent"]796908.30[/TD]
[TD="bgcolor: transparent"]796943.30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]OUTRAM[/TD]
[TD="bgcolor: transparent"]13/03/2018[/TD]
[TD="bgcolor: transparent"]796943.30[/TD]
[TD="bgcolor: transparent"]796982.10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILSON[/TD]
[TD="bgcolor: transparent"]14/03/2018[/TD]
[TD="bgcolor: transparent"]796982.10[/TD]
[TD="bgcolor: transparent"]797120.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DUCKER[/TD]
[TD="bgcolor: transparent"]15/03/2018[/TD]
[TD="bgcolor: transparent"]797120.00[/TD]
[TD="bgcolor: transparent"]797140.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]FRYATT[/TD]
[TD="bgcolor: transparent"]16/03/2018[/TD]
[TD="bgcolor: transparent"]797140.00[/TD]
[TD="bgcolor: transparent"]797155.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]IBBOTSON[/TD]
[TD="bgcolor: transparent"]17/03/2018[/TD]
[TD="bgcolor: transparent"]797155.00[/TD]
[TD="bgcolor: transparent"]797222.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]KIRBY[/TD]
[TD="bgcolor: transparent"]18/03/2018[/TD]
[TD="bgcolor: transparent"]797222.00[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]19/03/2018[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILSON[/TD]
[TD="bgcolor: transparent"]20/03/2018[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[TD="bgcolor: transparent"]797489.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WOODCOCK[/TD]
[TD="bgcolor: transparent"]21/03/2018[/TD]
[TD="bgcolor: transparent"]797489.00[/TD]
[TD="bgcolor: transparent"]797589.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]22/03/2018[/TD]
[TD="bgcolor: transparent"]797589.00[/TD]
[TD="bgcolor: transparent"]797689.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WITHERS C[/TD]
[TD="bgcolor: transparent"]23/03/2018[/TD]
[TD="bgcolor: transparent"]797689.00[/TD]
[TD="bgcolor: transparent"]797789.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILLIAMS
[/TD]
[TD="bgcolor: transparent"]24/03/2018[/TD]
[TD="bgcolor: transparent"]797789.00
[/TD]
[TD="bgcolor: transparent"]

[/TD]
[/TR]
</tbody>[/TABLE]

Spreadsheet 2 (SMITH Worksheet)

[TABLE="width: 369"]
<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>[TR]
[TD="width: 125, bgcolor: transparent"]Name [/TD]
[TD="width: 91, bgcolor: transparent"]Date[/TD]
[TD="width: 275, bgcolor: transparent, colspan: 2"]Meter Reading[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Start [/TD]
[TD="bgcolor: transparent"]End [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]19/03/2018[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]19/03/2018[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]19/03/2018[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[TD="bgcolor: transparent"]797389.00

[/TD]
[/TR]
</tbody>[/TABLE]

Regards
Richard

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Name	Date	Meter Reading
2	Start	End
3	SMITH	12/03/2019	796908.30	796943.30
4		19/03/2018	797289.00	797389.00
5		22/03/2018	797589.00	797689.00
Smith

Cell Formulas
Range	Formula
B3	{=IFERROR(INDEX(sheet1!B$3:B$15,SMALL(IF(sheet1!$A$3:$A$15=$A$3,ROW(sheet1!$A$3:$A$15)-ROW(sheet1!$A$3)+1),ROWS($1:1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Formula copied down & across

 

[Butch-196]

Hi thanks for the help, i am struggling to get the meter readings to work with this formula,
regrds
rihard

 

[Fluff]

In what way?

 

[Butch-196]

when i copy across it just brings the date across

 

[Fluff]

Simply format the Meter reading columns to "General"

 

[Butch-196]

Hi could you please give me the formula for the meter reading cells.
regards
rchard

 

[Fluff]

If your meter readings are in cols C:D then just copy the formula across & format the cells

 

[Butch-196]

=IFERROR(INDEX('Master Sheet'!C$6:C$18,SMALL(IF('Master Sheet'!$A$6:$A$18='Smith 01'!$A$10,ROW('Master Sheet'!$A$6:$A$18)-ROW('Master Sheet'!$A$6)+1),ROWS($1:1))),"")

[TABLE="width: 369"]
<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>[TR]
[TD="width: 125, bgcolor: transparent"]Name [/TD]
[TD="width: 91, bgcolor: transparent"]Date[/TD]
[TD="width: 275, bgcolor: transparent, colspan: 2"]Meter Reading[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Start [/TD]
[TD="bgcolor: transparent"]End [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]12/03/2019[/TD]
[TD="bgcolor: transparent, align: right"]12/06/4083[/TD]
[TD="bgcolor: transparent, align: right"]12/03/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]19/03/2018[/TD]
[TD="bgcolor: transparent, align: right"]19/03/2018[/TD]
[TD="bgcolor: transparent, align: right"]20/03/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent, align: right"]22/03/2018[/TD]
[TD="bgcolor: transparent, align: right"]22/03/2018[/TD]
[TD="bgcolor: transparent, align: right"]24/03/2018[/TD]
[/TR]
</tbody>[/TABLE]

I think I must be doing someting wrong

 

[Fluff]

You need to format the meter readings columns, either as general, or as number