Cosolidating data

[Philip Rogers]

I am trying to find a way to consolidate the data that is on three different worksheets. The column headings are the same BUT the information in Col A Row 1 to .... is different. The data in the columns to the right is determined by the name in col A.

Bowling.htm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Statistics
2	Club:FennerCricketClub
3	MatchType:EYCAPremierLeague	Season:2005
4	Player:All
5	Name	M	Overs	Mdns	Runs	Wkts	Avg	Econ.	S/r	5wh	Best	%Total
6	AHussain	2	5	1	30	1	30.00	6.00	30.00	0	1-30	0.68%
7	GPowley	7	15	2	70	2	35.00	4.67	45.00	0	1-21	1.36%
8	JLatus	3	16	3	54	2	27.00	3.38	48.00	0	1-20	1.36%
9	JMPark	17	190.3	49	456	41	11.12	2.39	27.88	2	6-49	27.89%
10	JPSowter	17	103	16	357	19	18.79	3.47	32.53	1	7-88	12.93%
11	LLaybourne	12	62	11	221	5	44.20	3.56	74.40	0	3-60	3.40%
12	MArundell	9	14	2	54	8	6.75	3.86	10.50	0	4-10	5.44%
13	PFuller	14	77	10	268	12	22.33	3.48	38.50	0	4-76	8.16%
14	PScrowston	18	25	4	81	5	16.20	3.24	30.00	0	3-38	3.40%
15	RBarker	10	58	10	202	14	14.43	3.48	24.86	0	5-22	9.52%
16	SHewitt	19	175.1	44	467	34	13.74	2.67	30.91	1	3-11	23.13%
17	SLatus	1	3.5	0	11	4	2.75	2.87	5.75	0	4-11	2.72%
2005 Bowling

 

[Philip Rogers]

Consolidating data

The information in Col B is in multiples of 6 i.e 10.3 = 10 + 3/6

 

[Philip Rogers]

Consolidating Data

Should read COL C not Col B

 

[Philip Rogers]

Bowling.htm
	A	B	C	D	E	F	G	H	I	J	K	L
5	Name	M	Overs	Mdns	Runs	Wkts	Avg	Econ.	S/r	5wh	Best	% Total
6	A Hussain	2	5	1	30	1	30.00	6.00	30.00	0	1-30	0.68%
7	G Powley	7	15	2	70	2	35.00	4.67	45.00	0	1-21	1.36%
8	J Latus	3	16	3	54	2	27.00	3.38	48.00	0	1-20	1.36%
9	J M Park	17	190.3	49	456	41	11.12	2.39	27.88	2	6-49	27.89%
10	J P Sowter	17	103	16	357	19	18.79	3.47	32.53	1	7-88	12.93%
11	L Laybourne	12	62	11	221	5	44.20	3.56	74.40	0	3-60	3.40%
12	M Arundell	9	14	2	54	8	6.75	3.86	10.50	0	4-10	5.44%
13	P Fuller	14	77	10	268	12	22.33	3.48	38.50	0	4-76	8.16%
14	P Scrowston	18	25	4	81	5	16.20	3.24	30.00	0	3-38	3.40%
15	R Barker	10	58	10	202	14	14.43	3.48	24.86	0	5-22	9.52%
16	S Hewitt	19	175.1	44	467	34	13.74	2.67	30.91	1	3-11	23.13%
17	S Latus	1	3.5	0	11	4	2.75	2.87	5.75	0	4-11	2.72%
2005 Bowling