Match, looking, insert. (two tables in respect to the date " monthly"

[Batata]

Greetings,

project1 table shows the data table that I need to match from the poject1 table based on the total monthly value.

The match was a bit complicated for my skill, and I kindly requested help.

First to look at data in the "Difference Pending" column in "Project1 Table" Tab, and if there is a value, then look at the name from the "Buy-from Vendor Name" column from the same table and match them by month "Date of receipt" with the date in "Project1" and insert the value of that month in "Pending PO" column in "Project 1" table.

If the value has anything except "*"&SUB&"*" in "Project1 Table" "No." column, then it will be inserted in the top table in "Project1", and if it has "*"&SUB&"*," then it will be inserted in the bottom table under Subcontractor with the value from "Difference Pending" column and the name from "Buy-from Vendor Name" column with an order by date newer to older.

I hope my explanation was clear.

I think its similar to the problem that i had in the first post that i did, and i would love to have your input kindly, @Sufiyan97 @Peter_SSs

Thank you

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D			G	H	I							P	Q	R													AE	AF	AG
2
3			1/1/2020	2/1/2020			5/1/2020	6/1/2020	7/1/2020							2/1/2021	3/1/2021	4/1/2021													5/1/2022	6/1/2022	7/1/2022
4	Pending PO	Total	$ -	$ -			$ -	$ 99.00	$ -							$ -	$ -	$ -													$ -	$ 2,000.00	$ -
5	Ram Tools	Services																														$ 2,000.00
6		Services
7		Services
8		Services
9		Services
10		Services
11		Services
12		Services
13		Services
14		Services
15		Services
16		Services
17		Services
18		Services
19	Enterprise Systems Corporation	Services						$ 99.00
20
21
22			1/1/2020	2/1/2020			5/1/2020	6/1/2020	7/1/2020							2/1/2021	3/1/2021	4/1/2021													5/1/2022	6/1/2022	7/1/2022
23	Subcontractor	Total	$ -	$ -			$ 5,056.76	$ -	$ -							$ -	$ 96,999.56	$ 14,366.00													$ -	$ -	$ -
24	Bernardo Inc dba as Taylor Lightning Pro	Subcontract																$ 14,366.00
25	MCA Communications INC	Subcontract															$ 96,999.56
26	Metric Engineering, Inc	Subcontract					$ 5,056.76
27
Project1

Cell Formulas
Range	Formula
D3,G3:I3,P3:R3,AE3:AG3,D22,G22:I22,P22:R22,AE22:AG22	D3	=EDATE(C3,1)
C4:D4,G4:I4,P4:R4,AE4:AG4	C4	=SUM(C5:C19)
C23:D23,G23:I23,P23:R23,AE23:AG23	C23	=SUM(C24:C26)

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D	E	F
1	No.	Date of receipt fra.	Buy-from Vendor Name	Amount	Imported Billed	Difference Pending
2	183A-DPO-03	5/11/2021	Wildcat Electric Supply	$ 1,490.00	$ 1,490.00	$ -
3	BTGWO-DPO-01	5/14/2020	OSI Optoelectronics, Inc	$ -	$ -	$ -
4	BTGWO-DPO-02	5/14/2020	Express Systems & Peripherals	$ 4,315.55	$ 4,315.55	$ -
5	BTGWO-DPO-03	5/14/2020	Communications Supply Corporation	$ 3,205.15	$ 3,205.15	$ -
6	BTGWO-DPO-04	6/6/2020	Wildcat Electric Supply	$ 2,320.90	$ 2,320.90	$ -
7	BTGWO-DPO-05	6/6/2020	Innovative IDM, LLC	$ 3,681.40	$ 3,681.40	$ -
8	BTGWO-DPO-06	6/6/2020	Iteris	$ 7,000.00	$ 7,000.00	$ -
9	BTGWO-DPO-07	6/6/2020	Dehn Inc.	$ 1,278.24	$ 1,278.24	$ -
10	BTGWO-DPO-08	6/6/2020	Teleste Corporation	$ 6,897.20	$ 6,897.20	$ -
11	BTGWO-DPO-09	6/6/2020	Enterprise Systems Corporation	$ 3,482.80	$ 3,383.80	$ 99.00
12	BTGWO-DPO-10	6/7/2020	Communications Supply Corporation	$ 2,944.70	$ 2,653.70	$ 291.00
13	BTGWO-DPO-11	6/13/2020	Wesco Distribution, Inc.	$ 1,243.85	$ 1,243.85	$ -
14	BTGWO-DPO-12	6/22/2020	Anixter	$ 332.53	$ 332.53	$ -
15	BTGWO-DPO-13	6/26/2020	Quadbridge, Inc.	$ 2,528.88	$ 2,528.88	$ -
16	BTGWO-DPO-14	6/27/2020	Daktronics, Inc.	$ 80,200.00	$ 80,200.00	$ -
17	BTGWO-DPO-15	8/17/2020	Quadbridge, Inc.	$ 7,332.00	$ 3,000.00	$ 4,332.00
18	BTGWO-DPO-16	8/19/2020	Quadbridge, Inc.	$ 1,663.21	$ 1,663.21	$ -
19	BTGWO-DPO-17	8/21/2020	Govcomm, Inc.	$ 4,450.00	$ 4,450.00	$ -
20	BTGWO-DPO-18	9/15/2020	Anixter	$ 1,085.65	$ 1,085.65	$ -
21	BTGWO-DPO-19	9/16/2020	Paradigm Traffic Systems Inc	$ 2,547.00	$ 2,547.00	$ -
22	BTGWO-DPO-20	10/26/2020	Dehn Inc.	$ 271.20	$ 271.20	$ -
23	BTGWO-DPO-21	10/26/2020	Wesco Distribution, Inc.	$ 557.23	$ 557.23	$ -
24	BTGWO-DPO-22	10/26/2020	Wildcat Electric Supply	$ 1,331.37	$ 1,331.37	$ -
25	BTGWO-DPO-23	11/19/2020	Innodisk Usa Corp	$ 1,865.00	$ 1,865.00	$ -
26	BTGWO-DPO-25	3/25/2021	Twincrest Inc	$ 1,000.00	$ 1,000.00	$ -
27	BTGWO-DPO-26	4/1/2021	Wildcat Electric Supply	$ 904.42	$ 904.42	$ -
28	BTGWO-DPO-27	4/6/2021	Teleste Corporation	$ 6,556.40	$ 6,556.40	$ -
29	BTGWO-DPO-28	4/7/2021	Wildcat Electric Supply	$ 2,086.50	$ 2,086.50	$ -
30	BTGWO-DPO-29	4/14/2021	Innodisk Usa Corp	$ 389.75	$ 389.75	$ -
31	BTGWO-DPO-30	4/20/2021	Paradigm Traffic Systems Inc	$ 7,190.00	$ 7,190.00	$ -
32	BTGWO-DPO-31	4/20/2021	Mouser Electronics, Inc.	$ 3,609.95	$ 3,609.95	$ -
33	BTGWO-DPO-32	4/20/2021	Elliot Electric Supply, Inc.	$ 6,275.00	$ 6,275.00	$ -
34	BTGWO-DPO-33	4/20/2021	Wildcat Electric Supply	$ 2,035.00	$ 2,035.00	$ -
35	BTGWO-DPO-34	4/21/2021	Buyers Barricades Houston LLC	$ -	$ -	$ -
36	BTGWO-DPO-35	4/21/2021	Stripes & Stops Company Inc	$ -	$ -	$ -
37	BTGWO-DPO-36	4/29/2021	Sunbelt Rentals Inc	$ 9,500.00	$ -	$ 9,500.00
38	BTGWO-DPO-37	5/10/2021	Wildcat Electric Supply	$ 9,995.00	$ -	$ 9,995.00
39	BTGWO-DPO-38	5/10/2021	Fastenal Company	$ 5,000.00	$ -	$ 5,000.00
40	BTGWO-DPO-39	5/14/2021	GRAINGER	$ 1,000.00	$ -	$ 1,000.00
41	BTGWO-DPO-40	5/14/2021	Ground Penetrating Radar Systems, LLC	$ 600.00	$ 600.00	$ -
42	BTGWO-DPO-42	6/11/2021	Daktronics, Inc.	$ 6,545.00	$ 6,545.00	$ -
43	BTGWO-DPO-43	6/17/2021	HD Supply Construction Supply, LTD	$ 7,000.00	$ -	$ 7,000.00
44	BTGWO-DPO-44	6/21/2021	Wildcat Electric Supply	$ 8,000.00	$ 8,000.00	$ -
45	BTGWO-DPO-45	7/19/2021	Southern Manufacturing	$ 4,695.00	$ 4,695.00	$ -
46	BTGWO-DPO-46	9/23/2021	Texan Transportation, Inc.	$ 1,200.00	$ 1,200.00	$ -
47	BTGWO-DPO-47	6/21/2022	Southern Manufacturing	$ 1,571.40	$ -	$ 1,571.40
48	BTGWO-DPO-476	6/21/2022		$ -	$ -	$ -
49	BTGWO-DPO-48	6/22/2022	Ram Tools	$ 2,000.00	$ -	$ 2,000.00
50	BTGWO-PO-01	4/30/2020	Transcore ITS, LLC	$ 22,400.00	$ 22,400.00	$ -
51	BTGWO-PO-02	5/13/2020	Twincrest Inc	$ 18,450.00	$ 18,450.00	$ -
52	BTGWO-PO-03	5/13/2020	Sick, Inc	$ 12,615.60	$ 12,615.60	$ -
53	BTGWO-PO-04	6/6/2020	Paradigm Traffic Systems Inc	$ 15,844.00	$ 15,844.00	$ -
54	BTGWO-PO-05	6/13/2020	Anixter	$ 37,658.03	$ 37,658.03	$ -
55	BTGWO-PO-06	6/17/2020	Ampro Adlink Technology	$ 17,852.00	$ 17,852.00	$ -
56	BTGWO-PO-07	6/17/2020	Southern Manufacturing	$ 13,645.00	$ 13,645.00	$ -
57	BTGWO-PO-08	6/18/2020	Communications Supply Corporation	$ 20,220.00	$ 20,220.00	$ -
58	BTGWO-PO-09	6/18/2020	Daktronics, Inc.	$ 42,140.00	$ 42,140.00	$ -
59	BTGWO-PO-10	6/18/2020	Jai Inc., USA	$ 42,780.00	$ 42,780.00	$ -
60	BTGWO-PO-11	6/20/2020	Quadbridge, Inc.	$ 16,284.85	$ 16,284.85	$ -
61	BTGWO-PO-12	8/6/2020	Anixter	$ 46,185.00	$ 46,185.00	$ -
62	BTGWO-PO-13	1/14/2021	Communications Supply Corporation	$ 37,200.00	$ 37,200.00	$ -
63	BTGWO-PO-14	1/20/2021	Govcomm, Inc.	$ 11,125.00	$ 11,125.00	$ -
64	BTGWO-PO-15	1/20/2021	Southern Manufacturing	$ 24,065.00	$ 24,065.00	$ -
65	BTGWO-PO-16	2/8/2021	WE Manufacturing & Controls, Inc.	$ 14,150.00	$ 14,150.00	$ -
66	BTGWO-PO-17	3/26/2021	DURA STRESS INC	$ 8,880.00	$ 8,880.00	$ -
67	BTGWO-PO-18	4/7/2021	Communications Supply Corporation	$ 17,680.05	$ 17,680.05	$ -
68	BTGWO-PO-19	4/16/2021	Communications Supply Corporation	$ 15,873.90	$ 15,873.90	$ -
69	BTGWO-PO-20	10/5/2021	Teleste LLC	$ 10,149.00	$ 10,149.00	$ -
70	BTGWO-SUB-01	5/19/2020	Metric Engineering, Inc	$ 101,135.27	$ 96,078.51	$ 5,056.76
71	BTGWO-SUB-02	3/11/2021	MCA Communications INC	$ 98,890.79	$ 1,891.23	$ 96,999.56
72	BTGWO-SUB-03	4/30/2021	Bernardo Inc dba as Taylor Lightning Pro	$ 14,366.00	$ -	$ 14,366.00
73	DPO000199	5/14/2020	Wildcat Electric Supply	$ 2,850.00	$ 2,850.00	$ -
74	IH35-37-DPO-01	6/3/2021	Wildcat Electric Supply	$ 5,280.00	$ -	$ 5,280.00
75	PRUEBA JUAN	7/23/2020	Lockman Security, Inc.	$ 11,000.00	$ -	$ 11,000.00
Project1 Table

Cell Formulas
Range	Formula
F2:F75	F2	=D2-E2

 

[Sufiyan97]

Try

I just changed dates to catch values in formula

Project 1

Book13
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2
3			01/01/2020	02/01/2020	03/01/2020	04/01/2020	05/01/2020	06/01/2020	07/01/2020	08/01/2020	09/01/2020	10/01/2020	11/01/2020	12/01/2020	01/01/2021	02/01/2021	03/01/2021	04/01/2021
4	Pending PO	Total	0	0	0	0	0	2099	0	0	0	0	0	0	0	0	0	0
5	Ram Tools	Services	0	0	0	0	0	2000	0	0	0	0	0	0	0	0	0	0
6	Enterprise Systems Corporation	Services	0	0	0	0	0	99	0	0	0	0	0	0	0	0	0	0
7
8
9			01/01/2020	02/01/2020	03/01/2020	04/01/2020	05/01/2020	06/01/2020	07/01/2020	08/01/2020	09/01/2020	10/01/2020	11/01/2020	12/01/2020	01/01/2021	02/01/2021	03/01/2021	04/01/2021
10	Subcontractor	Total	0	0	96999.56	0	5056.76	0	0	0	0	0	0	0	0	0	0	14366
11	Bernardo Inc dba as Taylor Lightning Pro	Subcontract	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14366
12	MCA Communications INC	Subcontract	0	0	96999.56	0	0	0	0	0	0	0	0	0	0	0	0	0
13	Metric Engineering, Inc	Subcontract	0	0	0	0	5056.76	0	0	0	0	0	0	0	0	0	0	0
14
Project1

Cell Formulas
Range	Formula
D3:R3,D9:R9	D3	=EDATE(C3,1)
C4:R4	C4	=SUM(C5:C6)
C5:R6	C5	=SUMIFS('Project1 Table'!$F:$F,'Project1 Table'!$C:$C,$A5,'Project1 Table'!$B:$B,">="&EOMONTH(C$3,-1)+1,'Project1 Table'!$B:$B,"<="&EOMONTH(C$3,0),'Project1 Table'!$A:$A,"<>"&"*SUB*")
C10:R10	C10	=SUM(C11:C13)
C11:R13	C11	=SUMIFS('Project1 Table'!$F:$F,'Project1 Table'!$C:$C,$A11,'Project1 Table'!$B:$B,">="&EOMONTH(C$9,-1)+1,'Project1 Table'!$B:$B,"<="&EOMONTH(C$9,0),'Project1 Table'!$A:$A,"*SUB*")

Named Ranges
Name	Refers To	Cells
'Project1 Table'!_FilterDatabase	='Project1 Table'!$A$1:$F$75	C11:R13, C5:R6

Project1 Table

Book13
	A	B	C	D	E	F	G
1	No.	Date of receipt fra.	Buy-from Vendor Name	Amount	Imported Billed	Difference Pending
2	183A-DPO-03	5/11/2020	Wildcat Electric Supply	1490	1490	0
3	BTGWO-DPO-01	5/14/2020	OSI Optoelectronics, Inc	0	0	0
4	BTGWO-DPO-02	5/14/2020	Express Systems & Peripherals	4315.55	4315.55	0
5	BTGWO-DPO-03	5/14/2020	Communications Supply Corporation	3205.15	3205.15	0
6	BTGWO-DPO-04	6/6/2020	Wildcat Electric Supply	2320.9	2320.9	0
7	BTGWO-DPO-05	6/6/2020	Innovative IDM, LLC	3681.4	3681.4	0
8	BTGWO-DPO-06	6/6/2020	Iteris	7000	7000	0
9	BTGWO-DPO-07	6/6/2020	Dehn Inc.	1278.24	1278.24	0
10	BTGWO-DPO-08	6/6/2020	Teleste Corporation	6897.2	6897.2	0
11	BTGWO-DPO-09	6/6/2020	Enterprise Systems Corporation	3482.8	3383.8	99
12	BTGWO-DPO-10	6/7/2020	Communications Supply Corporation	2944.7	2653.7	291
13	BTGWO-DPO-11	6/13/2020	Wesco Distribution, Inc.	1243.85	1243.85	0
14	BTGWO-DPO-12	6/22/2020	Anixter	332.53	332.53	0
15	BTGWO-DPO-13	6/26/2020	Quadbridge, Inc.	2528.88	2528.88	0
16	BTGWO-DPO-14	6/27/2020	Daktronics, Inc.	80200	80200	0
17	BTGWO-DPO-15	8/17/2020	Quadbridge, Inc.	7332	3000	4332
18	BTGWO-DPO-16	8/19/2020	Quadbridge, Inc.	1663.21	1663.21	0
19	BTGWO-DPO-17	8/21/2020	Govcomm, Inc.	4450	4450	0
20	BTGWO-DPO-18	9/15/2020	Anixter	1085.65	1085.65	0
21	BTGWO-DPO-19	9/16/2020	Paradigm Traffic Systems Inc	2547	2547	0
22	BTGWO-DPO-20	10/26/2020	Dehn Inc.	271.2	271.2	0
23	BTGWO-DPO-21	10/26/2020	Wesco Distribution, Inc.	557.23	557.23	0
24	BTGWO-DPO-22	10/26/2020	Wildcat Electric Supply	1331.37	1331.37	0
25	BTGWO-DPO-23	11/19/2020	Innodisk Usa Corp	1865	1865	0
26	BTGWO-DPO-25	3/25/2020	Twincrest Inc	1000	1000	0
27	BTGWO-DPO-26	4/1/2020	Wildcat Electric Supply	904.42	904.42	0
28	BTGWO-DPO-27	4/6/2020	Teleste Corporation	6556.4	6556.4	0
29	BTGWO-DPO-28	4/7/2020	Wildcat Electric Supply	2086.5	2086.5	0
30	BTGWO-DPO-29	4/14/2020	Innodisk Usa Corp	389.75	389.75	0
31	BTGWO-DPO-30	4/20/2020	Paradigm Traffic Systems Inc	7190	7190	0
32	BTGWO-DPO-31	4/20/2020	Mouser Electronics, Inc.	3609.95	3609.95	0
33	BTGWO-DPO-32	4/20/2020	Elliot Electric Supply, Inc.	6275	6275	0
34	BTGWO-DPO-33	4/20/2020	Wildcat Electric Supply	2035	2035	0
35	BTGWO-DPO-34	4/21/2020	Buyers Barricades Houston LLC	0	0	0
36	BTGWO-DPO-35	4/21/2020	Stripes & Stops Company Inc	0	0	0
37	BTGWO-DPO-36	4/29/2020	Sunbelt Rentals Inc	9500	0	9500
38	BTGWO-DPO-37	5/10/2020	Wildcat Electric Supply	9995	0	9995
39	BTGWO-DPO-38	5/10/2020	Fastenal Company	5000	0	5000
40	BTGWO-DPO-39	5/14/2020	GRAINGER	1000	0	1000
41	BTGWO-DPO-40	5/14/2020	Ground Penetrating Radar Systems, LLC	600	600	0
42	BTGWO-DPO-42	6/11/2020	Daktronics, Inc.	6545	6545	0
43	BTGWO-DPO-43	6/17/2020	HD Supply Construction Supply, LTD	7000	0	7000
44	BTGWO-DPO-44	6/21/2020	Wildcat Electric Supply	8000	8000	0
45	BTGWO-DPO-45	7/19/2020	Southern Manufacturing	4695	4695	0
46	BTGWO-DPO-46	9/23/2020	Texan Transportation, Inc.	1200	1200	0
47	BTGWO-DPO-47	6/21/2020	Southern Manufacturing	1571.4	0	1571.4
48	BTGWO-DPO-476	6/21/2020		0	0	0
49	BTGWO-DPO-48	6/22/2020	Ram Tools	2000	0	2000
50	BTGWO-PO-01	4/30/2020	Transcore ITS, LLC	22400	22400	0
51	BTGWO-PO-02	5/13/2020	Twincrest Inc	18450	18450	0
52	BTGWO-PO-03	5/13/2020	Sick, Inc	12615.6	12615.6	0
53	BTGWO-PO-04	6/6/2020	Paradigm Traffic Systems Inc	15844	15844	0
54	BTGWO-PO-05	6/13/2020	Anixter	37658.03	37658.03	0
55	BTGWO-PO-06	6/17/2020	Ampro Adlink Technology	17852	17852	0
56	BTGWO-PO-07	6/17/2020	Southern Manufacturing	13645	13645	0
57	BTGWO-PO-08	6/18/2020	Communications Supply Corporation	20220	20220	0
58	BTGWO-PO-09	6/18/2020	Daktronics, Inc.	42140	42140	0
59	BTGWO-PO-10	6/18/2020	Jai Inc., USA	42780	42780	0
60	BTGWO-PO-11	6/20/2020	Quadbridge, Inc.	16284.85	16284.85	0
61	BTGWO-PO-12	8/6/2020	Anixter	46185	46185	0
62	BTGWO-PO-13	1/14/2020	Communications Supply Corporation	37200	37200	0
63	BTGWO-PO-14	1/20/2020	Govcomm, Inc.	11125	11125	0
64	BTGWO-PO-15	1/20/2020	Southern Manufacturing	24065	24065	0
65	BTGWO-PO-16	2/8/2020	WE Manufacturing & Controls, Inc.	14150	14150	0
66	BTGWO-PO-17	3/26/2020	DURA STRESS INC	8880	8880	0
67	BTGWO-PO-18	4/7/2020	Communications Supply Corporation	17680.05	17680.05	0
68	BTGWO-PO-19	4/16/2020	Communications Supply Corporation	15873.9	15873.9	0
69	BTGWO-PO-20	10/5/2020	Teleste LLC	10149	10149	0
70	BTGWO-SUB-01	5/19/2020	Metric Engineering, Inc	101135.27	96078.51	5056.76
71	BTGWO-SUB-02	3/11/2020	MCA Communications INC	98890.79	1891.23	96999.56
72	BTGWO-SUB-03	4/30/2021	Bernardo Inc dba as Taylor Lightning Pro	14366	0	14366
73	DPO000199	5/14/2020	Wildcat Electric Supply	2850	2850	0
74	IH35-37-DPO-01	6/3/2020	Wildcat Electric Supply	5280	0	5280
75	PRUEBA JUAN	7/23/2020	Lockman Security, Inc.	11000	0	11000
76
Project1 Table

Cell Formulas
Range	Formula
F2:F75	F2	=D2-E2

 

[Batata]

@Sufiyan97, Thank you for your response.

Not quite; I think my explanation was a bit confusing. let me try this
So for the sheet2 table, if there is a new date added and this data has value in the "Difference Pending" Clomn sheet1 table will dynamically pull that value with the Vendor name matching the date in a new row.
If this data has a SUB in the No. so the data will be pulled under Subcontractor in sheet1 and the same if it does not contain "SUB" it will be under "Pending PO" in sheet 1

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D	E	F
1	No.	Date of receipt fra.	Buy-from Vendor Name	Amount	Imported Billed	Difference Pending
2	BTGWO-SUB-03	5/30/2022	Taylor Lightning Pro	$ 14,366.00	$ 14,366.00	$ -
3	DPO000199	6/14/2022	Electric Supply	$ 2,850.00	$ 2,850.00	$ -
4
SHEET2

Cell Formulas
Range	Formula
F2:F3	F2	=D2-E2

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D	E
1
2
3			4/1/2022	5/1/2022	6/1/2022
4	Pending PO	Total	$ -	$ -	$ -
5		Services
6
7
8			4/1/2022	5/1/2022	6/1/2022
9	Subcontractor	Total	$ -	$ -	$ -
10		Subcontract
11
12
13
SHEET1

Cell Formulas
Range	Formula
D3:E3,D8:E8	D3	=EDATE(C3,1)
C4:E4,C9:E9	C4	=SUM(C5:C5)

New data uploaded (Power inde. supply and this vendor has a Difference Pending of $2,250) where the (Electric Supply) Vendor has no Difference Pending that why it's not pulled to the other table.
And when ( Taylor Lightning Pro) has a value now in "Difference Pending" its automatically pulled to the "Subcontractor" the bottom table in sheet 1 because it has the "*"&"SUB"&"*" in "NO." column.

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D	E	F
1	No.	Date of receipt fra.	Buy-from Vendor Name	Amount	Imported Billed	Difference Pending
2	BTGWO-SUB-03	5/30/2022	Taylor Lightning Pro	$ 14,366.00	$ -	$ 14,366.00
3	DPO000199	6/14/2022	Wildcat Electric Supply	$ 2,850.00	$ 2,850.00	$ -
4	PO000150	6/25/2022	Power inde. supply	$ 3,500.00	$ 1,250.00	$ 2,250.00
SHEET2

Cell Formulas
Range	Formula
F2:F4	F2	=D2-E2

New Microsoft Excel Worksheet (2).xlsx
	A	B	C	D	E
1
2
3			4/1/2022	5/1/2022	6/1/2022
4	Pending PO	Total	$ -	$ -	$ 2,250.00
5	Power inde. supply	Services			$ 2,250.00
6
7
8			4/1/2022	5/1/2022	6/1/2022
9	Subcontractor	Total	$ -	$ 14,366.00	$ -
10	Taylor Lightning Pro	Subcontract		$ 14,366.00
11
12
SHEET1

Cell Formulas
Range	Formula
D3:E3,D8:E8	D3	=EDATE(C3,1)
C4:E4,C9:E9	C4	=SUM(C5:C5)

 

[Batata]

@Peter_SSs is it okay to have your input here, Kindly?