I do the same thing at my work. We have to update pricing information for 100,000s of items so I made templates for our team with xlookups and if-then statements so it takes less than one second.
I still catch people doing it manually every 6 months…
