vba code will be run from a different file file name- plot1.xlsx plot2.xlsx If column E of plot1.xlsx matches with column A of plot2.xlsx and column R of plot1.xlsx contains - (minus sign) then check the data of plot2.xlsx wheather the last cell of plot2.xlsx contains (-)minus sign or not and if not then add minus sign before the number of plot 2.xlsx all this we have to do by vba