In the attached workbook I have A/L in column C and when the macro fires if A/L is in column B the it copies it over.
The problem I am having is that there is also numbers in column B, I don't want the numbers to be removed as this code is currently doing, how can I get it to only copy to the cells that have A/L and leave the other cells with numbers alone.
Reply With Quote