Visual Basic Jobs

Título del Proyecto: Asistencia Avanzada en Excel - Experto en Fórmulas, Automatización y Macros (Contratación por Hora) Descripción del Proyecto: Busco un experto en Excel para apoyo ocasional en tareas avanzadas de análisis de datos, automatización y programación en Excel. Este proyecto está orientado a la contratación de una persona que pueda proporcionar asistencia cada vez que se necesite, especialmente en: Creación y optimización de fórmulas avanzadas en Excel. Automatización de procesos mediante macros y VBA. Diseño de hojas de cálculo personalizadas y funcionales. Análisis de datos y generación de reportes complejos según requerimientos espec&iacut...

I'm struggling with my VB6 project that needs to connect to Oracle XE on my Windows 10 system. Despite installing what I thought was necessary, I keep getting 'components missing' messages. What I need: - Assistance in troubleshooting the connection string. - Identify and install any missing components. - Guidance on proper setup and configuration. Ideal candidates for this project should have: - Proficiency in VB6 and Oracle database. - Experience with Windows 10. - Knowledge in troubleshooting and configuring database connections in VB6. - Able to explain technical details in simple terms.

I'm looking for a solution to streamline our quotation process, reducing errors and enhancing consistency. This will be a template that our sales team can use, built on any software but ideally on something user-friendly like Excel or Word. Key Requirements: - The template should allow our salesperson to select from a list of 10-15 different fields (Brands, Models, Additional specifications) pertinent to a quotation. - The selected information should generate a clean, pre-determined description that can be easily copied into our job management system. - It must be customizable: I need to be able to add more brands, models etc. as we grow. - The selection process should be via dropdown lists to simplify the process and enhance accuracy. Ideal Skills: - Proficiency in Excel/Word or ...

I need an R script converted into Excel using only standard Excel formulas. The goal is to replicate the functionality of the R script in Excel. Ideal skills and experience: - Proficiency in R and Excel - Experience in converting R scripts to Excel - Familiarity with Excel's standard formulas

I need a skilled web developer to convert a complex Excel workbook I currently use for project estimation into a React-based web application. This workbook includes intricate calculations and formulas, multiple macros, and is designed to generate Word proposals. Key Tasks: - Build a web-based application using React.js - Implement complex calculations and formulas - Incorporate multiple macros - Create a feature for Word document generation to produce project proposals - Design a user-friendly interface that simplifies the usage of the original Excel workbook - Implement user authentication and authorization for secure access. - Integrate a database to store project data and track changes over time. - Add error handling mechanisms for calculations and data inputs. - Optimize the performan...

I am seeking a Google Sheets expert to help me create a comprehensive tracking system for athlete programming. This system will track performance metrics and assist in planning nutrition. Key Responsibilities: - Design a Google Sheet to track various performance metrics, including workout progress, skill development, and injury recovery. - Implement a detailed nutrition planning system, specifically creating meal plans with macros. Ideal Skills and Experience: - Expert-level proficiency in Google Sheets - Experience with athletic performance tracking systems - Knowledge of nutrition planning and macro counting - Ability to create easy-to-navigate and visually clear spreadsheets. I am a strength and conditioning coach who specializes in training powerlifters (squat, bench and deadlift)....

I am looking for an experienced freelancer to develop a comprehensive Materials Quantity and Price Tracking tool on Microsoft Access. The tool will be used by 15 team members to input price data for materials on a quarterly basis. Key features required for the project include: Key Features: - Multiple User Access: The tool must support price entries by 15 users, all within the first month of each quarter. - Price Entry in Euros with Currency Conversion: Prices will be entered in Euros, with automatic conversion to USD based on a dynamic foreign exchange rate that updates in real-time. - Dynamic FX Rate: The tool should allow for FX rates to be updated whenever necessary, to ensure accurate conversions. - Smart Entry Form with Validation: A key feature is a smart entry form that enforces s...

