$$Excel-Macros$$ SUM

2016-05-22 Thread Izhar
in the attachment I have two sheets i.e. JAN & FEB, in both the sheets data are same but in the FEB sheet it is more than the JAN sheet, i need a macro when I run it, the macro sum column E,F,G, in JAN with the heading TOTAL and in the same way when I run the same macro it sum the the said column o

$$Excel-Macros$$ Vlookup Matching Issue

2016-05-22 Thread Bill Q
Hi, PSA. Trying to do a simple vlookup. I cleaned up the data by trimming, but still cannot get a match. I manually entered in data in B2 in order to get a match. I never encountered anything like this before. Not certain how to fix. Anyone ? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP