Visual Basic for Apps Jobs

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends. The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary. Deliverables: • Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place • A concise in-sheet note or README explaining the logic so I can update it later I’ll share the current workbook as soon as we start and will...

I’m launching a mobile-first job marketplace connecting farms with workers for agricultural work — everything from a weekend relief milking shift to full-time stockman roles. Think a clean, purpose-built alternative to scrolling unstructured Facebook groups: farms post real jobs with real pay, workers apply and build a track record, farms choose who to hire. I have a full working HTML/React prototype covering the core UX and flows, which I’ll share with shortlisted candidates — this removes most of the guesswork on layout and behaviour. I’m looking for someone to take that spec and build a proper, production-ready MVP. Target users: UK farmers/estate managers (posting jobs) and agricultural workers ranging from casual/weekend labourers to full-time stockmen an...

I have an automated Excel-based rostering workbook that has been running in production for a while, but a few critical pieces now need attention. The core of the job is to refine the calculation logic. Some totals are coming out wrong, a couple of edge-case rules were never coded, and overall processing speed has slipped as the file has grown. I would like the existing formulas/VBA adjusted so every shift, allowance and overtime rule reconciles accurately, a set of new business rules is added, and execution time is brought back to an instant feel. Alongside that, I need the import/export module expanded. At present it handles only a basic CSV; I want to introduce two additional formats (one XLSX template we use with payroll and a JSON summary we send to Power BI). Clean, reliable parsi...

I have an existing VBA routine in my workbook that pulls end-of-day natural-gas quotes from an online source and drops them straight into a dedicated sheet. Lately the data is coming in, but the columns arrive out of order—prices, volumes, and dates no longer line up, so charts and formulas break. The connection itself still completes and I am not seeing any run-time errors; the only problem is this misaligned-column formatting issue. I need you to trace where the shift happens, correct the parsing or write a cleaner import routine, and leave the data neatly aligned exactly as the sheet expects. You’ll have remote access to a sample workbook plus the small chunk of VBA (about 60 lines) that handles the web request and paste operation. Please return a fixed version or, if ...