Excel Audit Sampling Macros Needed

I work with large sets of financieros and need to speed up my audit procedures inside Excel. I’m looking for a VBA-driven workbook (or an add-in, whichever you find cleaner) that automates two specific sampling approaches I use every week:

Random sampling • Let me pick the population range (rows or a Power Query table) and the sample size or confidence level. • Your code must perform a selección aleatoria de registros, drop them into a separate tab, and—within the same run—crear un informe de muestra que detalle método, parámetros y resultados. • Before it finishes, the macro should validar los resultados de la muestra (duplicates, gaps, correct count).

MUS (Monetary Unit Sampling) • Starting from the same financial population, the macro debe calcular los valores de muestra con la lógica MUS clásica (interval, sampling interval, high-value stratum). • Incluye una revisión dinámica de los umbrales de materialidad: si cambio el materiality cell, all calculations update. • Al final, genera un informe de auditoría con resumen de errores proyectados y conclusiones.

The workbook has to be fully unlocked, clearly commented, and compatible with Office 365 desktop. If you prefer separating logic into Power Query or using helper functions, note that in the documentation.

Minimum deliverables

1. Macro-enabled Excel file with both routines ready to run.
2. A short PDF or in-sheet notes explaining parameters, buttons, and how to extend the code.
3. Quick test using a dummy financial dataset so I can see the flow end to end.

Let me know your estimated timeline and any similar tools you’ve built so I can jump straight into vetting the solution. Preference will be given to developers from LATAM, due to contextual understanding, regulatory alignment, and ease of communication. Budget: USD 30–250 Skills: Visual Basic, Data Processing, Excel, Visual Basic for Apps, Financial Analysis, Excel VBA, Excel Macros, Office 365, Data Analysis, Data Management