I'm seeking an Excel VBA expert to automate my data entry tasks. This project primarily involves compiling data from multiple files into a single spreadsheet. The data source is strictly Excel, and the destination is also Excel. A TEST TASK MAY BE GIVEN TO YOU. Only bid if you have work in excel VBA. Key Requirements: - Proficient in Excel and VBA - Experienced in automating data entry tasks - Able to compile data from different files - Familiar with Excel to Excel data manipulation Ideal Skills and Experience: - Strong understanding of Excel’s functionalities - Previous experience with similar data compilation tasks - Excellent attention to detail - Ability to meet deadlines

Experience with TM Master or Planned Maintenance Systems: Requirement: Familiarity with TM Master or similar planned maintenance software. Task: Extract and review maintenance data, including outstanding, overdue, and upcoming jobs. Data Extraction & Organization: Task: Identify and extract key maintenance items and statuses from the software, including overdue and completed jobs. Requirement: Organize extracted data in Excel sheets for detailed review and reporting. KPI Calculation & Tracking: Task: Calculate maintenance KPIs, such as overdue jobs percentage, completed jobs, postponed tasks, etc. Requirement: Build a clear and structured Excel report to track performance metrics over time. Analysis of Maintenance Trends: Task: Analyze patterns in postponed and overdue jobs, wi...

I'm in need of a professional who can help me manage and maintain my customer data on a regular basis. Key Responsibilities: - Data Maintenance: Regularly updating and ensuring the accuracy of customer information. Ideal Skills: - Data Management: Proven experience in handling customer data. - Attention to Detail: Able to spot and correct errors in data entries. - Data Maintenance: Skilled in keeping data up-to-date and relevant. Please note that the frequency of data updates has not yet been determined. The data updates should be performed weekly.

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

I'm seeking an Excel expert to help me set up a comprehensive spreadsheet and dashboard to track my monthly income and expenses. Requirements: - The spreadsheet should capture various income sources, expense categories, as well as savings and investments. - A dashboard needs to be created using bar charts and pie charts to visualize this data. -This project will involve a one-time setup and categorization of all income and expenses financial year to date. -If the initial setup is successful, there will be ongoing monthly work to update the data Ideal Skills: - Proficiency in Microsoft Excel is a must. - Prior experience in creating financial spreadsheets and dashboards. - Strong data visualization skills with Excel.

I need help with data manipulation in Excel. My data needs some cleaning, particularly in terms of standardizing formats. This involves moving data from long columns into correct rows, cutting and pasting, and moving cells from rows to columns. There are around 650 records that need to be organized, with 4 fields in each record. A lot of cut-and-paste - UNLESS you are good at excel programming, because the fields already have delimiter texts, and common words that could be automated.

I'm looking to streamline the filing process for my 30 Florida LLCs. I need a professional who can connect my Excel spreadsheet, which contains LLC names and addresses, to the online annual update form. Key Requirements: - Proficient in Excel and familiar with online filing processes - Ability to create a seamless connection between the spreadsheet and the filing website - No data validation or error checking needed, just straightforward automation This project is perfect for someone with experience in both Excel automation and business filing processes.

I'm seeking a skilled Excel expert to develop a spreadsheet for tracking various construction equipment, including excavators, cranes, bulldozers, pile drivers, UTVs, trucks, and more. This spreadsheet should serve a general contractor's full list of equipment. The spreadsheet needs to perform the following functions: - Cost estimation - An integrated forward-looking and rear-facing forecast tab The ideal freelancer for this project should have: - Extensive experience in creating complex Excel spreadsheets - A solid understanding of construction equipment and their costs - Skills in predictive modeling and data analysis - Ability to create user-friendly and accessible spreadsheets The goal is to have a comprehensive, easy-to-navigate spreadsheet that can facilitate cost estima...

