[crawftv]

This just means your boss needs a spreadsheet model guy. "Bosses" would rather die than enter a formula in spreadsheet.

[dmd]

This may have been true in 1985, but it is definitely not true today. "Bosses" love making massively complex spreadsheets.

[skeeter2020]

Many of them love consuming and faffing about with complex spreadsheets but I just watched my CTO cut & paste cells with menu items and the mouse, in a round-about A->C, B->A, C->B way. And the font is comic sans, and everything is sorted by color. Any of the more sophisticated tools or a macro is way beyond this one.