PE/REPE - Excel Macros/Scripts

Hi guys,

I recently started as an analyst at a German-based Real Estate Private Equity firm after completing an internship there earlier this year.

Since our junior team is quite lean (just me plus three colleagues – 2 analysts and 1 associate), I’m looking for ways to improve efficiency and speed up recurring tasks. I know macros and VBA can save a lot of time, but I’m curious what kind of scripts you’ve found most useful in your day-to-day work in REPE/PE/IB.

Would really appreciate any input or examples you can share.

Thanks,
ms