I currently have the below macro to copy data from a my sales workbook and paste the values to a closed workbook.
I'm struggling to find a macro that can check column C of the closed workbook for "VE01", if this appears then delete the line and run the transfervalues sub
This is to prevent...