I need assistance with cleaning and processing data in my Excel sheets. The specific tasks involve: - Formatting data - Implement data validation to ensure values are within expected ranges. - Remove duplicates to ensure only unique entries are present. - Format dates consistently across all entries. Ideal skills and experience for the job: - Proficient in Excel - Experience in data cleaning and processing - Detail-oriented to ensure data is correctly formatted. The data consists of financial information. The dataset is large and has multiple columns. Please use the corporate style guide for all formatting. Also, please provide a graphical summary of the cleaned data. The project should be completed within 1-2 weeks. Please log errors in a separate sheet. Include a trend analysis of the...

I am looking for a skilled Excel/VBA developer to build a tool that replicates the core functionality of an old program I use. This tool should primarily focus on data analysis and calculations, specifically comparison analysis. Key Requirements: - Proficient in Excel and VBA - Experience in building automated tools for data analysis - Ability to understand and replicate the functions of existing software The tool should facilitate: - Data analysis and calculations - Comparison of different sets of data Please note, we will not be comparing different datasets from the same period or data from different departments. Instead, the primary focus will be on comparing historical data vs. current data. I am open to suggestions on how to best implement this tool, and I am looking for a freel...

I am in urgent need of an experienced coder specialized in macro programming for personal use. - Ideal Skills: Strong expertise in macro coding, preferably with experience in software such as Excel or other relevant platforms. - Experience: A proven track record of successfully completed macro coding projects. - Availability: The project has an immediate deadline, so prompt responses are appreciated. Please provide examples of your previous work in your application, as well as references from past clients.

I am in urgent need of an experienced coder specialized in macro programming for personal use. - Ideal Skills: Strong expertise in macro coding, preferably with experience in software such as Excel or other relevant platforms. - Experience: A proven track record of successfully completed macro coding projects. - Availability: The project has an immediate deadline, so prompt responses are appreciated. Please provide examples of your previous work in your application, as well as references from past clients.

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Applications (VBA).

I'm looking for an Excel expert to develop a custom intraday scanner for the Indian stock market. Key requirements: - The scanner should track specific indicators: Moving Averages, Volume, and Pivot camarilla r4 s4 level. - It should provide real-time alerts through desktop notifications. Ideal skills include advanced Excel proficiency, experience with stock market indicators, and expertise in alert system integration.

I'm seeking a skilled Excel expert to create a comprehensive tracker for monitoring breakdowns and analyzing performance. The tracker will specifically be used for: - Evaluating downtime duration - Keeping a record of the frequency of breakdowns - Assessing the mean time to repair - Logging stop and start date times - Noting any instances of below 95% availability of specific assets and turbines - Identifying faults and reasons for downtime - Documenting actions taken by site technicians - Creating visual charts to show performance trends over time. The ideal candidate for this project should have substantial experience in Excel, particularly with creating tracking and analysis tools. They should also have a strong understanding of performance metrics in a maintenance context. A bac...

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Applications (VBA).

I need a Microsoft Excel based attendance spreadsheet system. This project involves creating an Excel spreadsheet for attendance with a simplified data entry via an external linked form. The system should automatically generate attendance reports in Excel format. Ideal Skills: - Proficient in Microsoft Excel - Experience in creating linked external forms - Knowledge of Excel's data analysis and reporting capabilities Requirements: - Design a user-friendly external form for data entry - Implement a system for automatic report generation - Ensure all reports are in Excel format Please ensure the system is intuitive and easy to use. The data complexity for the system should be basic. The external data entry form should be implemented using Microsoft Forms.

I'm looking for an Excel expert to help me create a project plan that I can use to manage projects with multiple periods at once. Key Features: - Import project names from an existing Excel workbook, filtering for those with an "active" status. - Define multiple periods for each project, represented as multiple columns for start and end dates. - Assign employees to project periods, with a system to flag if an employee is assigned to the same date more than once, or if they're on vacation. - Include the ability to assign subcontractors to project periods. The user interface should follow the standard Excel layout, making it easy to navigate and use. The project plan should track the following details for each employee assigned to a project: Employee name. Ideal fre...

