OK, so here we go. See attached for example.

So, naturally, imagine when I perform the export it is the information, only.

I've updated my Timeline to identify by 'Phase' and 'Sub-Phase' rather than what it was previously, which was just the word 'header'.

So, we would delete the columns "Baseline Start", "Baseline Finish", and "Resource Names" (Columns E, H & J).
The Column "ID#" is non-existent when the export is performed, that is added by me.
Otherwise, how it is presented is exactly as I want it to look each week, but I want the macro to automatically color the selected cells in a row based on the information in the column titled "View Filter" (which ends up being Column L when the ID# column is added, and the others removed).

This should be much easier to work from- sorry I did not provide something sooner!

Attached Files

Example Export.xlsm (36.7 KB, 11 views)