Modernize Excel VBA Compatibility
Publicada el 2026-07-23
Descripción de la oferta
I have several Windows-era spreadsheets whose macros no longer run cleanly on Mac. They were written in Excel 2016 for Windows the sheets hold only text and numeric fields. Here is what I need from you: • Re-write or refactor the existing VBA so it runs natively in Excel 2021 and 2024 for macOS, with no missing references or Windows-only calls. I have attached the raw data export I get from an online registration form titled Orders.xlsx. the others spreadsheets contain the macros that are run on this export and their results. I plan reorder the columns in the export file but you can take a look at these examples to see if it makes sense. Acceptance criteria – Macros execute without errors on Excel 2021 & 2024 (Mac) – Custom multi-level sort returns the same result set each run – Designated columns are hidden on command and re-shown when toggled – No deprecated Windows-only libraries remain in the project If you have tackled cross-platform Excel automation before, this should be straightforward. Let me know your timeline and any clarifications you need, and we can get started right away. Do not reply unless you have an understanding of the current coding and output spreadsheets.
Skills
Fuente original: freelancer