Visual Basic for Apps Jobs

Project Title: Excel Automatization Description: We are looking for a skilled Excel expert to automate specific tasks in Excel. The ideal candidate will have experience in data entry, formulas and calculations, as well as data analysis and reporting. Specific tasks to be automated: - Data entry tasks need to be streamlined and automated to improve efficiency. - Formulas and calculations need to be automated to ensure accuracy and save time. - Data analysis and reporting tasks need to be automated to generate regular reports with minimal manual effort. Formulas: - We need recommendations for specific formulas to be implemented in the automation process. The candidate should have expertise in recommending and implementing formulas based on the project requirements. Automation frequency:...

Project Description: QuickBooks Desktop Price Checker Requirements: - Develop a price checker tool for QuickBooks Desktop that will be used by walk in customer to scan the barcode of the product and show the price and details of the product. - Device will be either running Android 11 or Windows 7 or Windows 10 - Should connect with Quickbooks Inventory. - The tool should be able to handle checking prices for more than 100 items - A detailed report of the price changes is not required Ideal Skills and Experience: - Strong proficiency in QuickBooks Desktop and its API - Experience in developing price checker tools or similar automation tools - Knowledge of data processing and analysis - Ability to work with large datasets efficiently - Attention to detail and accuracy in retrieving and upd...

I am looking for an Excel expert with experience in Visual Basic to help me with creating automatic data in Excel. Specific tasks that I need assistance with include: - Creating macros - Automating tasks I have specific requirements for the Visual Basic programming and I would like the expert to work with my existing Excel files. Ideal skills and experience for this job include: - Advanced knowledge of Excel - Proficiency in Visual Basic programming - Experience with creating macros and automating tasks in Excel - Ability to work with existing Excel files

I need help with an Excel VBA project that involves retrieving Historical data from Interactive Brokers via DDE. I currently have an existing code that needs to be modified, and I need it to be done within a week. The data I need to retrieve is Historical data only. Experience with both Excel VBA and DDE is a must. If you think you can help, please let me know. Thanks! More details summary below. The attached sheet is working and pulls historical OHLC stock trading historical data into Excel via VBA/DDE from Interactive Brokers' TWS desktop trading platform. The excel file is a cut down version of Interactive brokers example DDE excel sheet. The sheet currently uses a manual button click, which cycles through a list of stock codes on the Historical Data tab, and downloads the data ...

I am seeking a professional to develop an advanced Excel sheet with VBA (if needed) for the design of concrete bridges. The sheet should follow any AASHTO standard, as specified by the client. Skills and experience required for this project include: - Structural Engineering (is a must ! ) - Proficiency in Excel VBA - In-depth knowledge of AASHTO standards for concrete bridge design - Experience in creating complex formulas in Excel - Familiarity with the design principles and calculations involved in concrete bridge design The excel sheet should have numerous complex formulas to handle the advanced level of complexity required by the client. The developed sheet should not only accurately perform the necessary calculations but also provide a user-friendly interface. No training or guide...

I am looking for a freelancer who can create VBA Macro scripts for automating repetitive tasks in Excel and Outlook. The specific tasks that I want the scripts to perform include filtering and sorting data. I already have the data sets on which the scripts will be tested. I am expecting the freelancer to have intermediate level expertise in VBA Macro. Need to automate repetitive tasks. Skills and experience required for this project: - Proficiency in VBA Macro scripting - Experience in automating repetitive tasks in Excel and Outlook - Knowledge of filtering and sorting data in Excel - Intermediate level expertise in VBA Macro

We are seeking an experienced VBA Macro expert to correct and update an Excel sheet. In addition, another sheet needs to be created for analyzing stocks using z-score, alpha, and sharpe ratio. The successful candidate will possess the following skills: - Proficiency in VBA macros for Excel - Strong knowledge of Excel formulas and functions - Analytical skills to calculate z-score, alpha, co-integration, co-relation and sharpe ratio - Attention to detail to ensure accurate data analysis

Hey, I have a budget template that I need help with. It has multiple sheets and they're all linked together. So I need an excel VBA expert /data analyst to help me with this one thing and tell me how I can do it. When I add a row in a sheet lets say sheet 1, I want to add a new row to be added in a different sheet with a different formula and multiple other rows with different formulas in another 3rd sheet.

I am looking for a freelancer who is experienced in visual basic scripting. The purpose of the project is to develop a user interface for my business. I have a specific design that needs to be implemented, and it is classified as an intermediate level of complexity. The freelancer should have experience in this type of project, and be able to follow through to completion. If you're interested in working on this project, please let me know. Thanks!

Project Title: Amazon Seller Partner REST API integration for Orders and Tracking Description: I am looking for a freelancer who can integrate the Amazon Seller Partner REST API for Orders and Tracking. The project requirements are as follows: Integration with : The integration should be specifically with the marketplace. Specific Functionalities: I require specific functionalities for order management rather than full order management capabilities. Preferred programming language: The project should be implemented using VBA. Ideal Skills and Experience: - Strong experience in integrating with the Amazon Seller Partner REST API - Proficiency in VBA programming language - Familiarity with marketplace and its order management system Note: Previous experience with Amazon Seller Partner...

