Visual Basic для додатків Jobs

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 ...

I need my existing workbook to do more of the thinking for me. Right now each process is logged manually, but the column that should show who is responsible is blank. Your task is to insert the right data-analysis formulas so that, as soon as a process code or other key detail is entered, Excel automatically returns the correct “responsible” name. You may lean on lookup combinations, conditional logic, or any other native functions that keep the file fast and easy to edit; lightweight VBA is acceptable only if a purely formula-based route proves impossible. The sheet layout should remain intact—no moving columns or renaming headers. Deliverables • Working formulas (or compact VBA) that populate the “Responsibility” field for every current and future r...

I need a clean, reusable Excel workbook that lets me do two things from the same file. First, track daily attendance in a simple table that shows each employee’s name, check-in time, check-out time, and total hours worked. Second, have those attendance figures feed seamlessly into a salary-slip sheet so I can generate individual payslips at month-end without re-entering data. A formula-driven solution is my priority, but I’m open to lightweight VBA if it keeps everything one-click simple. The layout must stay fully editable, as different teams may add or hide columns later. Please deliver: • A master attendance sheet with automatic date handling and clear data-validation for time entry • Dynamic formulas (or macro) that calculate total hours per person per day and...