VBA Code to fill in tables?

[rokunation]

I have the following data, wondering if VBA code can be created to create tables in a separate sheet.

Book1
	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	Z	AA	AB	AC
1	CUSTOMER NAME	INVOICE NUMBER	INVOICE DATE	LINE ABBREV	PART NUMBER	DESCRIPTION	QUANTITY SOLD	NET PRICE	EXTENDED PRICE	UNIT COST	ORIGIN	PO NUMBER	ATTENTION	Actual Date	STATUS	Identifier	Part Request ID	Request Time	ReqApprove	Time Diff (Req-REQApp)	Time Diff (Operational Hours) (Req-REQApp)	Approved Time	Ready Time	Closed Time	Request->Ready Calendar Time	Time Difference (Approve-->Ready)	Time Difference (Operational Hours) (Approve->Ready)	Fill/No Fill	ROLL UP NAME
2	CITY OF TORONTO -DISCO	946631	4072022	NGF	7312MP	OIL FILTER	1	18.23	18.23	24.43	NAPA ACCESS GENERATED	079013 770662	STOCK	04/07/2022	STOCK	NGF7312MP079013 770662	147694	2022-04-07 11:45:27 AM	2022-04-07 11:51:12 AM	0:05:45	0:05:45	2022-04-07 1:20:41 PM	2022-04-07 1:36:22 PM	2022-04-07 2:12:15 PM	1:50:55	0:15:41	0:15:41	FILL	CITY OF TORONTO -DISCO
3	CITY OF TORONTO -DISCO	946631	4072022	NGF	9886	AIR FILTER	1	65.96	65.96	88.38	NAPA ACCESS GENERATED	079013 770662	STOCK	04/07/2022	STOCK	NGF9886079013 770662	147695	2022-04-07 11:46:03 AM	2022-04-07 11:51:12 AM	0:05:09	0:05:09	2022-04-07 1:20:41 PM	2022-04-07 1:36:31 PM	2022-04-07 2:12:15 PM	1:50:28	0:15:50	0:15:50	FILL	CITY OF TORONTO -DISCO
4	CITY OF TORONTO -DISCO	946614	4052022	NUP	89250	BATTERY	1	27.82	27.82	27.82	NAPA ACCESS GENERATED	267085 770302	STOCK	04/05/2022	STOCK	NUP89250267085 770302	147242	2022-04-05 7:50:00 AM	2022-04-05 8:21:11 AM	0:31:11	0:31:11	2022-04-05 8:31:31 AM	2022-04-05 8:47:52 AM	2022-04-05 9:12:20 AM	0:57:52	0:16:21	0:16:21	FILL	CITY OF TORONTO -DISCO
5	CITY OF TORONTO -DISCO	946714	4212022	NLG	9003	31004 HALOGEN CAPSULE	1	5.58	5.58	5.58	NAPA ACCESS GENERATED	204039 771567	STOCK	04/21/2022	STOCK	NLG9003204039 771567	149117	2022-04-21 12:39:25 PM	2022-04-21 1:14:53 PM	0:35:28	0:35:28	2022-04-21 1:14:59 PM	2022-04-21 1:31:22 PM	2022-04-21 2:02:18 PM	0:51:57	0:16:23	0:16:23	FILL	CITY OF TORONTO -DISCO
6	CITY OF TORONTO -DISCO	946666	4122022	NGF	1748XD	HD LUBE FILTER	1	42.34	42.34	56.73	NAPA ACCESS GENERATED	188048 771083	STOCK	04/12/2022	STOCK	NGF1748XD188048 771083	148242	2022-04-12 12:29:27 PM	2022-04-12 12:35:03 PM	0:05:36	0:05:36	2022-04-12 1:01:44 PM	2022-04-12 1:18:52 PM	2022-04-12 1:20:57 PM	0:49:25	0:17:08	0:17:08	FILL	CITY OF TORONTO -DISCO
7	CITY OF TORONTO -DISCO	946624	4062022	KFL	472	GASKET CLEAR SILICONE	2	12.02	24.04	12.02	NAPA ACCESS GENERATED	194005 770502	STOCK	04/06/2022	STOCK	KFL472194005 770502	147417	2022-04-06 8:18:08 AM	2022-04-06 8:19:39 AM	0:01:31	0:01:31	2022-04-06 8:45:00 AM	2022-04-06 9:02:32 AM	2022-04-06 11:42:45 AM	0:44:24	0:17:32	0:17:32	FILL	CITY OF TORONTO -DISCO
8	CITY OF TORONTO -DISCO	946626	4062022	NGF	7182	HD LUBE FILTER	1	12.54	12.54	16.8	NAPA ACCESS GENERATED	204032 770501	STOCK	04/06/2022	STOCK	NGF7182204032 770501	147408	2022-04-06 7:50:24 AM	2022-04-06 7:53:56 AM	0:03:32	0:03:32	2022-04-06 8:45:00 AM	2022-04-06 9:02:32 AM	2022-04-06 11:44:49 AM	1:12:08	0:17:32	0:17:32	FILL	CITY OF TORONTO -DISCO
9	CITY OF TORONTO -DISCO	946629	4072022	5KF	25960	KEEP FILL	1	482.57	482.57	482.57	NAPA ACCESS GENERATED	FL1702 770210	STOCK	04/07/2022	STOCK	5KF25960FL1702 770210	147409	2022-04-06 7:51:17 AM	2022-04-06 8:33:47 AM	0:42:30	0:42:30	2022-04-06 8:45:00 AM	2022-04-06 9:02:32 AM	2022-04-07 8:51:48 AM	1:11:15	0:17:32	0:17:32	FILL	CITY OF TORONTO -DISCO
10	CITY OF TORONTO -DISCO	946710	4212022	DSS	DS10025	RUST CHECK	1	10.33	10.33	10.33	NAPA ACCESS GENERATED	267127 771628	STOCK	04/21/2022	STOCK	DSSDS10025267127 771628	148978	2022-04-20 1:55:47 PM	2022-04-20 2:46:21 PM	0:50:34	0:50:34	2022-04-21 6:51:06 AM	2022-04-21 7:08:53 AM	2022-04-21 7:19:40 AM	17:13:06	0:17:47	0:17:47	FILL	CITY OF TORONTO -DISCO
11	CITY OF TORONTO -DISCO	946676	4132022	2SC	87712194	CABIN FILTER	1	164.24	164.24	164.24	NAPA ACCESS GENERATED	323085 769116	STOCK	04/13/2022	STOCK	2SC87712194323085 769116	147484	2022-04-06 9:36:34 AM	2022-04-07 12:32:13 PM	26:55:39	11:25:39	2022-04-07 1:20:41 PM	2022-04-07 1:39:30 PM	2022-04-13 7:50:24 AM	28:02:56	0:18:49	0:18:49	FILL	CITY OF TORONTO -DISCO
12	CITY OF TORONTO -DISCO	946647	4082022	2TS	ICE1480C	CABLE TIES / TECHSPAN	1	11.14	11.14	11.14	GENERATED AT THE COUNTER	159034 770300	STOCK	04/08/2022	STOCK	2TSICE1480C159034 770300	147700	2022-04-07 12:02:57 PM	2022-04-07 12:04:59 PM	0:02:02	0:02:02	2022-04-07 1:20:41 PM	2022-04-07 1:39:45 PM	2022-04-08 11:16:53 AM	1:36:48	0:19:04	0:19:04	FILL	CITY OF TORONTO -DISCO
13	CITY OF TORONTO -DISCO	946668	4122022	KFL	837	AIR INTAKE KLEEN	2	6.01	12.02	6.01	NAPA ACCESS GENERATED	188042 770520	STOCK	04/12/2022	STOCK	KFL837188042 770520	147713	2022-04-07 1:06:49 PM	2022-04-07 1:19:50 PM	0:13:01	0:13:01	2022-04-07 1:20:51 PM	2022-04-07 1:39:55 PM	2022-04-12 2:21:50 PM	0:33:06	0:19:04	0:19:04	FILL	CITY OF TORONTO -DISCO
14	CITY OF TORONTO -DISCO	946676	4132022	2SC	6D84389987	CABIN AIR FILTER	1	52.5	52.5	52.5	NAPA ACCESS GENERATED	323085 769116	STOCK	04/13/2022	STOCK	2SC6D84389987323085 769116	147485	2022-04-06 9:36:50 AM	2022-04-07 12:46:30 PM	27:09:40	11:39:40	2022-04-07 1:20:41 PM	2022-04-07 1:40:08 PM	2022-04-13 7:50:25 AM	28:03:18	0:19:27	0:19:27	FILL	CITY OF TORONTO -DISCO
15	CITY OF TORONTO -DISCO	946690	4142022	2TW	TRL4550	TAIL LIGHT RED	1	22.88	22.88	22.88	NAPA ACCESS GENERATED	267232 770964	STOCK	04/14/2022	STOCK	2TWTRL4550267232 770964	148193	2022-04-12 7:30:51 AM	2022-04-12 10:54:26 AM	3:23:35	3:23:35	2022-04-12 11:22:14 AM	2022-04-12 11:42:16 AM	2022-04-14 1:39:44 PM	4:11:25	0:20:02	0:20:02	FILL	CITY OF TORONTO -DISCO
16	CITY OF TORONTO -DISCO	946633	4072022	NGF	4466	CABIN FILTER	1	17.55	17.55	23.51	NAPA ACCESS GENERATED	194025 770503	STOCK	04/07/2022	STOCK	NGF4466194025 770503	147520	2022-04-06 10:49:57 AM	2022-04-06 10:56:52 AM	0:06:55	0:06:55	2022-04-06 11:18:21 AM	2022-04-06 11:39:43 AM	2022-04-07 2:17:18 PM	0:49:46	0:21:22	0:21:22	FILL	CITY OF TORONTO -DISCO
17	CITY OF TORONTO -DISCO	946633	4072022	NGF	500804	AIR FILTER-CORRUGATED	1	105.24	105.24	141.02	NAPA ACCESS GENERATED	194025 770503	STOCK	04/07/2022	STOCK	NGF500804194025 770503	147519	2022-04-06 10:49:38 AM	2022-04-06 10:58:21 AM	0:08:43	0:08:43	2022-04-06 11:18:21 AM	2022-04-06 11:39:47 AM	2022-04-07 2:17:17 PM	0:50:09	0:21:26	0:21:26	FILL	CITY OF TORONTO -DISCO
18	CITY OF TORONTO -DISCO	946702	4202022	6RT	41600	41600 WYPALL	1	87.35	87.35	87.35	NAPA ACCESS GENERATED	FL1702 769242	STOCK	04/20/2022	STOCK	6RT41600FL1702 769242	148389	2022-04-13 8:49:26 AM	2022-04-13 8:58:59 AM	0:09:33	0:09:33	2022-04-13 11:19:59 AM	2022-04-13 11:42:25 AM	2022-04-20 7:50:36 AM	2:52:59	0:22:26	0:22:26	FILL	CITY OF TORONTO -DISCO
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G144:G1424,G2:G41	Cell Value	<0	text	NO
G1	Cell Value	<1	text	NO

this the table im hoping to get..

TESTMay 2022- Fill Rate COT FILE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
5			Fill Rate	May 2022					2022
6				TOTAL QTY	STOCK (Marked Stock + <1h )	NON STOCK (Marked Non-Stock + >1h)	Monthly Fill Rate		Total Qty	STOCK (Marked Stock + <1h )	NON STOCK (Marked Non-Stock + >1h)	CTD
7			Disco	357	293	64	82.07%		2228	1596	632	71.63%
8			Eastern	697	530	167	76.04%		5854	3589	2265	61.31%
9			Ellesmere	1510	1276	234	84.50%		10484	7749	2735	73.91%
10			Finch	407	331	76	81.33%		3210	2168	1042	67.54%
11			Total	2971	2430	541	81.79%		21776	15102	6674	69.35%
12
13				Missed Fills- May 2022
14				TOTAL QTY (Marked STOCK)	Missed Fills (Marked STOCK but not READY <1h)	Missed Fill Opportunities
15			Disco	312	19	6.09%
16			Eastern	580	50	8.62%
17			Ellesmere	1333	57	4.28%
18			Finch	344	13	3.78%
19			Total	2569	139	5.41%
SUMMARY

Cell Formulas
Range	Formula
F7:F10	F7	=D7-E7
L7:L11,G7:G11	G7	=E7/D7
I7	I7	=336+276+283+315+306+355+357
J7	J7	=152+199+226+269+246+211+293
K7	K7	=184+77+57+46+60+144+64
I8	I8	=831+876+790+975+960+725+697
J8	J8	=403+479+475+593+618+491+530
K8	K8	=428+397+315+382+342+234+167
I9	I9	=1445+1179+1286+1485+2069+1510+1510
J9	J9	=1009+828+898+1008+1539+1191+1276
K9	K9	=436+351+388+477+530+319+234
I10	I10	=464+394+383+509+657+396+407
J10	J10	=247+247+258+346+427+312+331
K10	K10	=217+147+125+163+230+84+76
D19:E19,D11:F11,I11:K11	I11	=SUM(I7:I10)
F15:F19	F15	=E15/D15

 

[Fluff]

Duplicate to: How to automate Fill Rate?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.