Update entry lines

[muhleebbin]

Can someone help create a macro that would update existing entries on a secondary sheet (sheet 4) that holds data? In this test case, column F is a status field that holds the values of 'Pending, Proposed and Approved'. Ideally I'd like for this macro to at least update this column but possibly any of the columns G-BE (in case there are updates to approved amounts). Another sheet displays the data properly and can recall the existing entries via other macros so I'd like this new macro to be able to update an existing entry from the display sheet (sheet 1 cell D7:F7 contains the 'Pending, Proposed and Approved' value).

Below is a sample of the data

NTE Tracking v3.xlsm
	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	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE
1			COR-PCO Number	Change Order	RFI/Bulletin/ROM	Status	MU 001	MU 002	MU 003	MU 004	MU 005	MU 006	MU 007	MU 008	MU 009	MU 010	MU 011	MU 012	MU 013	MU 014	MU 015	MU 016	MU 017	SL 001	SL 002	SL 003	SL 004	SL 005	SL 006	SL 007	SL 008	SL 009	SL 010	SL 011	SL 012	SL 013	SL 014	SL 015	SL 016	SL 017	S 001	S 002	S 003	S 004	S 005	S 006	S 007	S 008	S 009	S 010	S 011	S 012	S 013	S 014	S 015	S 016	S 017
2	09/17/2020 08:08:43	Test	Test 1	Test CO 1	Test RFI 1	Pending	10	0	0	40	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20	0	50	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30	60	0	0	0	0	0	0	0	0	0	0	0	0	0
3	09/17/2020 08:09:35	Test	Test 2	Test CO 2	Test RFI 2	Proposed	100	0	0	400	0	0	0	0	0	0	0	0	0	0	0	0	0	0	200	0	500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	300	600	0	0	0	0	0	0	0	0	0	0	0	0	0
4	09/17/2020 08:10:07	Test	Test 3	Test CO 3	Test RFI 3	Approved	1000	0	0	4000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2000	0	5000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3000	6000	0	0	0	0	0	0	0	0	0	0	0	0	0
5	09/18/2020 07:38:00	Barrett Park	Test 4	Test CO 4	Test RFI 4	Pending	10000	0	0	40000	100000	0	0	0	0	0	0	0	0	0	0	0	0	0	20000	0	50000	100000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30000	60000	100000	0	0	0	0	0	0	0	0	0	0	0	0
6	09/18/2020 07:42:08	Barrett Park	Test 5	Test CO 5	Test RFI 5	Proposed	100	600	700	1200	0	0	0	0	0	0	0	0	0	0	0	0	0	200	500	800	1100	0	0	0	0	0	0	0	0	0	0	0	0	0	300	400	900	1000	0	0	0	0	0	0	0	0	0	0	0	0	0
7	09/18/2020 09:00:16	Barrett Park	Test 6	Test CO 6	Test RFI 6	Pending	0	0	0	20000	37500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1500	0	0	0	0	0	0	0	0	0	0	0	10200	15000	0	0	1380	0	0	0	0	0	0	0	0	0	0	0
Data