PDA

View Full Version : Conditionally put - sign



tinamishra
07-28-2019, 09:22 PM
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