Macros/Visual Basic for Applications (VBA)

For example, you could enter data in a table as illustrated below. To get an average change, you could enter a simple formula in cell E4.The formula was entered without defining the range name DayChange. Excel found the column heading and implicitly gave that data block a name. In most cases, defined names refer to absolute references. ................
................