I'm seeking a data analyst proficient in Python, SQL, and Visual Basic to assist with analyzing logistics data. The primary focus will be on supply chain optimization and transportation analysis. Key Responsibilities: - Analyze logistics data to identify trends and insights. - Use Python and SQL to perform data manipulation and analysis. - Apply Visual Basic for data visualization and presentation of findings. - Develop and maintain dashboards and reports to visualize key performance indicators. - Automate data extraction processes to streamline workflows and ensure timely data availability. - Collaborate with operations, procurement, and other teams to understand their data needs and provide analytical support. - Conduct statistical analysis to support decision-making and strategy ...

I'm in need of an Excel template designed to handle traffic flow data, specifically tracking various types of vehicles. I require a skilled coder who can create a VBA/Excel macro to automate the creation of this template based on my specifications. Key Requirements: - Crafting a macro/VB code to create the Excel template - Working with traffic flow data pertaining to different vehicle types - Implementing functionality for data summarization - Presenting summarized data in tables Ideal Skills & Experience: - Proficient in Excel and VBA programming - Previous experience with data-heavy Excel templates - Understanding of traffic flow data is a plus - Excellent attention to detail and ability to follow specific requirements

I'm in need of a skilled programmer to convert a program written in VB6 to VB.NET. The program is primarily a user interface application, and I would like to make minor adjustments to the existing interface during the conversion. Ideal Skills: - Proficiency in VB6 and VB.NET - Experience with UI design and adjustments - Understanding of user interface applications Key Tasks: - Convert the VB6 program to VB.NET - Implement minor user interface changes - Ensure smooth functionality of the converted program

Dispongo de un listado de Excel, el cual contiene unos datos, ordenados y comentados, y necesitaría que se creara una macro a partir de esa lista y que genere un codigo QR catalogado por cada producto. Quizás se tendría que estructurar el listado Excel.

I've developed a costing and budgeting spreadsheet for my company, but I need some assistance with certain formulas and techniques to enhance its functionality. Most of the work is already done; it's mainly about connecting the pieces properly. Key Areas of Assistance: - IF Statements & Nested Functions: I need help with implementing and troubleshooting these formulas. - Linking Data Between Sheets: There's a need for proper connections across various sheets in the workbook. - User-Friendly Input Forms: Ultimately, I want to make my sheet more accessible and easier to use for my team. - I need help with setting up conditional formatting rules to highlight key data points automatically. The ideal freelancer for this job should have a strong proficiency in Excel, particu...

I'm seeking an Excel VBA expert to automate my data entry tasks. This project primarily involves compiling data from multiple files into a single spreadsheet. The data source is strictly Excel, and the destination is also Excel. A TEST TASK MAY BE GIVEN TO YOU. Only bid if you have work in excel VBA. Key Requirements: - Proficient in Excel and VBA - Experienced in automating data entry tasks - Able to compile data from different files - Familiar with Excel to Excel data manipulation Ideal Skills and Experience: - Strong understanding of Excel’s functionalities - Previous experience with similar data compilation tasks - Excellent attention to detail - Ability to meet deadlines

I'm in need of a diligent professional to assist with data cleaning and validation. The data in question is a mix of text and numbers, so attention to detail and accuracy is paramount. Ideal Skills and Experience: - Proven experience in data cleaning and validation - Proficient in handling mixed data (text and numbers) - Exceptional attention to detail - Strong manual typing skills - Previous experience in data entry

Bullet Point: Seeking a skilled VB Scripting expert to automate repetitive tasks within CorelDRAW. Full Description: CorelDRAW Automation Specialist We are seeking a highly skilled VB Scripting expert to automate repetitive tasks within our CorelDRAW workflow. The ideal candidate will have a strong understanding of CorelDRAW's object model and the ability to write efficient and robust VB Scripts. Key Responsibilities: Analyze current manual processes within CorelDRAW to identify automation opportunities. Develop and implement VB Scripts to automate tasks such as: Creating and modifying objects Applying formatting and effects Exporting files in various formats Interacting with other applications (e.g., Excel, Word) Test and debug scripts to ensure accuracy and reliability. Documen...

