Visual Basic for Apps Jobs

I have some VBA code that is intended for data manipulation, but it's currently producing incorrect data output or calculations. The data this code is working with involves mixed data types. I'm looking for a freelancer with strong VBA skills who can troubleshoot this code and fix the issues. Ideally, you should be able to: - Understand and modify existing VBA code - Diagnose and fix issues related to data output and calculations - Work with mixed data types Experience with data manipulation and troubleshooting VBA code is necessary. Please include relevant examples of your past work in your bid. Will send a copy of my code and an explanation of what I am trying to accomplish upon selection of a freelancer.

I need custom AppleScript scripts for my Mac running Sonoma 14.3.1. The scripts will be used primarily for file management tasks. Ideal Skills: - Proficient in AppleScript - Experienced in Mac OS file management - Able to create automation scripts Please provide examples of similar projects you've worked on.

I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation

I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge

I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.

I need an Excel-based master file to allocate components/parts to various work orders. The file should indicate which work orders have sufficient stock and which ones are short. Key requirements: - The master file should be in Excel - It should include automated functions using formulas (no macros required) - It should focus on the allocation of components/parts Ideal skills and experience: - Proficiency in Excel, particularly with creating and using formulas - Experience in supply chain management or inventory control - Ability to create user-friendly, organized files for tracking purposes.

I'm looking for an expert in Excel who can help me build a comprehensive spreadsheet to track my business expenses from multiple sources including bank accounts, credit cards, and receipts. Key Features: - Daily updates: The spreadsheet should be designed to accommodate daily expense tracking. - Duplicate charge detection: The system should help identify duplicate charges automatically. - Note-taking: I need to be able to record notes directly in the spreadsheet. - Categorization: All expenses need to be categorized so I can sort and see total costs for different categories over different time periods (time periods should be customizable). Ideal Skills: - Proficiency in Excel: You should be extremely comfortable with Excel and be able to create complex formulas and functions. - Att...

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizació...