Copy multiple rows based on data to another workbook.

[dilshod_k]

Hello everyone,

I’ve workbook with data (range A to M) sorted in chronological descending order, around 100k rows.
The aim is to create code that copies all rows with the same date (dates in column B) to workbook Results.xlsm, adds sheet with name equal to that date and then does the same thing with data corresponding to the previous date. For example copy of all rows with date 12/31/2020 to a new sheet, name that sheet 12.31.2020, and go next to 12/30/2020 e.t.c. I know function how to find single row with a given date, but I could not figure out how to copy multiple rows based on certain criteria to another workbook. I would be grateful for any help. Thanks in advance.
Dilshod

 

[dilshod_k]

Same error, same result as after previous modification.

 

[dilshod_k]

There are 167 rows with date 1/8/2021, out of them it copies only one row to a new sheet, gives that sheet name 01.08.21 and then tries to add another sheet with the same name and gives error message.

 

[Olukunle]

There are 167 rows with date 1/8/2021, out of them it copies only one row to a new sheet, gives that sheet name 01.08.21 and then tries to add another sheet with the same name and gives error message.

How I wish you could send me your file so we can resolve this once and for all. Because the code is working here.

 

[dilshod_k]

OrderHistVolChCopy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Symbol	Date	Open	High	Low	Close	Adj. Close	Volume	V/SMA10	SMA4	SMA10	SMA30	Close/Change%
2	OEG	1/8/2021	3.11	3.95	3.03	3.4	3.4	17307735	1756942	885.11%	0.48	0.29	1316.67%
3	ACGL	1/8/2021	36.43	36.51	35.69	36.44	36.44	4449800	2041180	118.00%	35.63	34.46	0.55%
4	ACIA	1/8/2021	77.45	86	77.45	79.6	79.6	16043500	2572740	523.60%	73.19	71.34	9.87%
5	ADC	1/8/2021	64.87	65.54	64.7	64.97	64.97	1904700	825480	130.74%	65.37	65.26	0.29%
6	ADCT	1/8/2021	32.24	33.81	31.3	32.68	32.68	498800	227800	118.96%	32.56	34.12	3.42%
7	ADI	1/8/2021	156.02	159.81	155.82	156.74	156.74	4204900	1936820	117.10%	148.3	143.98	0.73%
8	ADP	1/8/2021	168.97	172.38	168.31	171.05	171.05	2638700	1350930	95.32%	172.33	173.63	1.30%
9	ADT	1/8/2021	8.5	9.39	8.44	8.83	8.83	12634000	3725010	239.17%	8.1	8.18	5.12%
10	AJAX	1/8/2021	11.45	11.61	11.42	11.46	11.46	2140000	1002720	113.42%	11.76	11.71	0.26%
11	ALDX	1/8/2021	8.6	10.45	8.6	10.31	10.31	3445000	1252110	175.14%	7.37	7.23	21.72%
12	ALLT	1/8/2021	12.96	14.63	12.88	14.39	14.39	1335700	357550	273.57%	11.24	10.68	12.51%
13	AMRC	1/8/2021	60.5	63.45	59.44	61.28	61.28	1075000	518270	107.42%	53.62	48.57	2.30%
14	AMX	1/8/2021	14.91	15.11	14.88	14.96	14.96	3900300	1797990	116.93%	14.7	14.47	0.74%
15	ANET	1/8/2021	297.76	307.22	297.33	306.12	306.12	1104200	555390	98.82%	290.39	282.34	3.43%
16	APWC	1/8/2021	2.52	2.92	2.3	2.85	2.85	1117400	208450	436.05%	2.28	2.18	18.26%
17	ASTC	1/8/2021	1.97	2.06	1.9	2.04	2.04	1558100	777460	100.41%	1.86	1.87	7.37%
18	AVEO	1/8/2021	7.25	7.7	7.06	7.51	7.51	975600	440540	121.46%	6.17	5.59	4.16%
19	AVYA	1/8/2021	20.91	22.66	20.53	22.06	22.06	3988600	1159300	244.05%	19.51	19.53	11.70%
20	BBL	1/8/2021	60.23	60.45	59.39	60.17	60.17	2517000	1151660	118.55%	55.6	52.6	0.75%
21	BGI	1/8/2021	0.94	1.5	0.88	1.18	1.18	16768900	2805440	497.73%	0.89	0.88	35.63%
22	BIDU	1/8/2021	227.06	241	218	240.25	240.25	22716500	11770590	92.99%	209.8	178.15	15.57%
23	BL	1/8/2021	128.12	132.51	127.23	129.69	129.69	1742800	618340	181.85%	131.27	127.88	1.75%
24	BL	1/8/2021	128.12	132.51	127.23	129.69	129.69	1742800	618340	181.85%	131.27	127.88	1.75%
25	BOXL	1/8/2021	1.73	1.94	1.65	1.76	1.76	14522700	5149720	182.01%	1.6	1.63	2.92%
26	BRQS	1/8/2021	1.07	1.34	1.04	1.33	1.33	39250900	5410030	625.52%	1.05	1.07	29.13%
27	BSMX	1/8/2021	5.58	5.61	5.43	5.61	5.61	499200	222180	124.68%	5.25	5.31	1.81%
28	CATM	1/8/2021	40.5	42.09	40.23	41.08	41.08	4769300	1027230	364.29%	35.97	32.62	15.13%
29	CG	1/8/2021	31.7	32.23	31.51	32.16	32.16	2061200	941370	118.96%	31.41	30.32	2.19%
30	CHGG	1/8/2021	92.79	96.89	92.29	96.63	96.63	2907700	1480940	96.34%	90.92	84.95	5.93%
31	CIG	1/8/2021	2.8	2.98	2.8	2.88	2.88	17964300	7235260	148.29%	2.8	2.66	6.27%
32	CLIR	1/8/2021	3.14	3.39	3.14	3.37	3.37	560100	236400	136.93%	3.1	2.89	6.31%
33	CLNC	1/8/2021	8.3	8.67	8.24	8.66	8.66	1249900	510780	144.70%	7.65	7.64	5.48%
34	CLPS	1/8/2021	3.7	4.18	3.42	3.69	3.69	2530300	557500	353.87%	3.16	3.13	11.48%
35	CLSN	1/8/2021	0.83	0.98	0.78	0.85	0.85	8738400	3525840	147.84%	0.77	0.7	3.66%
36	CMRX	1/8/2021	6.55	9.36	6.55	8.42	8.42	20376900	2335170	772.61%	5.22	4.78	69.08%
37	CNET	1/8/2021	2.69	4.75	2.63	3.09	3.09	2.02E+08	26345920	668.46%	1.56	1.49	65.24%
38	CPSH	1/8/2021	3.03	3.94	2.98	3.58	3.58	2083200	620430	235.77%	2.81	2.51	18.54%
39	CRNT	1/8/2021	2.97	3.49	2.96	3.41	3.41	3436900	726270	373.23%	2.88	2.85	16.78%
40	CVI	1/8/2021	16.31	17.39	16	16.22	16.22	1364700	631770	116.01%	15.22	15.22	0.87%
41	CWK	1/8/2021	14.37	14.37	13.94	14.34	14.34	1388800	644610	115.45%	14.69	15.38	1.06%
42	CX	1/8/2021	5.78	5.86	5.72	5.76	5.76	24461500	10400640	135.19%	5.35	5.25	0.35%
43	DDD	1/8/2021	21.09	31.45	19.6	23.53	23.53	1.34E+08	35040790	281.43%	13.32	11.31	2.48%
44	DM	1/8/2021	21.01	22.34	19	20.78	20.78	8999200	3410030	163.90%	18	17.43	2.36%
45	DRIV	1/8/2021	27.01	27.05	26.2	26.5	26.5	2167100	880630	146.09%	24.47	23.34	2.00%
46	DSX	1/8/2021	2.1	2.45	2.1	2.37	2.37	1110400	496940	123.45%	1.97	1.88	16.75%
47	EDC	1/8/2021	107.44	110.53	106.01	110.17	110.17	1089200	227410	378.96%	95.81	88.75	7.93%
48	EFV	1/8/2021	49.48	49.5	49.01	49.47	49.47	2957500	1102570	168.24%	47.99	47.13	0.30%
49	EMAN	1/8/2021	1.92	2.24	1.92	2.19	2.19	4170700	1705230	144.58%	1.76	1.43	15.87%
50	ENIA	1/8/2021	8.34	8.41	8.3	8.41	8.41	1365000	682340	100.05%	8.26	7.97	2.56%
51	ENV	1/8/2021	84.61	86.29	84.23	85.62	85.62	1463100	440140	232.42%	82.52	81.92	1.70%
52	ESGE	1/8/2021	44.1	44.44	43.87	44.43	44.43	3962300	1461750	171.07%	42.29	41.15	2.66%
53	ESNT	1/8/2021	47.03	48.02	46.52	47.92	47.92	1200300	604410	98.59%	44.19	44.48	1.78%
54	FFIV	1/8/2021	193.72	200.57	189.02	191.24	191.24	1806500	595910	203.15%	178.18	172.61	6.19%
55	FGNA	1/8/2021	10.45	10.75	10.35	10.38	10.38	554900	241860	129.43%	10.23	10.1	0.34%
56	FPE	1/8/2021	20.24	20.24	20.19	20.24	20.24	3110900	1573860	97.66%	20.2	20.11	0.15%
57	FRBK	1/8/2021	2.97	3.04	2.91	3	3	3045800	721690	322.04%	2.92	2.94	0.67%
58	FTEK	1/8/2021	5	5.87	4.98	5.76	5.76	5929100	1887150	214.18%	4.45	4.26	19.50%
59	FTFT	1/8/2021	9.46	11.29	6.14	7.62	7.62	1.44E+08	46552510	208.65%	2.79	2.57	32.52%
60	GNK	1/8/2021	8.62	8.97	8.46	8.5	8.5	1948300	623470	212.49%	7.65	7.51	1.55%
61	GNRS	1/8/2021	10.25	10.33	10.14	10.3	10.3	549000	232050	136.59%	10.13	10.03	0.98%
62	GOCO	1/8/2021	15.2	16.37	15.04	16	16	2578900	1043510	147.14%	14.18	13.13	10.80%
63	GRFS	1/8/2021	19.23	19.65	19.16	19.6	19.6	872200	434070	100.94%	18.82	18.86	1.71%
64	GRNQ	1/8/2021	3.01	3.73	2.4	2.67	2.67	30279900	15867680	90.83%	1.92	1.59	20.27%
65	GRUB	1/8/2021	80.92	82.73	80.18	82.44	82.44	3231300	1496480	115.93%	76.2	72.44	6.57%
66	GSAH	1/8/2021	11.1	11.74	10.9	11.38	11.38	3142900	1485980	111.50%	10.98	10.65	3.45%
67	GSAT	1/8/2021	0.57	0.63	0.48	0.56	0.56	1.32E+08	20189640	555.02%	0.39	0.35	40.00%
68	HLT	1/8/2021	113.92	115.67	113.03	114.16	114.16	4065100	2069920	96.39%	109.73	107.2	0.77%
69	HOFV	1/8/2021	1.63	2.24	1.62	1.94	1.94	31119900	6471450	380.88%	1.45	1.4	22.78%
70	HOLX	1/8/2021	80.54	81.8	78.85	80.49	80.49	3155000	1605430	96.52%	74.93	73.63	3.23%
71	HVT	1/8/2021	30.2	32.81	29.79	30.82	30.82	459500	231130	98.81%	28.86	27.88	2.60%
72	IDEX	1/8/2021	3.47	3.89	3	3.16	3.16	1.74E+08	58741080	196.76%	2.34	2.2	6.04%
73	IFMK	1/8/2021	0.85	0.88	0.81	0.86	0.86	832300	273050	204.82%	0.8	0.81	4.88%
74	ILF	1/8/2021	30.69	30.75	30.28	30.61	30.61	2994900	1469140	103.85%	29.66	28.77	0.86%
75	INFY	1/8/2021	18.07	18.61	18.02	18.59	18.59	17801700	7952200	123.86%	17.28	16.22	5.93%
76	INMD	1/8/2021	49.79	50.25	48.57	50.22	50.22	963700	490090	96.64%	47.8	45.67	1.23%
77	INSG	1/8/2021	14.62	15.65	14.21	15.09	15.09	6230600	3143860	98.18%	15.17	13.5	8.02%
78	INUV	1/8/2021	0.61	0.67	0.57	0.63	0.63	11533600	5690110	102.70%	0.5	0.43	8.62%
79	IPOF	1/8/2021	14.11	14.65	13.33	14	14	11680800	5043760	131.59%	12.56	11.65	7.12%
80	ITRM	1/8/2021	1.22	1.45	1.19	1.23	1.23	9593400	3631200	164.19%	1.03	0.92	6.03%
81	KERN	1/8/2021	5	6.65	4.66	5.98	5.98	10839800	3888570	178.76%	3.91	3.81	21.30%
82	KOMP	1/8/2021	63.75	63.89	62.3	63.42	63.42	524900	240220	118.51%	58.93	55.93	0.97%
83	KSA	1/8/2021	31.81	32.17	31.54	31.75	31.75	789300	232130	240.02%	31.38	31.25	0.86%
84	KTRA	1/8/2021	1.39	1.4	1.31	1.38	1.38	734000	358550	104.71%	1.35	1.37	2.99%
85	LGHL	1/8/2021	4.99	5.39	3.11	3.66	3.66	23651700	2535360	832.87%	2.21	2.29	59.13%
86	LIVN	1/8/2021	65.23	67.08	65	65.84	65.84	1032200	427920	141.21%	66.12	62.18	1.37%
87	LMFA	1/8/2021	0.78	2.31	0.71	2.13	2.13	2.22E+08	24176590	818.80%	0.85	0.74	176.98%
88	LOPE	1/8/2021	90.4	92.35	90.4	91.31	91.31	515100	233210	120.87%	92.05	90.14	1.12%
89	LXRX	1/8/2021	3.65	4.21	3.6	3.84	3.84	4977900	2516240	97.83%	3.5	2.9	4.63%
90	MDGS	1/8/2021	2.9	3.16	2.47	2.6	2.6	25034200	4106820	509.58%	2.09	2.09	13.04%
91	MFH	1/8/2021	4.41	5.94	4.03	4.39	4.39	3148400	1150070	173.76%	3.39	3.09	4.77%
92	MICT	1/8/2021	2.5	2.67	2.26	2.41	2.41	1545700	626700	146.64%	2.26	1.95	4.78%
93	MLSS	1/8/2021	2.25	2.5	2.2	2.46	2.46	1305900	550940	137.03%	2.16	2.01	9.33%
94	MPW	1/8/2021	20.58	21.11	20.55	21.07	21.07	18054900	6568130	174.89%	21.27	20.74	2.83%
95	MTLS	1/8/2021	72	79.94	70.2	70.4	70.4	732000	291280	151.30%	58.02	50.57	1.32%
96	MUFG	1/8/2021	4.7	4.73	4.66	4.72	4.72	6178000	1605030	284.91%	4.48	4.4	1.29%
97	MX	1/8/2021	15.37	16.88	15.26	16	16	1336400	406170	229.02%	13.84	13.73	8.40%
98	MXIM	1/8/2021	94.46	96.71	93.77	94.41	94.41	3665400	1586940	130.97%	89.02	86.34	0.52%
99	NBIX	1/8/2021	104	113.22	103.53	112.07	112.07	2644500	801920	229.77%	98.39	96.63	9.00%
100	NEWR	1/8/2021	71.5	77.54	70.85	75.18	75.18	2759500	659820	318.22%	65.87	64.58	15.77%
101	NNOX	1/8/2021	47.62	54.7	47.6	53.24	53.24	1653600	764440	116.32%	48.05	50.41	11.80%
102	NVFY	1/8/2021	2.41	3.38	2.41	3.04	3.04	1868900	270880	589.94%	2.44	2.26	27.20%
103	OCC	1/8/2021	3.52	3.75	3.35	3.51	3.51	994300	259320	283.43%	2.86	2.91	17.79%
104	OPTT	1/8/2021	3.09	3.12	2.77	2.78	2.78	9974800	4557150	118.88%	2.84	2.7	1.09%
105	OXFD	1/8/2021	21.9	22.49	21.86	22.29	22.29	4401100	1884570	133.53%	18.19	16.55	1.90%
106	PAGS	1/8/2021	54.84	55.15	53.73	54.6	54.6	3821800	1695020	125.47%	54.5	51.5	1.49%
107	PCRX	1/8/2021	68.59	72.06	68.44	70.14	70.14	1072600	539870	98.68%	61.59	60.52	3.65%
108	PDAC	1/8/2021	10.65	11.16	10.55	11.01	11.01	838600	413470	102.82%	10.48	10.18	4.66%
109	PLAG	1/8/2021	2.21	2.45	2.19	2.41	2.41	731400	266520	174.43%	2.21	2.15	9.55%
110	PLUG	1/8/2021	51.98	55.98	49.2	53.78	53.78	99975600	42018700	137.93%	37.05	30.99	13.72%
111	PNR	1/8/2021	55.25	56.44	55.14	56.1	56.1	2054600	802740	155.95%	53.01	52.25	1.94%
112	POLA	1/8/2021	6.68	7.99	6.35	7.4	7.4	5002400	1474340	239.30%	5.52	4.88	22.11%
113	PRLB	1/8/2021	183.64	195.24	181	185.71	185.71	1042800	434640	139.92%	164.56	155.02	1.42%
114	PRMW	1/8/2021	16.11	16.28	15.83	16.08	16.08	4260200	1745430	144.08%	15.92	15.73	1.77%
115	PRNT	1/8/2021	36.82	38.78	36.02	36.86	36.86	734600	240920	204.91%	32.65	31.16	1.26%
116	PRPO	1/8/2021	2.22	2.47	2.21	2.28	2.28	1514900	688510	120.03%	2.11	2.19	5.07%
117	PSTH	1/8/2021	27.9	31.21	27.21	29.32	29.32	9397900	4157640	126.04%	26.93	25.96	7.24%
118	PT	1/8/2021	1.16	1.21	1.14	1.21	1.21	899900	272730	229.96%	1.03	0.99	9.01%
119	PTE	1/8/2021	1.02	1.5	0.98	1.32	1.32	86723600	12252530	607.80%	0.77	0.7	71.43%
120	PVL	1/8/2021	0.83	0.91	0.81	0.91	0.91	548800	208710	162.95%	0.78	0.78	12.35%
121	QD	1/8/2021	1.35	1.68	1.32	1.62	1.62	17640900	6600300	167.27%	1.33	1.33	23.66%
122	RBAC	1/8/2021	10.8	10.85	10.7	10.78	10.78	1785500	596470	199.34%	10.88	10.75	0.56%
123	RCON	1/8/2021	1.63	1.94	1.6	1.92	1.92	3422800	1190040	187.62%	1.49	1.37	15.66%
124	REI	1/8/2021	1.14	1.18	1	1.07	1.07	10996600	5105510	115.39%	0.76	0.73	15.05%
125	RESN	1/8/2021	4	5.07	3.99	4.77	4.77	7796700	3561490	118.92%	3.23	2.57	21.99%
126	SALM	1/8/2021	1.2	1.33	1.19	1.28	1.28	893700	437890	104.09%	1.13	1.09	8.47%
127	SAN	1/8/2021	3.35	3.39	3.31	3.37	3.37	14525600	7627440	90.44%	3.19	3.15	0.30%
128	SB	1/8/2021	1.51	1.74	1.51	1.74	1.74	800700	403680	98.35%	1.37	1.23	15.23%
129	SBBP	1/8/2021	2.85	3.28	2.85	3.11	3.11	1922800	493230	289.84%	2.63	2.7	11.07%
130	SBLK	1/8/2021	10.15	11.17	10.13	11.08	11.08	1840000	804320	128.76%	9.14	8.46	12.95%
131	SCHA	1/8/2021	94.54	94.85	92.71	93.99	93.99	1677500	635560	163.94%	90.41	87.61	0.01%
132	SCHE	1/8/2021	31.86	32.14	31.7	32.14	32.14	6250900	1976450	216.27%	30.84	30.2	2.23%
133	SCOR	1/8/2021	3.57	3.6	2.92	3.29	3.29	3442100	1068950	222.01%	2.5	2.43	15.85%
134	SFET	1/8/2021	1.5	1.57	1.44	1.49	1.49	2009800	1034970	94.19%	1.4	1.25	5.67%
135	SGLB	1/8/2021	3.3	3.74	3.17	3.55	3.55	2197700	685040	220.81%	3.24	2.98	5.34%
136	SGOC	1/8/2021	1.64	2.2	1.58	1.99	1.99	3536600	1773140	99.45%	1.41	1.26	31.79%
137	SLRX	1/8/2021	1.08	1.22	1.04	1.18	1.18	2882800	1471140	95.96%	0.99	0.94	8.26%
138	SNDR	1/8/2021	22.13	22.68	22.13	22.24	22.24	1313600	627080	109.48%	21.08	20.94	0.77%
139	SNY	1/8/2021	48.15	48.47	47.82	48.45	48.45	4504200	2219720	102.92%	48.26	48.72	0.75%
140	SPEM	1/8/2021	43.75	44.13	43.56	44.13	44.13	5029000	1480250	239.74%	42.45	41.53	2.08%
141	SPMB	1/8/2021	26.48	26.48	26.44	26.46	26.46	2333200	973030	139.79%	26.44	26.41	0.04%
142	SPNV	1/8/2021	11.35	12.5	10.75	11.03	11.03	1222100	512750	138.34%	11.04	10.82	0.27%
143	SPOT	1/8/2021	335	354.6	333.29	353.11	353.11	2199000	899720	144.41%	322.15	320.1	6.56%
144	ST	1/8/2021	60.28	61.64	55.68	56.38	56.38	1868000	839250	122.58%	53.41	51.16	0.46%
145	STIM	1/8/2021	12.65	13.05	12.2	12.89	12.89	404100	205320	96.81%	11.22	9.71	6.79%
146	STNG	1/8/2021	12.78	14.05	12.67	13.63	13.63	3022700	1476500	104.72%	11.72	11.82	8.52%
147	STPK	1/8/2021	23.01	29.28	22.16	25.49	25.49	5100900	2052070	148.57%	21.06	17.17	9.35%
148	TBF	1/8/2021	16.38	16.46	16.33	16.38	16.38	1624600	682940	137.88%	15.94	15.84	0.24%
149	TGA	1/8/2021	1.01	1.15	0.99	1.14	1.14	1004400	404290	148.44%	0.97	0.85	14.00%
150	THMO	1/8/2021	2.3	2.53	2.26	2.47	2.47	2805700	918160	205.58%	2.18	2.24	9.29%
151	TLK	1/8/2021	25.45	25.62	25.21	25.52	25.52	1446700	351870	311.15%	24.3	23.78	3.07%
152	TRIP	1/8/2021	32.5	36.17	32.37	35.65	35.65	6132500	2729370	124.69%	29.49	28.43	11.51%
153	TRXC	1/8/2021	0.95	1.25	0.9	1.16	1.16	45244700	21394790	111.48%	0.81	0.63	28.89%
154	TUFN	1/8/2021	13.02	14.7	12.97	14.39	14.39	566300	216110	162.04%	12.68	10.76	10.69%
155	TWOU	1/8/2021	41.8	45.56	41.74	44.06	44.06	2208600	1134170	94.73%	40.78	37.07	6.00%
156	TYHT	1/8/2021	3.34	3.89	3.25	3.82	3.82	1621900	460500	252.20%	3.18	3.23	14.71%
157	UAMY	1/8/2021	0.64	0.76	0.62	0.67	0.67	11728100	5040650	132.67%	0.55	0.47	6.35%
158	UNP	1/8/2021	218	221.28	216.99	218.82	218.82	3922900	2046470	91.69%	207.75	204.59	2.87%
159	VERI	1/8/2021	33.01	38.84	32.21	38.45	38.45	2474900	1029150	140.48%	29.61	27.73	20.42%
160	VICI	1/8/2021	25.11	25.97	25	25.67	25.67	9307800	3504260	165.61%	25.33	25.4	3.09%
161	VONV	1/8/2021	123.65	123.83	122.29	123.53	123.53	415500	203300	104.38%	120.14	118.59	0.09%
162	VSTM	1/8/2021	2.34	2.55	2.31	2.53	2.53	6449600	2733770	135.92%	2.25	2.22	8.12%
163	WBS	1/8/2021	48.92	48.92	46.67	47.73	47.73	987100	500780	97.11%	43.62	41.78	1.55%
164	WRB	1/8/2021	67.04	67.24	65.43	66.36	66.36	2421800	886360	173.23%	65.87	65.73	0.53%
165	XAN	1/8/2021	4.03	4.35	3.86	4.3	4.3	1007400	469790	114.44%	3.99	3.93	9.14%
166	ZEN	1/8/2021	144.33	149.76	144.33	149.37	149.37	1853500	941120	96.95%	141.81	138.34	3.49%
167	ZLAB	1/8/2021	142.88	149.64	141.05	145.84	145.84	615700	296100	107.94%	134.29	120.87	4.31%
168	ZYME	1/8/2021	53.79	57.05	53.5	56.81	56.81	801800	319770	150.74%	50.46	51.81	6.11%
169	ACEV	1/7/2021	11.88	12	11.48	12	12	2081600	797710	160.95%	10.57	10.19	2.65%
170	ACTG	1/7/2021	3.92	4.4	3.91	4.22	4.22	720000	377090	90.94%	4.02	3.84	8.21%
171	ADTX	1/7/2021	2.17	2.41	2.16	2.35	2.35	1823000	665200	174.05%	2.17	2.09	9.30%
172	AEHL	1/7/2021	2.65	3.37	2.64	3.33	3.33	2838000	894650	217.22%	2.56	2.41	28.08%
173	AFI	1/7/2021	3.84	4.68	3.79	4.65	4.65	856400	279870	206.00%	3.89	3.65	24.66%
174	AFMD	1/7/2021	6.22	6.48	5.99	6.44	6.44	2491800	1283660	94.12%	6.12	6.12	8.78%
175	ALDX	1/7/2021	7.32	8.54	7.05	8.47	8.47	3962300	945030	319.28%	7.08	7.11	26.42%
176	ALGM	1/7/2021	28.25	31.15	28.16	29.94	29.94	1627500	787750	106.60%	26.41	26.16	6.66%
177	ALKS	1/7/2021	19.81	21.11	19.58	20.59	20.59	3343500	1309200	155.38%	20.45	20.12	5.59%
178	ALLT	1/7/2021	10.77	12.86	10.77	12.79	12.79	833200	231330	260.18%	10.92	10.53	19.53%
179	ALNY	1/7/2021	133.62	140	132.03	139.4	139.4	1072700	490320	118.78%	132.36	131.9	9.91%
180	AMRH	1/7/2021	4.02	5.11	3.71	4.79	4.79	6641300	2388350	178.07%	6.18	6.31	21.57%
181	ANGO	1/7/2021	16.51	19.52	16.5	18.57	18.57	1236400	358750	244.64%	15.22	14.69	14.70%
182	ANY	1/7/2021	1.52	2.35	1.49	2.23	2.23	5200800	834640	523.12%	1.58	1.6	48.67%
183	APHA	1/7/2021	8.77	9.39	8.55	8.59	8.59	21567900	10453450	106.32%	7.4	7.71	2.38%
184	ARTL	1/7/2021	1	1.1	0.93	1	1	7902400	4016710	96.74%	0.76	0.67	12.87%
185	ASH	1/7/2021	86.01	87.46	85.06	87.2	87.2	1035600	439790	135.48%	80.63	77.73	2.05%
186	ASHR	1/7/2021	42.77	43.12	42.65	43.11	43.11	6551900	2994180	118.82%	40.19	38.97	2.45%
187	ATH	1/7/2021	46.76	46.85	45.94	46.21	46.21	2044400	908710	124.98%	43.15	43.58	0.43%
188	ATHX	1/7/2021	1.81	2.12	1.8	1.97	1.97	5768400	2655820	117.20%	1.83	1.86	8.84%
189	AVEO	1/7/2021	6.4	7.24	6.4	7.21	7.21	941700	379630	148.06%	6.01	5.52	14.26%
190	AVNT	1/7/2021	45	46.38	44.24	45.7	45.7	1125500	489400	129.98%	41.06	39.3	4.43%
191	AVTR	1/7/2021	28.63	29.47	28.61	29.24	29.24	9565700	3878570	146.63%	27.55	27.19	3.61%
192	AXL	1/7/2021	8.92	9.89	8.86	9.76	9.76	4565600	1921590	137.59%	8.49	8.19	12.57%
193	BDSI	1/7/2021	4.55	4.99	4.52	4.87	4.87	1762100	742840	137.21%	4.34	4.21	8.22%
194	BE	1/7/2021	33.72	35.74	32.5	33.56	33.56	9003600	4505720	99.83%	29.38	27.28	10.32%
195	BEAT	1/7/2021	71.88	72.4	71.85	72.38	72.38	1823400	936520	94.70%	72.03	64.01	0.60%
196	BL	1/7/2021	127.74	129.49	126.59	127.46	127.46	969200	496360	95.26%	132.04	127.31	0.64%
197	BL	1/7/2021	127.74	129.49	126.59	127.46	127.46	969200	496360	95.26%	132.04	127.31	0.64%
198	BLI	1/7/2021	90.44	91.71	87	89.06	89.06	1048000	517840	102.38%	92.55	88.53	1.44%
199	BOXL	1/7/2021	1.6	1.79	1.52	1.71	1.71	14713900	3898720	277.40%	1.59	1.62	12.50%
200	BRFS	1/7/2021	4.03	4.11	3.99	4.09	4.09	8373200	3274810	155.69%	4.21	4.25	1.24%
201	BRQS	1/7/2021	1	1.1	1	1.03	1.03	4217600	1599540	163.68%	1.02	1.06	3.00%
202	CAH	1/7/2021	55.21	56.56	55.06	56.31	56.31	3344600	1637710	104.22%	53.69	54.08	2.27%
203	CARR	1/7/2021	40.41	41.19	40	41.09	41.09	7771900	3813720	103.79%	38.25	37.87	2.60%
204	CBAT	1/7/2021	8.77	8.8	7.31	7.72	7.72	39277200	12983520	202.52%	5.91	6.02	20.62%
205	CBRE	1/7/2021	60.81	61.63	60.43	61.5	61.5	2782300	1434940	93.90%	61.69	63.21	1.47%
206	CCNC	1/7/2021	2.45	3.3	2.34	2.79	2.79	3599300	919920	291.26%	1.98	1.76	25.11%
207	CCX	1/7/2021	10.4	10.89	10.38	10.53	10.53	5830500	1465310	297.90%	10.39	10.23	1.74%
208	CDEV	1/7/2021	1.79	2.06	1.75	1.99	1.99	13089400	6111430	114.18%	1.63	1.55	16.37%
209	CFX	1/7/2021	40.56	41.03	40.14	40.59	40.59	2715500	879720	208.68%	37.91	37.31	1.00%
210	CHRS	1/7/2021	17.36	18.08	17.16	17.89	17.89	2210900	915210	141.57%	17.22	17.83	4.01%
211	CIBR	1/7/2021	43.67	44.42	43.33	44.35	44.35	2986400	956440	212.24%	44.29	41.59	2.64%
212	CIK	1/7/2021	3.14	3.18	3.14	3.17	3.17	3559000	1657490	114.72%	3.17	3.16	0.96%
213	CLPS	1/7/2021	3.14	3.49	3.1	3.31	3.31	745000	325980	128.54%	3.09	3.11	6.77%
214	CNET	1/7/2021	1.6	2.14	1.51	1.87	1.87	42844500	6149090	596.76%	1.38	1.44	34.53%
215	COF	1/7/2021	108.65	111.54	108	110.73	110.73	4795700	2425760	97.70%	100.07	94.66	3.12%
216	CONX	1/7/2021	10.12	10.19	10.1	10.16	10.16	569800	241270	136.17%	10.18	10.18	0.20%
217	COWN	1/7/2021	26.92	28.47	26.92	28.32	28.32	766600	323120	137.25%	26.38	25.79	6.07%
218	CP	1/7/2021	361.72	371.38	358.95	370.19	370.19	475300	245060	93.95%	349.87	338.43	2.72%
219	CPST	1/7/2021	12.85	15.28	12.6	13.8	13.8	1007700	364490	176.47%	10.8	8.79	20.00%
220	CRH	1/7/2021	47.07	47.93	46.93	47.6	47.6	715600	313940	127.94%	43.49	41.76	2.04%
221	CRON	1/7/2021	9.12	9.37	8.78	8.81	8.81	10473500	5268450	98.80%	7.63	8.01	1.85%
222	CSLT	1/7/2021	1.45	1.78	1.45	1.61	1.61	1678100	771960	117.38%	1.38	1.28	11.03%
223	CTLT	1/7/2021	106.82	108.8	106.52	108.57	108.57	1824500	888340	105.38%	104.64	99.76	2.19%
224	CUBE	1/7/2021	32.96	33.16	32.58	33.16	33.16	2454700	1232670	99.14%	33.05	32.61	0.76%
225	CYRN	1/7/2021	1.07	1.33	1.05	1.19	1.19	2612800	580920	349.77%	1.06	1.04	14.42%
226	CYTK	1/7/2021	21.36	21.73	20.95	21.53	21.53	2010100	791950	153.82%	20.69	19.47	1.03%
227	DAC	1/7/2021	24.77	28.11	24.77	27.36	27.36	1183600	583320	102.91%	22.28	17.98	12.41%
228	DD	1/7/2021	77.97	80.94	77.97	80.88	80.88	19333900	9942430	94.46%	72.08	68.44	4.03%
229	DDD	1/7/2021	12.36	25.33	12.36	22.96	22.96	1.94E+08	24034550	705.37%	12.19	10.81	104.27%
230	DGRW	1/7/2021	54.05	54.49	53.9	54.39	54.39	785200	312400	151.34%	53.62	53.25	0.85%
Sheet1

 