I need a skilled Excel expert to create a comprehensive dashboard tracking key operational metrics. The dashboard will primarily deal with operational data and should monitor: - Inventory levels - Production output - Purchase Spend The visualizations required on the dashboard are primarily graphs and charts. Ideal candidates for this project should have extensive experience working with Excel, particularly in creating dashboards and leveraging data visualization techniques. Experience with operational data and metrics is a plus.

I'm looking for a Google Sheets macro that I can trigger manually to help with data cleaning and formatting tasks. Specifically, the macro should be able to: - Remove duplicates - Standardize text An ideal candidate for this project would be someone proficient in Google Sheets and familiar with creating macros, especially for data cleaning tasks. Experience with text standardization techniques is a plus.

Buenos dias, tengo una macro que esta a un 80% de su funcionalidad, necesito terminarlo. es una macro que compara varias listas de precios para buscar coincidencias de productos y determinar el mas economico.

I'm looking for an Excel expert who can create a detailed report based on my specified input criteria: strategy, date, P/L, day, and margin. The report should have two sheets, with Sheet 1 containing detailed results and metrics, and Sheet 2 containing combined metrics. The report should also trigger a 'drawdown' alert. Specific metrics to be tracked: - Drawdown - Margin - Average P/L per day - Number of strategies executed - Overall profit - Max profit - Max loss - Win%, Loss% - Avg profit on win days - Avg loss on loss days - Return to MDD ratio - Expectancy ratio - Max win streak - Max loss streak - A month-wise breakup list with Time frame (day/month/year) - Bar chart: profit/loss - A list of all values added from input sheet. I will require separate login access for t...

I'm looking for an Excel expert who can help me optimize a spreadsheet for easier navigation. The left pane should display the letters A to Z vertically and remain visible at all times. When a letter is clicked, the spreadsheet should navigate to names starting with that letter.

I'm in need of an Excel expert who can set up a sheet for my sales data. The sheet should be equipped to handle currency changes with USD, EUR, and CAD, and have customer-specific discounting rules. Key Requirements: - Expert-level proficiency in Excel - Experience working with sales data - Knowledge of currency conversion - Ability to implement customer-specific discounting rules The Excel sheet should automatically adjust to currency changes and apply the correct discounts based on individual customers. If you have experience with this type of project, I look forward to your bid. The sheet should fully automate currency conversion and discount application without manual intervention. The currency conversion rates will be updated automatically through an API. The freelancer can c...

I need a Windows-compatible program that can execute a DOS .bat file, read values from .txt files after its execution finishes, and insert them into a MariaDB SQL table Has to be able to be "scheduled" to auto-executed each 12 hours. Could be a resident, a Windows Service, or via Windows Task Manager Ideal Skills: - Proficiency in programming for Windows - Experience with SQL, specifically MariaDB - Familiarity with DOS .bat files - Ability to read and process .txt files for config (IP of the DB, user, pass, table, fields, etc) - Ability to read and process .txt files (xml style) 4 variables will be readen from the .txt files 8 fields will be updated at the DB (4 for the variables, 4 time-stamps) The successful freelancer will be able to efficiently connect these components ...

I'm seeking a developer/vendor to create software that automates my Excel sheet for appraisal increments. The software needs to be fully integrated with Keka via a direct API connection. Key requirements: - Automate calculations, data validation and report generation in Excel - Input handling for employee performance scores, salary details, and promotion history - Seamless, direct API integration with Keka Ideal candidates should have: - Proven experience in software development for Excel automation - Familiarity with Keka or similar HRIS - Strong skills in data handling and validation - Expertise in creating software for report generation

I'm looking for a professional with strong Excel skills to assist with data migration. The project involves: - Migrating customer data from an Axapta (Microsoft Dynamics) spreadsheet to a SAP B1 spreadsheet. - Ensuring the data is accurately mapped and transferred without loss or error. Sample spreadsheets are attached. Ideal freelancers for this project should have extensive experience with Excel, particularly with data mapping and migration tasks. Prior experience with customer data would be advantageous. Attention to detail and ability to ensure data integrity during the migration process is crucial.

