Macro or Power Automate to Identify and Move "Washes" from the "Master" Sheet to the "Washes" Sheet

[Madam_Xavier]

Hi everyone,

I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes".


Problem:
Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight all the negatives, then compare the nearby rows to see if Columns A, B, C, and D are identical. Then we have to compare the negative row with the surrounding rows to see which records are being washed out.

Ex.02: Red Box
On the 13th, Indiana submitted two records (5hrs and 3hrs) totaling 8hrs. So their dispatcher created a wash by creating only one record with -8.

Ex.01: Blue Box -
On the 15th, Indi submitted 4 hours worked for jobsite 68. However, it was corrected by his dispatcher and they created a Wash by duplicating the record and creating the hours worked to be a negative value.


Goal: To efficiently move these washes from the "Master" sheet to a "Washes" sheet.

Current Solution:
Every week, we receive a text file of all the labor records that need to be imported into our system. Use Text to Column to delimit the data with the Vertical Line (|) and then we use either conditional formatting where we input ( =0>$G1) OR Filter on G to find the negatives and then highlight the column (depending on the Analyst). Which then gives us a starting point to simply eyeball it and verify the Washes' by periodically checking the Sum in the bottom right-hand corner to see if it equals zero.

Desired Solution:
Preferably, I'd love to create a Macro or use Power Automate to consistently and accurately find all the potential washes, leaving the rest of the records alone. Then remove these washes from the "Master" sheet and move them to the "Washes" sheet.


Unfortunately, I'm the most experienced on the team when it comes to Excel, but the last time I needed to go this in depth was back in 2016, when I desperately learned about VBA and how to code a solution within a week. This amazing community helped me back then in identifying why my code kept failing.

So once again, I cast the MrExcel bat-signal into the skies hoping to receive help.

Thank you,

NSL Trueup Template 20240826.xlsx
	A	B	C	D	E		G
2	Emp #	Emp Name	Job Site	Work_Date	Pay per hour		Hours_Worked
3	33010	Jones, Indiana	18521	2024-06-13	102.55		-8
4	33010	Jones, Indiana	18521	2024-06-13	74.24		5
5	33010	Jones, Indiana	18521	2024-06-13	111.35		3
6	33010	Jones, Indiana	18168	2024-06-15	102.54		-4
7	33010	Jones, Indiana	18168	2024-06-15	111.36		4
8	33010	Jones, Indiana	25331	2024-06-17	68.36		-3
9	33010	Jones, Indiana	23468	2024-06-17	68.36		-4
10	33010	Jones, Indiana	25331	2024-06-17	68.37		-1
11	33010	Jones, Indiana	25331	2024-06-17	74.24		3
12	33010	Jones, Indiana	23468	2024-06-17	74.23		4
13	33010	Jones, Indiana	25331	2024-06-17	74.24		1
14	33010	Jones, Indiana	23468	2024-06-18	68.36		-8
15	33010	Jones, Indiana	23468	2024-06-18	74.24		8
16	33010	Jones, Indiana	43309	2024-08-02	174.88		6.75
17	33010	Jones, Indiana	43472	2024-08-02	174.88		8
18	33010	Jones, Indiana	43573	2024-08-02	217.62		4
19	33010	Jones, Indiana	43472	2024-08-02	85.5		-8
20	33010	Jones, Indiana	43472	2024-08-02	170.99		8
Original

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
1:1048576	Expression	=0>$G1	text	NO