Find columns with the same name and copy to new worksheet

[thedeadzeds]

Hi Guys.

I have a table which is exported daily. As you can see lots of columns contain the same name. I would like to create 3 seperate worksheets. 1 containing all of the Bonus Columns, 1 containing all of the Back Columns, and one containing all of the Front Columns. Also, each worksheet should also include Site, Name, Type and Sale

Many thanks

Site	Name	Stage	Result	Type	Order	Sale	Bonus	Bonus	Bonus	Bonus	Bonus	Front	Front	Front	Front	Front	Front	Back	Back	Back	Back	Back	Back
Cardiff	Steve	1	Y	New	Y	n	10	24	38	52	66	80	94	108	122	136	150	164	178	192	206	220	234
Cardiff	Jim	1	N	Used	y	n	11	25	39	53	67	81	95	109	123	137	151	165	179	193	207	221	235
Cardiff	Dave	1	N	Used	y	n	15	29	43	57	71	85	99	113	127	141	155	169	183	197	211	225	239
Cardiff	Steve	1	N	Used	y	n	25	39	53	67	81	95	109	123	137	151	165	179	193	207	221	235	249
Cardiff	Jim	4	N	Used	y	n	42	56	70	84	98	112	126	140	154	168	182	196	210	224	238	252	266
Cardiff	Dave	3	Y	Used	y	y	52	66	80	94	108	122	136	150	164	178	192	206	220	234	248	262	276
Cardiff	Matt	5	Y	Used	n	y	5	19	33	47	61	75	89	103	117	131	145	159	173	187	201	215	229
Cardiff	Dave	6	Y	Used	n	y	54	68	82	96	110	124	138	152	166	180	194	208	222	236	250	264	278
Cardiff	Matt	8	N	Used	n	y	12	26	40	54	68	82	96	110	124	138	152	166	180	194	208	222	236
Birmingham	Steve	1	N	Used	n	y	12	26	40	54	68	82	96	110	124	138	152	166	180	194	208	222	236
Birmingham	Jim	1	N	New	n	y	3	17	31	45	59	73	87	101	115	129	143	157	171	185	199	213	227
Birmingham	Dave	1	Y	New	y	n	65	79	93	107	121	135	149	163	177	191	205	219	233	247	261	275	289
Birmingham	Matt	2	Y	New	y	y	85	99	113	127	141	155	169	183	197	211	225	239	253	267	281	295	309
Birmingham	Dave	2	N	New	y	y	7	21	35	49	63	77	91	105	119	133	147	161	175	189	203	217	231
Birmingham	Steve	2	Y	New	y	y	48	62	76	90	104	118	132	146	160	174	188	202	216	230	244	258	272
Birmingham	Jim	2	Y	New	y	y	9	23	37	51	65	79	93	107	121	135	149	163	177	191	205	219	233
Birmingham	Dave	2	N	New	y	y	8	22	36	50	64	78	92	106	120	134	148	162	176	190	204	218	232
Birmingham	Matt	2	N	New	n	n	5	19	33	47	61	75	89	103	117	131	145	159	173	187	201	215	229
Bristol	Steve	3	Y	New	n	n	12	26	40	54	68	82	96	110	124	138	152	166	180	194	208	222	236
Bristol	Steve	4	Y	New	n	n	13	27	41	55	69	83	97	111	125	139	153	167	181	195	209	223	237
Bristol	Jim	5	N	New	n	n	1	15	29	43	57	71	85	99	113	127	141	155	169	183	197	211	225
Bristol	Dave	1	N	New	n	n	25	39	53	67	81	95	109	123	137	151	165	179	193	207	221	235	249
Bristol	Matt	2	N	Used	n	n	67	81	95	109	123	137	151	165	179	193	207	221	235	249	263	277	291
Bristol	Matt	3	N	Used	y	y	98	112	126	140	154	168	182	196	210	224	238	252	266	280	294	308	322
Bristol	Matt	3	Y	Used	y	y	8	22	36	50	64	78	92	106	120	134	148	162	176	190	204	218	232
Bristol	Matt	5	Y	Used	y	y	9	23	37	51	65	79	93	107	121	135	149	163	177	191	205	219	233
Bristol	Matt	4	Y	Used	y	y	7	21	35	49	63	77	91	105	119	133	147	161	175	189	203	217	231

 

[Peter_SSs]

You're welcome. Glad we could help.