I am looking for a freelancer who can upgrade and enhance the existing Interactive Broker API for Excel Sheet with Order Conditioning to submit bracket order trades. The upgrade should include additional order conditioning functions for bracket orders as (PriceCondition,ExecutionCondition and TimeCondition). I am aiming to achieve this upgrade and improvement within a month or so at most. Word document attached contains full details of what is required with target solution. This requires a few additional macro's to be written to the existing file only...no major code re-work required.

I am looking for an experienced macro coder to automate data analysis tasks for our existing business using MS Excel. The ideal candidate should have expertise in MS Excel and macro coding. The main tasks for this project include: - Developing a macro to automate data analysis processes - Implementing the macro in MS Excel - Ensuring the macro effectively analyzes and processes data - Providing documentation and instructions for using the macro efficiently Skills and Experience Required: - Proficiency in MS Excel and macro coding - Strong understanding of data analysis techniques - Experience in developing macros for business purposes - Attention to detail and ability to accurately analyze data If you have the necessary skills and experience, please submit your proposal.

As a project owner currently dealing with a data recordings spreadsheet requiring reformatting to generate a Power BI Pareto, I need help from a skilled programmer to write code/VBA to produce the desired outcome. I have selected VBA as my preferred programming language for this project and, as I'm under a certain time constraint, I need it done within a month. I also have both a sample of the existing spreadsheet and the desired final format, so the programmer can get straight away to work on the task. This project is of major importance for me, and I'm looking forward to working with an experienced programmer who will help me get the desired result.

I am looking for an experienced macro coder to automate data analysis tasks for our existing business using MS Excel. The ideal candidate should have expertise in MS Excel and macro coding. The main tasks for this project include: - Developing a macro to automate data analysis processes - Implementing the macro in MS Excel - Ensuring the macro effectively analyzes and processes data - Providing documentation and instructions for using the macro efficiently Skills and Experience Required: - Proficiency in MS Excel and macro coding - Strong understanding of data analysis techniques - Experience in developing macros for business purposes - Attention to detail and ability to accurately analyze data If you have the necessary skills and experience, please submit your proposal.

I have data…sometimes 100’s, sometimes 1,000’s of “rows” – data is typically from Indeed.com. Of this data, I need help with a solution that allows me to EXTRACT entire ROWS… Then I need to DELETE entire ROWS from remaining records/lines All from the Source Data, and put into another SHEET in the same WORKBOOK. I would need to do 2X…2 steps involved, after I assemble all the data into first SHEET of Excel Workbook File. First, Job Title (extract from large sheet/records, put into new sheet/records) filtered by “title” keywords Second, Employer, filtering “Employer” names – and DELETING their entire ROW/RECORD from the data AGAIN: I will have 100’s or 1,000’s of rows/records of Job Postings/L...

I am currently looking for a skilled freelancer to assist me with a project involving Excel automation. The specific tasks include data entry, formula calculations, and report generation. Additionally, the freelancer should be able to audit SMS as per guidelines and identify wrong characters in texts. I am flexible with the timeline but will provide access to existing Excel files so that the freelancer can understand the current process better. Knowledge of VBA code is desired but not necessary. If you are interested in this project, please do not hesitate to reach out. Thank you.

I'm looking for an Excel expert with proficiency in VBA or macro to help me with data analysis and reporting. I already have the data ready and what I need is a report in Excel document format. This project requires skills such as macro and VBA writing, automation of repetitive tasks, data analysis and reporting. The successful contractor should demonstrate the ability to successfully analyze large datasets and provide information/insights into the data. Additionally, they should be able to generate easy-to-read reports that can be shared with stakeholders. The ideal candidate would have extensive experience in data analysis and reporting and have the abilities to solve complex problems. If you are an Excel expert with experience creating macros, automating repetitive tasks, and produ...

I am looking for a freelancer to automate my costing sheet in Excel. Requirements: - Experience with Excel and knowledge of advanced Excel functions - Ability to automate calculations and data input in the sheet - Familiarity with creating macros and VBA coding in Excel - Understanding of costing and financial calculations - Ability to work with moderate complexity of the current costing sheet - Attention to detail and accuracy in automating the sheet - To lock certain Cell (customizable upon Manager’s approval) Please note that I am not sure at this time if the automated sheet needs to be compatible with any other programs.

I am in need of a freelancer who can assist me with an Excel project. The specific help I require includes preparing a data file from a data dump. Deadline: I need this project completed right now. The complexity of the data is simple. Skills and Experience: - Proficiency in Excel - Experience with data analysis and visualization - Knowledge of formulas and functions - Ability to automate tasks using macros

I am looking for an experienced Excel macro coder to automate the generation of daily reports from sales data. Tasks to be automated: - Creating reports based on the provided sales data Ideal skills and experience: - Proficient in Excel macros and VBA programming - Strong understanding of data analysis and report generation - Attention to detail to ensure accurate and reliable reports - Ability to work with large datasets and optimize performance - Familiarity with sales data and key metrics in order to present meaningful insights The reports will need to be generated on a daily basis, so the coder should be able to set up a system that automatically retrieves the sales data and generates the reports without manual intervention. If you have the necessary skills and experience, please...