Hello Everybody, I decided to break down my previous question to see if I can get help with the first part.

First task on the macro that needs to be accomplished is on Sheet "Trial" it goes to Column A Cell 10 and shift the information down and place the days current date in that cell. It will then skip a row and setup the format for the next value.

Then on sheet "Test3" I need the macro to search Column A and see if a cell has a color in it. If a color is found it will take that value in Column A and see if it matches any values in Column A on the sheet "Trial". If no match is found then on Sheet "Trial" the macro will go to Column A Cell 12 and place the value it was trying to match. It will then go to the next cell and place the value found on Sheet "Test3" in column B. Other formats will be placed but the last thing that will be pulled from Sheet "Test3" is found in Column F that will go in Column D on Sheet "Trial". After this format is done it will skip a row and continue back to Sheet "Test3" to see if there are any more values to be found. If there are it will be placed below the previous one. Thanks anybody for their help.


TestBook.xlsx