I will create excel formulas vba macros and google sheets

Canada

I speak English

Excel VBA, Web Scraping and HTML Email Developer

I build Excel formulas and VBA macros, Google Sheets automations, web scrapers and responsive HTML email templates for small businesses and agencies. Send me your file, website or design and you get a...
About this Gig

Stuck on a formula, or doing the same Excel task by hand every week? I build formulas, VBA macros and Google Sheets automations that do the work for you.


What I can do:

- Fix broken formulas and #N/A, #REF, #VALUE errors

- XLOOKUP, VLOOKUP, INDEX MATCH, SUMIFS, COUNTIFS, IF, FILTER, QUERY, ARRAYFORMULA

- VBA macros: one-click buttons that format, merge, split or email reports

- Google Apps Script: auto-fill sheets, send emails, import data, scheduled triggers

- Dashboards, dropdowns, conditional formatting and charts

- Trackers for sales, inventory, payments, budgets and attendance


How it works:

1. Send your file (or a copy with sample data) and describe the result you want

2. I build and test it on your data

3. You get the working file plus short notes on how it works


Every formula and macro is unlocked and commented so you can edit it later. Not sure which package fits? Message me with a screenshot and I'll tell you before you order.

Platform:

Excel

•

Google Sheets

Development technology:

VBA

•

Google Apps Script

•

Python

Expertise:

Fixing

•

Formulas

•

Functions

•

Macros

•

Dashboard