[dilshod_k]

It is only part of the file as there is limitation to the number of cells that may be copied. I assume if the code will be able to create 2 sheets with all rows copied, it will work with the rest of the data.

 

[Olukunle]

It is only part of the file as there is limitation to the number of cells that may be copied. I assume if the code will be able to create 2 sheets with all rows copied, it will work with the rest of the data.

Hello Dilshod,
Finally, this should work. The problem was the Date has Time element hence they are not unique. I have added lines of code that resolves that.

Sub CopySameDate()
x = Format([B2], "dd-mm-yy")
Application.ScreenUpdating = False
With Sheet1 ' Replace this with your data sheet code name or worksheet name
    a_du = .Range("B2:B" & .Cells(Rows.Count, 1).End(xlUp).Row)
    For d = 1 To UBound(a_du)
        a_du(d, 1) = CDate(WorksheetFunction.Text(a_du(d, 1), "dd-mmm-yy"))
    Next d
    .Range("B2").Resize(UBound(a_du)) = a_du
    
    .Range("XFD1") = .Range("B1").Value
    a_su = DistinctVals(.Range("B2:B" & .Cells(Rows.Count, 1).End(xlUp).Row)) ' Assumes your date value is in Column A
    For J = 1 To UBound(a_su)
        .Range("XFD2") = a_su(J, 1)
        Sheets.Add(, Sheets(Sheets.Count)).Name = Format(a_su(J, 1), "mm.dd.yy")
        .Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range("XFD1:XFD2"), _
        CopyToRange:=ActiveSheet.Range(Cells(1, 1), Cells(1, .Range("A1").CurrentRegion.Columns.Count)), Unique:=False
    Next J
    .Range("XFD1:XFD2").Clear
End With
Erase a_su
End Sub
Function DistinctVals(a, Optional col = 1)
    Dim i&, v: v = a
    With CreateObject("Scripting.Dictionary")
        For i = 1 To UBound(v): .Item(v(i, col)) = 1: Next i
        DistinctVals = Application.Transpose(.Keys)
    End With
End Function

 

[dilshod_k]

Hello Olukunle,

It does work perfectly well! Thank you very much. Highly appreciate your efforts.
Dilshod

 

[Olukunle]

Hello Olukunle,

It does work perfectly well! Thank you very much. Highly appreciate your efforts.
Dilshod

Happ to hear that and thanks for the feedback