Visual Basic per App Jobs

I’m putting together an all-in-one meal-planning spreadsheet and need someone who knows Excel inside-out (formulas, VBA, or Power Query—whatever you think works best) to turn the concept into a polished, user-friendly workbook. Here’s what the file must handle: • A searchable recipe database that lets me tag each dish as Vegetarian/Vegan, Gluten-free, Low-carb/Keto, or Non-Veg. • Automatic shopping-list generation: I choose recipes for the week and the workbook compiles quantities of every ingredient, grouped by aisle/category. • Nutritional information calculation for each recipe and for the full plan (calories, macros, plus space for any extra metrics you suggest). • Embedded pictures and clickable web links for every recipe so I can jump stra...

I want a single, self-contained Excel workbook that can automatically generate a Vedic horoscope while carrying out both birth-chart and transit-chart calculations. After the user enters date, time, and location, the sheet should compute planetary longitudes, house cusps, and full aspect tables, then display the results in a clear Option for the user for North-Indian or South-Indian style wheel (I am open to whichever is simpler in Excel). Essential elements to include • Horoscope generation that updates instantly from a single data-entry panel. • Birth-chart and real-time transit-chart computations. • Planet positions, twelve houses, full aspect matrix, plus KP-style Sub Lord and Sub-Sub Lord output. Technical expectations The workbook may rely on VBA, Power Query, ...

Our company relies on one very large, multi-sheet Excel workbook as the master file for day-to-day operations. Over time it has grown bloated: formulas are scattered across dozens of tabs, formatting is inconsistent, and the file now freezes or takes minutes to calculate whenever we open, save, or filter data. The immediate goal is to eliminate every bottleneck. I need the entire workbook audited—specifically the formulas and overall formatting—to locate circular references, volatile functions, hidden conditional formats, broken named ranges, and anything else that drags performance down. Unused styles, excess rows/columns, and outdated links also have to go. Once the problems are identified, clean the workbook so it opens quickly, recalculates without hanging, and keeps ...

I need a single-file Excel workbook that performs core Vedic astrology calculations and produces clear, ready-to-read results. The primary focus is on two functions: accurate birth chart generation and reliable horoscope predictions. All computations must follow the Vedic system—sidereal zodiac, traditional house calculations, and the standard planetary periods (dashas). Structure & flow I have in mind • One clean input sheet where a user types birth date, time, and location (latitude, longitude, time-zone). • Behind the scenes, formulas or VBA code convert that data into planetary longitudes, house cusps, divisional charts as needed, and then render the main Rāshi chart visibly on a results sheet. • A second results section produces daily, weekly, and month...

I need a single, well-structured Excel workbook that lets me generate astrological charts based strictly on Vedic principles. The flow is simple: I type in birth details (date, time, latitude, longitude, time-zone) and, with one click, the sheet calculates planetary positions, displays an accurate Rashi chart, and produces the full Vimshottari Dasha timeline. Core functions to build • Planetary positions: longitudes for Sun through Ketu, automatically adjusted for ayanamsa. • Rashi (Lagna) chart: clear North or South Indian layout, rendered directly in cells or via a lightweight VBA userform. • Dasha calculation: full table of Mahadasha, Antardasha, and Pratyantardasha with start-end dates. I am fine if you rely on native Excel formulas where possible, but feel free ...

I have a customer database that I need moved into a clean, well-structured Excel workbook so I can dig into behavior patterns quickly. Please pull the full set of customer records, strip out any duplicates, normalise the fields and lay the data out in a single, analysis-ready sheet. I rely on pivot tables, slicers and a handful of helper columns for cohort, frequency and recency metrics, so building those directly into the file will save me time. A compact dashboard sheet with a few example charts (repeat-purchase rate, average order gap, churn flags) would be ideal, but keep everything editable so I can tweak formulas later. You’ll get secure access to the raw CSV dump and a field map. I need the finished .xlsx file, clearly labelled tabs, no external links, and formulas that ...

I need an Excel expert to help secure my spreadsheet. The goal is to protect my intellectual property by hiding formulas and logic without restricting user access. Requirements: - Users should have full edit access except to the formulas. - Need recommendations on using macros or VBA scripts for enhanced protection. Ideal Skills and Experience: - Advanced knowledge of Excel - Experience with password protection, sheet locking, and cell locking - Proficient in VBA and macros - Strong understanding of intellectual property protection in spreadsheets Please provide a solution that balances security with user accessibility.

