Which spreadsheet feature or macro has streamlined your data-entry tasks?

Data Entry Tools of the Trade
1

PivotTables, conditional formatting, and custom macros are often credited with saving hours each week—what’s in your toolkit?