NAMING RANGES AND WRITING MACROS
Phil Clark · The Bottom Line Managing Library Finances · 1990
I recently developed a spreadsheet template that would summarize the year‐to‐date expenditures and encumbrances of a library and calculate the balance left in the budget. One of the design objectives was to minimize the number of instructions for clerical workers who would be using the template. Macros, or programmed sequences of key‐strokes, had to be developed—and when using macros, it is best to do a lot of range naming in order to keep things understandable.