I will build excel vba macros to automate your pivot tables and sales reports

Automate your Excel reports with VBA macros | Distribution & Retail

Are you wasting time copying and pasting your ERP exports into Excel, rebuilding the same Pivot Tables and formatting every time before sending your reports? I automate all of that for you with a custom VBA macro.

What I deliver: automatic import of your files (.xls/.xlsx/.csv), Pivot Table generation, formula application (VLOOKUP, out of stock rates, margins), full formatting (borders, colors, filters, frozen panes) and a clean .xlsx export ready to send.

My retail experience: I have delivered macros for food distribution networks in France, including multi store reports, out of stock rates weighted by zone, product and store mapping tables, and beginning and end of period inventory reconciliation.

Compatible with: Everest, VIDEOR, Sage, Cegid and any standard ERP export.

My method: You send me your files, we define the scope, I send you a video demo, you validate, I deliver.

I code dynamically: the macro adapts if your data changes.

I speak French, English and Spanish (intermediate). Video call available.