I am making a macro that will send out an email to different people depending on the value of a filter in cell C1.
I have managed to compile the macro to work depending on a cell value (cell C2) however as the cell value does not change when the filter is applied I need to select the different...