Match Data and Update a Sheet with a certain Format

[basketball2524]

Hello Everybody, Hopefully someone can help me with this. It's the second part of a macro that was created earlier for me.


Step 1:
On sheet1 it will look for a color value in Column C and then check to see if that value already exists in Sheet2.

Step 2:
If a match is found in Sheet 2 it will then check to see if the corresponding row has a value in Column I.

Step 3:
If no value is found then it will check to see if the Date found in the same row in Column D matches the Date from Sheet1 that corresponds with the value carried over before. If they do not match then Column G in the corresponding row receives a "Yes". And if they do match then Column H in the corresponding row receives a "Yes" if Column F's Date has been reached.

Step 4:
If Column I has a value then it will check in Column D and the second available row "MIA2" to see if it is empty. If it is not empty it will proceed back to Step 2. If it is empty then the Date from Column F in Sheet1 gets carried over and the follow code get implemented to fill out the rest of the corresponding cells

Please Login or Register  to view this content.

Thanks for any help.

Test1bb.xlsx

[basketball2524]

Any Ideas?