I need an Excel expert to develop a macro for my current cashflow model. This macro should automatically adjust rent on a fixed schedule, specifically, annually. Key Requirements: - Expertise in Excel and Macro development - Experience with cashflow models - Ability to deliver a macro that adjusts rent automatically on a fixed schedule The ideal freelancer for this project should be able to understand and work with complex Excel functions and deliver a comprehensive solution that meets my needs. If they complete this task successfully will also get you to review our model for any ways to improve all macros

I'm looking for an Excel specialist to create an interactive spreadsheet landing page for data entry and visualization of sales performance. Key responsibilities: - Design an Excel landing page primarily for data entry - Create a live graph within the spreadsheet to visualize sales performance - Ensure the landing page is user-friendly and intuitive for data entry I have 21 worksheets and want a landing / tracking page so I am able to see live a total of how far through are - see screen shot - each line has a status of either N/A , complete and pending - i want a live pie graph to see live snapshot of data - i would also like a quick table on the landing page showing each worksheet saying how many of each completed, pending, n/a Ideal skills and experience: - Advanced Excel skill...

I'm looking for an Excel expert to help me create some pivot tables, pie charts and perform comparative analysis on a set of data. I would prefer to do this over a Zoom or Teams meeting. Ideal Skills: - Proficiency in Excel, particularly in creating pivot tables - Experience generating pie charts - Strong background in conducting comparative data analysis - Good communication skills for a clear online collaboration - Ability to explain complex Excel functions in a simple manner

I'm seeking a skilled Access developer to create a small project for me. The project should include: - One main form with 6 fields for data entry - Two additional forms for a couple of entry data - One main table and probably 2 smaller tables - Several reports, specifically summary reports to be generated monthly The data will primarily be numeric (80%), with some date (10%) and text (10%) entries. The data will be split by years. One of the reports should be able to export to XML. Ideal skills and experience for this job include: - Proficient in Microsoft Access - Experience in creating Access forms and databases - Ability to design and implement summary reports - Competent in XML data exportation I look forward to your proposals.

I need a freelancer to merge two Excel files according to specific instructions. The data in these files is a mix of numerical and text data. The merging process involves combining rows based on a common column. Ideal candidates for this project should: - Have extensive experience with Excel - Be proficient in handling mixed data - Have a keen eye for detail to ensure accurate data merging.

I am looking for a Power BI expert to integrate an Excel template with a Power BI dashboard. The primary purpose of this dashboard is for internal reporting. Key Responsibilities: - Integrating an Excel template with Power BI - Setting up the dashboard for tracking specific KPIs The dashboard will be used to track various KPIs. Therefore, experience with KPI tracking in Power BI is a plus. Ideal Skills: - High Proficiency in Project Management Power BI Dashboard - Experience with Excel - Ability to create user-friendly dashboards Note: The integration of other data sources, aside from Excel, has not been decided yet. We will provide the Dashboard Template and the Excel Template to be used.

I'm looking for an expert who can help me find the correct formula to calculate certain columns based on specific criteria. - Data Type: The project involves working with a combination of financial data, inventory data, and customer data. The goal is to generate a report that identifies certain criteria between products and customer files. - Criteria: The analysis will focus on counting columns based on specific criteria, particularly sales performance, customer demographics, and product categories. - Counting Criteria: The columns will be counted based on a date range. Ideal candidates for this project should have extensive experience with Excel, particularly in data analysis and formula creation. They should be able to assist me in finding the correct formula to calculate certai...

I'm looking for a professional with strong Excel skills to assist with data migration. The project involves: - Migrating customer data from an Axapta (Microsoft Dynamics) spreadsheet to a SAP B1 spreadsheet. - Ensuring the data is accurately mapped and transferred without loss or error. Sample spreadsheets are attached. Ideal freelancers for this project should have extensive experience with Excel, particularly with data mapping and migration tasks. Prior experience with customer data would be advantageous. Attention to detail and ability to ensure data integrity during the migration process is crucial.