I have two worksheets.
The first one is a master list (table) (rows of data consisting of 7 columns-customer name, product type, required date, etc.) I have auto-filter turned on and turns the "required date's" cell color to light red and text to dark red, if the required date falls within a time frame of "today's date".
The second sheet is a table that I want to display info from the first sheet on if the cell color and text is red (as explained from sheet one).
I only want to copy and move data from the first, second, and sixth column of the rows that have the "red" formatting happening.

My goal is to have the second sheet auto cleared and auto filled every morning and auto sent via outlook email to a contacts list that i am creating.

This workbook is kept on a sharepoint server.

Please help.

I can send a copy of my workbook if necessary.

Thank you for looking.

Jake