Sumifs across multiple sheets

SUMIFS across multiple sheets


 First you have to define a SheetList range name (the range of sheet names being the sources of SUMIFS). You can input the name of the sheets in a separate sheet of your excel file. Select all the cells containing this sheet names, then go to the name box field (the upper left field where […]

Excel to pdf

VBA macro print as PDF


 A very helpful VBA macro that turns any printable excel document into a PDF file. Convert excel to pdf or save excel to pdf Sub savepdf() mo= Month(Date) d = Day(Date) y = Year(Date) h = Hour(Now) m = Minute(Now) s = Second(Now) file= y & mo & d & “-” & h & m […]

setting background color programmatically

RGB color map


 Using colors in excel and VBA is very simple. The most used function is RGB(x, y, z). Where x is the variable for red color, y is for green and z is for blue. All variables can have values from 0 to 255, where 0 is no color and 255 is the maximum level for […]

NFC – Useful technology


 Does the NFC icon appear on the upper screen of your smartphone, or are you reading the specifications of some electronic device and you do not know what is NFC and what does it mean? In few words, the abbreviation comes from Near Field Communication and is a type of RFID technology (Radio Frequency Identification). […]