Visual Basic Jobs

I am looking for an experienced and reliable Excel professional to create a comprehensive Excel sheet for my corporate use. The sheet must include data entry and tracking capabilities as well as calculations and formulas. Visual charts and graphs should also be integrated into the sheet. I have all of the necessary data for the project already, which will need to be incorporated into the sheet. The data will need to be updated on a daily basis. The successful freelancer for this project should have a proven track record of previous work with Excel sheets and should be able to deliver a high-quality and professional sheet in a timely manner.

Looking for an Excel wizz for a quick side by side one page comparison Excel sheet of the data in the "TCO Summary" tab on each spreadsheet. Need someone creative and who knows Excel well to design a page that will show the data as a summary in a clean manner. I will need x2 summary pages, one with the optional and the other without the optional. I am looking for a freelancer to create a side by side comparison Excel document for my project. The specific items or categories that I would like to compare are services. Although I don't have a specific format in mind for the comparison, I do have some ideas that I would like to incorporate. The data that needs to be compared is simple with few variables. Ideal skills and experience for this job include: - Advanced Excel sk...

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

I need a image viewer for TUFF files.

Project Description: I am looking for a freelancer who can create an Excel spreadsheet with automation capabilities. The specific tasks that I want the spreadsheet to automate include data entry, calculations/formulas, and data analysis. Skills and Experience Required: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in creating automated spreadsheets - Strong analytical skills to effectively analyze and interpret data Template or Example: Unfortunately, I do not have a template or example of the desired spreadsheet layout. The freelancer will need to create the layout based on the requirements discussed. Deadline: There is no specific deadline for the completion of this project.

I need someone to extract the text data from a PDF file and convert it into an Excel spreadsheet. I'm unfamiliar with the organization of the data in the PDF so the data may be structured or unstructured. I don't have any specific formatting requirements - just basic standard formatting would be fine.

To write Word macro that can insert hundreds of pictures in a provided template box automatically. The picture should be resized into given size and one page will include 2 picture. The sequence of the picture should be in order. For example, DSC90001, DSC90002, etc etc. Current macro used and the template will be provided when project bid accepted.

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 am looking for an Excel specialist who can assist me with intermediate data analysis tasks. Specific tasks I need help with include: - Performing data analysis using Excel - Applying formulas and functions to manipulate and analyze data - Visualizing data through charts and graphs I have all the necessary data for analysis, so no data gathering is required. The data analysis required is at an intermediate level, so the ideal candidate should have: - Proficiency in Excel and experience with data analysis - Strong knowledge of formulas and functions in Excel - The ability to create compelling visualizations of data - delivery in 2 days If you have the skills and experience needed for this project, please submit your proposal.

I'm looking for a Visual Basic tutor who is highly experienced in Database Access. I'm especially interested in someone who has strong experience and knowledge of working with Microsoft Access and SQL Server. I'm looking for someone who can help me for less than 10 hours, teaching me the basics needed to be able to work successfully with the two technologies and create effective databases and access databases appropriately. This is a project-based tutor job, so I'm looking for someone who can get up-to-speed quickly and help me finish my project with success.

The excel template should have the option to list all the resources across multiple projects, edit/manage their allocations, and calculate the forcasted monthly costs (burnrate) for each project. Each resource (team member) would have: Employee ID Employee Name Role Project allocated (could be more than 1) Allocation % (for each allocated project) Allocation Start Date (for each allocated project) Allocation End Date [Conservative estimate] (for each allocated project) Allocation End Date [Conservative estimate] Confirmed? (Y/N) Allocation End Date [Realistic estimate] (for each allocated project) Daily Rate (Salary for each working day) There should a calendar view for the list of resources to visually view/edit the allocation at a week level detail. Color differentiated for each projec...

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 need dynamic hyperlinks expert who will work on my excel sheet

I am looking for an advanced Excel expert who can provide training for a duration of 1 week. The training is specifically for an individual. The ideal candidate should have expertise in the following skills and topics: - Advanced Formulas and Functions - Data Analysis and Pivot Tables - Automation and Macros The training should cover these topics comprehensively and provide hands-on practical exercises. The expert should have excellent communication skills to effectively convey complex concepts and techniques. Additionally, the expert should be able to tailor the training to the specific needs and level of proficiency of the individual.

I need text fields in this form to be in a fillable PDF form that can be used multiple times by multiple users - with its data automated to enter into excel

I am looking for a freelancer to bring my invention to life! I have a completed design ready to go, and I have all the necessary materials on-hand. The only thing missing are exact specifications to create the invention to my exact vision. With the right partner, I believe my invention will be the game-changer I'm looking for! Do you have the skills to help make this happen? If so, I look forward to hearing from you.

I am in need of a customized payroll and salary slip Excel template that fits my specific needs. Additional features required for the template are overtime and bonus calculations. There is no specific format or layout in mind for the salary slip, so the designer can design it as they see fit. Ideal skills and experience for this job include: - Proficiency in Excel - Knowledge of payroll calculations - Experience in designing customized templates

On excel to Creating dynamic hyperlinks

I am looking for a freelancer to help me create a reusable and fillable Excel scoring form for the purpose of evaluating employees. The form should incorporate calculations and formulas for accurate scoring. Skills and Experience Required: - Proficiency in Excel and VBA programming - Experience in creating fillable forms and incorporating calculations and formulas - Understanding of data validation and error checking - Ability to suggest user-friendly layout designs The freelancer should be able to work closely with me to understand the specific requirements and provide suggestions for the layout of the scoring form.

I need expert on dynamic hyperlinks my all excel

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

Hey Guys, I am looking for a skilled developer to create a software that can accurately "read" changing numbers on a screen and extract them in real-time onto an Excel spreadsheet. It should be able to Read Numbers from Different Websites. For example: The Price of A Stock on Yahoo Finance. Everytime the Number Changes (And that could be 100 Times in One Minute), the Software should put this Number in a excel spreadsheet, for each Change a new Row. A Simple List is fine, the devlopment of the Excel Spreadsheet is my Task. Operating System: Preferrably Mac, if you are Sure you can do it on Windows but can't do it on Mac, its also Okay, but be aware that i will favor Developers who can do it on Mac. Data Extraction Frequency: Real-time (Skills and Experience: - Proficiency...

We want to provide our employees with a monthly Performance Metric report card. The report should be visually appealing and a sample is included. The data for the report will be provided in one or more Excel spreadsheets. If there are multiple sheets, we will have an employee ID on each sheet to enable merging. The end result should be in PDF format with one PDF per employee. We also need a simple way to distribute the PDF's to each employee. Alternatively, we may send batches of the PDF's to each manager. For example, if we have 20 managers, they will receive a PDF for each of the employees they manage. The sample report card is a first draft and we will most likely update this format as we add new metrics. The sample Excel sheet included is accurate but will eventually ...

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

I have a PDF file that contains tables and charts, which I need to convert into Excel data. The file is quite large, with more than 50 pages. I have specific formatting requirements for the Excel data and will provide the necessary guidelines. Skills and experience required for this project: - Experience in converting PDF files to Excel data - Proficiency in handling tables and charts in Excel - Attention to detail to ensure accurate data conversion - Ability to follow formatting guidelines provided by the client

I need someone to extract the text data from a PDF file and convert it into an Excel spreadsheet. I'm unfamiliar with the organization of the data in the PDF so the data may be structured or unstructured. I don't have any specific formatting requirements - just basic standard formatting would be fine.

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'm operating Microsoft Excel for Mac, version 16.77.1, Office Home & Student 2021 I'm looking for an interactive annual calendar to predict and track my pay. I work a rotating day and night shift schedule with different pay component. Base pay, Shift differential, Shift turn over, overtime, 3 different holiday pay types. each days pay can consist of one or more of these components. these pay rates change annually on February 1. I'm open to the format but i envision a calendar with the months placed vertically and each months dates placed horizontal below each month. Below the dates for each month a horizontal line that auto fills with my schedule with the ability to add and edit to calculate the projected pay for each period. A column to the right of the calenda...

I am looking for a VB Script expert to automate a specific task. I have a clear idea of what needs to be done and I am seeking someone with intermediate level skills to complete this project. Requirements: - Proficiency in VB Scripting - Experience in automating tasks - Strong problem-solving skills - Attention to detail Responsibilities: - Understand the specific task that needs to be automated - Develop a VB Script to automate the task - Test and troubleshoot the script for any errors or issues - Ensure the script is efficient and performs well If you have the skills and experience in VB Scripting and are able to work on an intermediate level project, please submit your proposal.

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!

Hello, I am looking for a freelancer to help copy or design a record keeping/filing software with some basic accounting capabilities for me. This software must provide me with basic data entry and storage capabilities, as well as basic accounting features. multiple users should be able to log in on line with their own log in IDs and be able to upload their PDF files to specific tabs so the manager can access and review approve or reject the PDF files. The deliverable should be a fully functioning software with the features requested. It can either be an existing software that has been customized to meet requirements, or a completely new software designed from scratch. In any case, it needs to provide me with an easy and efficient way to keep crucial records and to analyze and report th...

Each month we forecast sales, production and inventory using an established excel sheet. I would like to have this developed so that it draws the base data from our inventory management system (API??), allowing manual adjustments on sales forecasts and presents the production and inventory requirements in a format that is easy to engage with.

an update to a program I use originated recently. my perpetual license expired. I can continue using the program, but it no longer allows me to add more users. i want to add more users to my program. (spanish Mx) can you do it? add more users?

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 have a PDF file that contains tables and charts, which I need to convert into Excel data. The file is quite large, with more than 50 pages. I have specific formatting requirements for the Excel data and will provide the necessary guidelines. Skills and experience required for this project: - Experience in converting PDF files to Excel data - Proficiency in handling tables and charts in Excel - Attention to detail to ensure accurate data conversion - Ability to follow formatting guidelines provided by the client

I'm operating Microsoft Excel for Mac, version 16.77.1, Office Home & Student 2021 I'm looking for an interactive annual calendar to predict and track my pay. I work a rotating day and night shift schedule with different pay component. Base pay, Shift differential, Shift turn over, overtime, 3 different holiday pay types. each days pay can consist of one or more of these components. these pay rates change annually on February 1. I'm open to the format but i envision a calendar with the months placed vertically and each months dates placed horizontal below each month. Below the dates for each month a horizontal line that auto fills with my schedule with the ability to add and edit to calculate the projected pay for each period. A column to the right of the calenda...

I am looking for a freelancer who can help me with a project to write a simple flow in Power Automate. The goal is to send an email with attachments from OneDrive whenever a new row is added to an Excel spreadsheet. Email Service Provider: Outlook Requirements: - Experience with Power Automate and OneDrive integration - Proficiency in working with Excel spreadsheets and manipulating data - Familiarity with Outlook email service provider Task: - Set up a flow in Power Automate to monitor the Excel spreadsheet for new row additions - When a new row is added, extract the relevant data and send an email with attachments from OneDrive using Outlook Please provide examples of previous projects or relevant experience in your proposal.

I am looking for a freelancer to help with creating a Pivot Chart and a vlookup function. I need the chart to visualize financial data and have a specific layout in mind. The complexity of the vlookup function is simple, with just one lookup value. In addition, I need help customizing the output of the chart and the vlookup. This involves selecting the correct format for the data, choosing an appropriate color scheme, and formatting the cells and fonts. I expect the freelancer to have experience creating charts and functions in Excel and producing visually appealing outcomes. Furthermore, the freelancer should use best practices when creating the chart and vlookup. The ideal freelancer should be able to complete the project in a timely manner, understand my particular needs, and produc...

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 am looking for an experienced VBA coder to help me with validating data in an existing database. I have already created the database, but now need help tweaking it to make sure all the data is correct and accurate. I don't have a specific validation rule in mind, so suggestions would be welcome. The right person should be comfortable working with Access Databases and be able to ensure the data is accurate. Please let me know if you have any questions. Thank you!

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 am looking for an experienced vb.net Developer to join my team and help build an advanced system with multiple features. The successful candidate will need to have a strong understanding of vb.net and proficiency with software development. This project is urgent, and must be completed within a week. The software must also be of high complexity with integrated systems. When successful, the completed system must be bug-free and with a high level of accuracy. In addition to software development, the candidate may also be asked to do some database management. If you possess the skills and experience needed, please apply for this job. I look forward to hearing from you!

I am looking for someone to help me generate an Excel data chart to visualize both numeric and textual data in a pie chart format. I have a specific design already in mind, and I will provide more details when I find the right person for the job. Experience in creating chart graphics and visuals is a must, and ability to implement a plethora of data is highly desired. Communication and collaboration capabilities are also important. Overall, I'm looking for someone to help me turn my data into a highly understandable, visually appealing chart.

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

Please Sign Up or Login to see details.

I am looking for a freelancer who can help me with organizing spreadsheet data. The project involves the following requirements: - Type of data: categories - Raw data: I have the raw data that needs to be organized - Complexity: Simple sorting and categorizing Ideal skills and experience for this job include: - Proficiency in using spreadsheet software (e.g., Microsoft Excel, Google Sheets) - Strong attention to detail for accurate data organization - Familiarity with basic financial terminology and concepts - Experience in sorting and categorizing data in spreadsheets If you have the skills and experience mentioned above, please submit your proposal. Thank you!

I am in need of someone with experience utilizing Microsoft Excel to create a set of spreadsheets. My data is quite complex in nature, so I'm looking for someone who can handle the challenge and has expertise in data analysis, formulas, and functions. The task needs to be completed within a week, so I'm looking for someone with the availability to finish it on an expedited timeline. If you're up for the challenge, please let me know how soon you can begin and what your estimated timeline is.