I have an Excel workbook that stores our customer information, and over time the file has accumulated duplicate records that are not always exact copies—many differ only by slight variations in the customer name. I need the entire sheet reviewed and cleansed so every customer appears only once while all underlying details (emails, phone numbers, addresses, notes) are preserved in the surviving record. You will spot duplicates by matching similar names rather than relying on a strict cell-for-cell comparison, so techniques such as fuzzy lookup, Power Query merge rules, or a custom VBA routine are welcome as long as the logic is transparent and repeatable for future runs. Deliverables • A cleaned Excel file with one unique row per customer • A brief outline of the match...

My day-to-day inventory work still revolves around Busy and endless Excel sheets. Manual data entry eats up hours, mistakes creep in, and re-order decisions are always a step behind. I want to flip that on its head with an AI-driven workflow that quietly handles the heavy lifting while I focus on bigger decisions. Here’s what I need the new flow to do: • Capture sales and purchase data automatically, push it into Busy, and eliminate repetitive Excel typing. • Track stock levels in real time, flag low-stock items, and trigger smart re-order actions without my intervention. • Generate clear, shareable inventory reports (daily, weekly, monthly) straight from the updated data. You’re free to bring in the best mix of Python, RPA tools, Power Automate, Zapier,...

I have two Excel workbooks that both hold financial data. Your task is to bring them together into a single sheet, line-up the rows correctly, compare the “Outstanding” column from each source, and place the resulting difference in a brand-new column so it is easy for me to review. To keep everything transparent, the final file should arrive fully editable—no hidden formulas or protected cells—so I can trace or change the logic later if needed. A short note explaining any formulas, Power Query steps, or VBA you use will help me maintain the sheet in the future. Deliverables • One merged Excel workbook with the new Difference column beside the original Outstanding values • Clear, simple documentation (a few lines inside the file or a separate text sheet...

I need a set of interactive dashboards built in Microsoft Excel that will let my team monitor projects at a glance. The focus is squarely on project management, so the workbook must pull together: • Task completion status • Team performance metrics • Resource allocation These dashboards will be used day-to-day by team members rather than executives, which means the layout has to be intuitive, fast to update, and locked against accidental formula changes. I picture slicers, dynamic charts, conditional formatting, perhaps a progress-bar style visual for tasks—whatever gives an immediate sense of where we stand without asking anyone to hunt for numbers. Source data will come from the worksheets we already maintain; your job is to cleanly connect them, automate re...

Hi there! I need a seasoned VBA developer to turn financial spreadsheets into clear, ready-to-share. Will share more details only selected candidate.I look forward to streamlining our reporting workflow together. Thanks

I need assistance to fine-tune an Excel document that is heavily VBA-coded and has query connections. The goal is to improve the user interface and ensure the robustness of the code. Key Requirements: - Improve ease of navigation - Enhance code integrity - Allow end users to easily modify and change Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in optimizing complex Excel workbooks - Strong understanding of user interface design within Excel - Ability to create intuitive navigation and modify existing code for user adaptability Looking for someone with a keen eye for design and solid coding skills to make this document more user-friendly and efficient.

I need assistance to fine-tune an Excel document that is heavily VBA-coded and has query connections. The goal is to improve the user interface and ensure the robustness of the code. Key Requirements: - Improve ease of navigation - Enhance code integrity - Allow end users to easily modify and change Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in optimizing complex Excel workbooks - Strong understanding of user interface design within Excel - Ability to create intuitive navigation and modify existing code for user adaptability Looking for someone with a keen eye for design and solid coding skills to make this document more user-friendly and efficient.

I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.

I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.

Tengo una aplicación de cálculo de presupuestos desarrollada íntegramente en Microsoft Access y quiero llevarla al siguiente nivel. Necesito: • Nuevas funcionalidades – Informes claros y totalmente personalizables. – Campos matemáticos adicionales que indiquen a qué área o partida pertenecen. • Automatización de tareas repetitivas – Generación automática de reportes para reducir tiempo y errores. • Mantenimiento y calidad – Corrección de los fallos que van apareciendo durante el uso diario. – Código VBA limpio y comentado para facilitar futuras ampliaciones. Cómo trabajo Comparto todas las aclaraciones mediante breves vídeos explicativos (ejemplo: ) y ...