I have a spread sheet that is being populated from another data base. I am taking this data in the worksheet "Managed site list test" and deleting entries from Canada, calculating 8 weeks back from today, and then highlighting them yellow. My next step is to search these highlighted fields based on their color and Column H and when I find one that meets both criteria I want to select the whole row, copy it and then paste it into the corresponding worksheets labeled "PI, Laser, OCC, DP". For example I want to copy the row from "Sheet 1" where the row is yellow and column H=PI and paste that into the worksheet titled "PI".
The issue I am having is that I can run the script with no errors but when I go to the other worksheets I don't see any data copied there.
I have attached my test data and script for review.
Mind you that this is my first forray into scripting and I'm sure the script I have written is messy by programing standards. I have now been looking at this for 2 days and I can't for the life of me figure out what I did wrong. When I take the IF THEN ELSE statements and put them into their own module with simulated data I get an error message as well but I don't see that when I run my orginal script, and I did make sure to call out my statement lines as well in the test. Any help would be greatly appreceated.