I’m not a programmer, but I learned how to write a number of Excel macros to automate repetitive and tedious tasks.
There were quite a number that really saved a ton of time, but the best were a pair took about 3 full days work for 3 or 4 people and made it into 10 minute jobs for 2 people.
It freed up so much time every month, and the job went from miserable and error prone to being much more reliable and let us spend time improving related processes rather than trudging through piles of data to get it formatted and sent to the right people.
I’m not a programmer, but I learned how to write a number of Excel macros to automate repetitive and tedious tasks.
There were quite a number that really saved a ton of time, but the best were a pair took about 3 full days work for 3 or 4 people and made it into 10 minute jobs for 2 people.
It freed up so much time every month, and the job went from miserable and error prone to being much more reliable and let us spend time improving related processes rather than trudging through piles of data to get it formatted and sent to the right people.
You’re doing it wrong.
You write the macros, tell no one, and give three people an easy income.
If necessary, add random errors so they think you’re still doing it manually.
MFers got no class solidarity…
I get what you’re saying. I’ve made that mistake before.
We were a remote team and never even got a new manager when the old one left, and me and the supervisor are friends IRL.
Good times.
My current job is doing this, but moving workflows from SAS -> Excel to Python.