COPY AND INSERT WHOLE ROWS DATA , ACCORDING TO TIME

[rameshlaha35]

Dear Team,
In the Input data sheet ,when user change the delivery time (Let from 02:00 to 05:00) .
Then whole rows data should be moved down or up(auto arrange) to the same delivery time.

MY DATA.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		PRN	DELIVERY TIME	STD/ORD	ITEM1	ITEM2	ITEM3	ITEM4	ITEM5	ITEM6	ITEM7	ITEM8	ITEM9	ITEM10		ITEM11	ITEM12	ITEM13	ITEM14	ITEM15	ITEM16	ITEM17	ITEM18	ITEM19	ITEM20
2		8701	2:00	STD	24	21	23	50	68	32	43	67	55	49	1:55	42	86	37	55	21	72	59	43	68	15
3				ORDERED	18	17	14	13	25	34	9	36	33	37		13	13	10	31	15	27	22	31	30	37
4		8702	3:25	STD	88	69	42	56	17	65	75	88	44	49	3:20	11	50	25	48	49	16	75	31	87	85
5				ORDERED	21	14	9	35	39	24	26	24	36	35		11	14	24	39	33	25	17	19	37	27
6		8703	4:05	STD	78	28	16	38	32	41	55	13	48	76	4:00	35	59	61	51	39	35	59	41	28	48
7				ORDERED	27	12	25	10	25	40	35	22	17	36		25	11	19	21	17	35	11	26	37	36
8		8704	4:25	STD	55	26	46	61	43	37	42	18	37	55	4:20	21	60	80	76	60	67	47	90	48	65
9				ORDERED	11	19	32	13	10	37	28	21	37	34		9	35	20	22	37	36	19	24	23	31
10		8705	5:15	STD	43	85	59	47	13	82	43	81	38	75	5:10	14	75	68	63	82	56	47	43	89	30
11				ORDERED	15	20	22	21	17	24	40	10	17	24		24	28	16	30	13	12	24	12	23	10
12		8706	5:40	STD	16	45	71	19	44	62	23	43	10	78	5:35	36	59	70	62	60	64	39	58	28	83
13				ORDERED	36	35	11	26	40	18	39	27	12	18		15	30	9	11	21	30	11	18	25	33
14		8707	9:05	STD	66	45	26	70	79	43	22	13	67	12	9:00	26	46	19	31	57	48	26	17	29	35
15				ORDERED	30	26	35	17	14	38	36	17	32	12		38	35	11	23	35	9	19	33	9	33
16		8708	9:30	STD	14	87	39	68	69	63	10	48	78	53	9:25	12	21	23	34	45	10	74	81	27	81
17				ORDERED	18	37	12	40	18	24	29	20	30	38		16	30	18	16	24	26	30	27	30	29
18		8709	10:00	STD	22	48	77	15	69	24	19	52	85	73	9:55	85	59	27	65	16	26	76	65	40	85
19				ORDERED	15	22	31	33	32	22	25	39	40	15		21	25	32	16	39	34	28	11	40	11
20		8710	10:55	STD	78	16	18	22	63	41	23	67	61	26	10:50	27	57	77	23	61	24	44	81	12	35
21				ORDERED	12	21	40	29	39	23	20	33	12	15		28	33	30	30	30	24	10	26	14	14
22		8711	11:30	STD	33	36	50	15	16	50	25	79	13	33	11:25	41	52	47	52	27	43	56	40	19	82
23				ORDERED	31	30	38	27	23	38	27	40	24	31		21	30	18	21	30	37	19	30	27	23
24		8712	13:30	STD	47	81	23	34	27	31	14	65	50	69	13:25	83	15	84	84	86	79	65	47	71	59
25				ORDERED	31	12	21	40	19	36	20	15	20	25		14	35	21	25	37	35	27	27	38	10
26		8713	13:40	STD	86	24	33	25	70	50	46	10	14	33	13:35	15	17	26	35	66	62	30	67	20	21
27				ORDERED	12	37	32	11	15	14	15	13	12	33		16	29	15	39	38	15	30	23	16	34
28		8714	14:20	STD	16	54	44	88	74	54	64	45	33	78	14:15	26	36	16	80	48	51	33	86	46	75
29				ORDERED	14	33	14	15	22	22	18	17	17	16		22	24	18	29	33	17	21	31	33	15
30		8715	14:45	STD	81	22	54	60	57	67	86	18	39	75	14:40	65	58	29	10	62	80	54	17	64	70
31				ORDERED	22	33	18	11	14	38	30	30	25	11		29	30	19	38	13	33	16	20	28	29
32		8716	15:00	STD	81	22	54	60	57	67	86	18	39	75	14:55	65	58	29	10	62	80	54	17	64	70
33				ORDERED	28	39	28	15	32	27	9	28	37	36		12	34	11	17	13	13	22	38	28	18
34		8717	15:35	STD	81	22	54	60	57	67	86	18	39	75	15:30	65	58	29	10	62	80	54	17	64	70
35				ORDERED	39	28	21	12	29	27	12	23	14	14		21	10	15	23	19	19	40	30	22	25
36		8718	15:55	STD	81	22	54	60	57	67	86	18	39	75	15:50	65	58	29	10	62	80	54	17	64	70
37				ORDERED	33	23	33	16	10	35	14	25	9	37		23	26	25	40	13	27	29	10	22	18
38		8719	16:10	STD	81	22	54	60	57	67	86	18	39	75	16:05	65	58	29	10	62	80	54	17	64	70
39				ORDERED	35	34	10	32	34	26	27	36	18	17		28	29	29	14	34	30	40	31	20	24
40		8720	16:40	STD	81	22	54	60	57	67	86	18	39	75	16:35	65	58	29	10	62	80	54	17	64	70
41				ORDERED	20	10	35	33	29	39	34	35	27	15		20	32	36	11	18	18	15	37	36	18
42		8721	17:15	STD	81	22	54	60	57	67	86	18	39	75	17:10	65	58	29	10	62	80	54	17	64	70
43				ORDERED	11	16	11	34	33	27	16	13	14	35		19	32	23	38	14	33	27	32	40	28
44		8722	17:40	STD	81	22	54	60	57	67	86	18	39	75	17:35	65	58	29	10	62	80	54	17	64	70
45				ORDERED	37	13	40	13	39	10	40	12	33	13		25	19	10	33	35	27	9	27	27	17
46		8723	17:55	STD	81	22	54	60	57	67	86	18	39	75	17:50	65	58	29	10	62	80	54	17	64	70
47				ORDERED	40	20	35	38	21	36	14	9	19	36		32	12	19	12	14	19	30	13	36	38
INPUT DATA-2

Cell Formulas
Range	Formula
O2,O46,O44,O42,O40,O38,O36,O34,O32,O30,O28,O26,O24,O22,O20,O18,O16,O14,O12,O10,O8,O6,O4	O2	=+C2-TIME(0,5,0)

Any one please help on this problem.
Thanks,
Ramesh

 

[rameshlaha35]

Any one help on this problem please...