Hello, I need help creating the following Macro. I have Two Sheets the first Sheet is "Test3" that has the raw data from an export. Previous macros go through it and highlight rows based on a value.(Either Yellow or Red) What I'm trying to do is update the Sheet called "Trial". The first thing it will do is on the Test3 sheet it will find search Column A to see if the cell has a color in it. If it does then it will see if that File Number in Column A matches any file number found in Column A on the Trial Sheet. If no match is found it will create a new section with the day's current date and paste the necessary information in from Test3 to Trial.

If a match is found for the file number it will take the information already on the Trial sheet and shift it to the top under the new section that was made.
After that for that file it will Check Column D and see if it matches the Date from Column F on Test3 sheet. If it does match then it will Check to see Column F on the Trial Sheets Date has passed. If the date has passed it will mark Column G as Yes.

I know this sounds confusing but if you look at the file and look at the Sheet called "What it should look like" it will make a lot more sense. Thanks for your help.

TestBook.xlsx