Visual Basic Jobs

I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human resources or re...

I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.

I am in need of a simple Excel sheet for my pastry shop. It will be used for workers to log and track their daily production. Specific Information & Organization: - The table should be organized around daily production. - The information to be included in the table should encompass: - Flavors (10-15 in total) - Locations - Amount produced in each batch - Day of production At the end of production, employees press submit button and the data is transferred into Google Sheets with saved information while the form gets cleared and ready for next submission. Ideal Skills: - Proficiency in Excel; ability to create user-friendly and easy-to-understand tables - Experience in creating similar tracking or production sheets a plus - Understanding of basic bakery or food production ter...

I'm looking for a detail-oriented individual to input a combination of text and numbers into Excel. Below are the specific requirements for this task: - Data type: It will involve both text and numbers. - Data organization: The data should be entered line for line, from one cell to another, and from top to bottom. - Cell arrangement: Each line should be inserted into a separate cell. The ideal freelancer for this project should have a keen eye for detail, a solid understanding of Excel, and be comfortable working with text and numerical data. Accuracy and speed will be key to delivering this project effectively. the lines are as below: icd report *Upcoming Vessels* *11.04.2024* *TPA Terminal II* *01. MAERSK PHUKET 39* (E.T.A 13.04.2024) Local 23 ...

My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new automated invoicing system. I look forward to receiving your bi...

Por favor, regístrate o inicia sesión para ver los detalles.

I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deliver effective solutions. If ...

I need an expert who can create a spreadsheet on Microsoft Excel that can calculate simple flat rate commissions for my employees. Ideally, you should be proficient in Excel and understand how to implement formulas and functions efficiently. It should be designed in a simple table format for ease of use and clarity. Your responsibilities will include: - Developing a customizable and easy-to-use Excel spreadsheet - Incorporating calculations for simple flat rate commissions - Organizing the data in a table format The ideal freelancer should have experience in Microsoft Excel and a general understanding of commission structures. Attention to detail, efficiency, and accuracy are vital for this task. Experience in financial data is an added advantage.

I am seeking a skilled developer to customize and brand an FTP/SFTP program for Windows. This project involves both advanced customization and specific security features. Key Requirements: - Branding: The program needs to be customized with our logo and color scheme. - File Handling: After uploading files to a set server, the program must be able to move the uploaded files to a different directory. - Customization: I require the ability to select the path of where the file paths are. - Security: The program should include specific security features, specifically activity logs for uploads and downloads. Ideal Skills and Experience: - Extensive experience in Windows program development - Prior work with FTP/SFTP programs - Strong UI/UX design skills for branding - Security feature impleme...

I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.

I'm seeking a highly competent freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way that it...

Hi I need a professional on excel api using VB language to import volume and open interest data from interactive brokers into excel sheet as real time data

seeking a front end and back end team to create a proprietary enterprise system that connects with third data providers and underwrites and evaluates real estate properties based on multiple financial models run at the same time to determine highest and best use for future development for that piece of unimproved or improved land parcel. Modeling to be run automatically, with resulting land value will be identified as well as an exit value based on projected expenses meeting a ROI for our investors. Fees will be integrated in the expenses and disposition fees. 3rd party Data inputs (both CSV files and API integration) to seamlessly capture data inputs into the financial modeling. Upon meeting a financial threshold, a report is auto-generated and a building example is also created via Gene...

I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, please reach out and explain your approach.

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 7 Hours not more then this, i had the excel to work on just make this on new sheet

I am seeking a proficient developer who can create a comprehensive system using O365 MS Forms. The project will involve: - Creating a form using O365 MS Forms that incorporates more than 20 questions, all requiring text input. - Integrating Microsoft Lists to store the responses from the form, including the list of questions and best practices. - Utilizing Power Automate to fully automate the process and generate a MS Word report. Key skills required include: - Excellent proficiency in O365 MS Forms - Experience using Power Automate - Knowledge on integrating Microsoft Lists - Ability to work with MS Word report templates, as a specified layout will be provided. This project requires a developer with a keen attention to detail, excellent technical abilities and the capabi...

I need assistance with Excel, specifically with its worksheet formatting feature. My main goal is to create tables and charts to visually represent my financial data. The perfect freelancer for this job should have extensive experience in data visualization, especially when it comes to: Creating accurate formulas displaying in a clean manner

I need assistance with automating input into a web page using VB.Net (or C# with Visual Studio 2017 or higher). I have a mostly working sample in VB.Net, but I am struggling with automating the entry of an antenna type, which is facilitated by a dropdown menu. The specifics of my requirements are as follows: - Web Browser: The automation should be compatible with either Google Chrome or Microsoft Edge. - Handling Dynamic Elements: I am not positive about the need for the automation to handle dynamic web page elements. This will require some assessment or flexibility in the solution. The ideal freelancer for this project should have: - Proficiency in VB.Net or C# with Visual Studio 2017 or higher. - Experience with web page automation. - Knowledge of automating input through dropdown menu...

I require a solution to fetch real-time stock prices from the National Stock Exchange (NSE). The fetched data should populate in an Excel spreadsheet and refresh every second. Key Responsibilities: - Scrutinize the dedicated NSE platform to fetch live stock prices - Develop a method to automate data update in Excel every second Mandatory Skills: - Proficiency in Excel, with particular emphasis on data extraction and automation - Knowledge and experience of the NSE online system - Familiarity with automatic data retrieval and real-time updating This project must maintain a high standard of accuracy, as any mistakes could lead to misinformed financial decisions. Hence, meticulousness in data management and understanding of stock market trading is paramount. I look forward to working wi...

I'm in need of an Excel professional who can assist with a small project. This project requires a high level of proficiency with importing data into Excel and working with texts. Your task will primarily involve: - Creating an excel sheet with less than 10 columns and rows - Making sure the sheet is well-organized for data importing - Importing a specific set of text data into the sheet Ideal candidates would have a strong grasp of Excel and experience with data importing particularly. Familiarity with text data and efficient organization of smaller Excel sheets is a must. Your knack for making sense out of data will make you the perfect fit for this project.

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

I am looking for a data expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3correct;answer4;answer4correct. - Purpose: The purpose of this project, namely, is to make the data compatible with a specific system. - Assistance Required: Depending on the case, some data entries may need reformatting prior to transformation, ensuring they are structured correctly. - Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical. Ideal Candidate Skills & Experience: - Experience in data manipulation and transformation using Excel and CSV formats. - Proficiency in data cleaning and st...

I'm in need of a professional who can extract data from my searchable text PDF files and input them into Excel. The PDF files contain complex data layouts, including tables and images. Key Requirements: - Extract and organize the text, tables, and images from the PDF files into Excel - Maintain correct data alignment and structure - Apply basic Excel formatting, such as font styles, cell borders, and column width adjustments You are expected to: - Have experience with PDF to Excel conversions, particularly with complex layouts - Be proficient in handling searchable text PDFs - Demonstrate knowledge in basic Excel formatting techniques I'm looking for a freelancer who can efficiently convert these PDFs into Excel without compromising the data integrity and layout. If you have e...

I need an advanced Excel spreadsheet created, compatible to both Windows and Mac. It will be used primarily for team collaboration, and should have the following key features: - Real-Time Editing: The ability for multiple team members to edit the sheet simultaneously, reflecting changes in real-time. - Task Highlighting: An in-built mechanism for highlighting overdue tasks, enabling focused teamwork and timely task completion. - Report Creation: A feature that allows the easy conversion of the sheet into plain text. The report should maintain much of the original formatting for clarity. - Task List: An organized task list creation feature, enabling team members to assign and keep track of tasks efficiently. The spreadsheet should also be editable as part of a shared worksheet on Teams. I...

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

Making a Excel based data model (based on some raw tables), will have to make a similar version of existing data model (that will be shared) by the end of Thursday (11th April) i..e in 2/3 days Existing model attached! Currently I have excel with tables of information

data entry freelancer who can prepare excel sheet

data entry freelancer who can prepare excel sheet

I need a freelancer with strong Excel skills for text data entry. The job requires accuracy and attention to detail, as it involves straightforward input in an Excel Spreadsheet. There's no need for specific formatting, making it an ideal gig for those with experience in simple data entry tasks.

I'm seeking a talented individual to create a custom report that merges both my sales and customer data. The report will include the following data fields: - Date - Customer name - Product name - Sales quantity - Sales amount - Other additional fields depending on the specific requirements at a given time. Notably, this report needs to be sent to a FTP server daily in CSV format. Ideal Skills: - Expertise in data analysis and report creation, specifically targeting sales and customer data. - Strong knowledge of CSV formatting and transferring files to a FTP server. - Ability to accurately arrange data fields in the specified format. - Proficient in creating actionable and easy-to-understand reports from complex data. Experience: Prior experience in similar projects is a signifi...

I'm seeking a proficient Excel expert to develop an interactive dashboard and implement pivot tables within my project. Key responsibilities will include: - Setting up formulas and functions to aid in data analysis. - Creating a visually appealing, interactive dashboard. - Incorporating ability to filter and analyze data via pivot tables. - Customizing calculations and generating summary reports in pivot tables. The ideal candidate should have a strong understanding of Excel's logical formulas and a knack for complex data interpretation. Extensive experience with dashboard design and pivot table utilization is essential.

I'm in need of a skilled Excel programmer who can construct intricate engineering calculators. These need to cater to advanced finite element analysis, focusing primarily on structural analysis. Ideal Skills and Experience: - Extensive background in Engineering, particularly involving structural analysis - Proficiency in Excel to create complex calculators and handle high-level, finite element analysis - Experience in transforming Excel functionalities into user-friendly applications To sum it up, I am expecting: - Excel calculator for structural analysis with capabilities for advanced finite element analysis - Option to evolve these Excel calculators into an app in the future

As an immediate requirement, I need an expert in Excel who is well-versed with an array of formulas and functions. The key tasks required for this project are as follows: - The application of Vlookup and Hlookup, Logical functions (IF, AND, OR) and Arithmetic operations (SUM, AVERAGE, MIN, MAX) - Conducting Data analysis using Pivot tables and creating various scenarios in the Scenario Manager - Ability to work with multiple worksheets - Organising the spreadsheet using Grouping & Outlines and employing advanced Excel functions - The project also involves the creation and handling of intricate elements such as Worksheet Linking/Workbook features, the usage of Header and Footer and providing a touch of Creativity & Originality Structure-wise, the project involves a commission spread...

I have a set of digital PDF files, each containing complex data in both numerical and textual formats, neatly organized in tables. I'm looking to convert these into clean, precise CSV files. Ideal Candidate: - Proficiency in data conversion from PDF to CSV - Exceptional precision in handling both textual and numerical data - Knowledgeable in structural recognition of data tables in PDF Task Requirements: - Convert tables from digital PDF to CSV - Ensure the accurate transformation of all data points - Preserve data consistency, particularly with numerical and textual data elements - Attention to detail is a must to prevent errors while converting into CSV. Please place a bid only if you're comfortable and have experience with these requirements. Looking forward to your prop...

I require an excel template that is capable of managing both resources and project schedules seamlessly. This template must: - Enable resource tracking, specifically filtering resources based on their technical skills. - Incorporate Gantt charts, for an intuitive visual representation of the project schedule. - Include task dependencies, to ensure seamless project coordination and workflow. No differentiation between levels of technical skills in resources is needed. With this template, my aim is to streamline project scheduling and resource allocation while also having a clear overview of the technical skills within my team. Therefore, any freelancer applying should have solid experience in excel programming and a keen understanding of project management principles.

In need of a software that can interlink and manage spreadsheet files for my machining process. Here's what the tool needs to be able to do: 1. **Document Linking**: The primary function of this software should be to connect various spreadsheet files relevant to the machining process. 2. **Control Plans & SOPs**: The software should allow us to create and manage control plans and Standard Operating Procedures (SOPs). 3. **Data Management**: It should handle spreadsheet files with embedded charts and calculation formulas, and needs to be capable of maintaining this functionality while linking documents. 4. **Runchart Plotting**: The software should be able to generate runcharts automatically using input data. Ideal applicants for this task would have prior experience in deve...

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

Hello, I have a list of details, using those you need to collect a lot of data from a specific website. I will show you how to scrape the details like Name, Email, and Phone numbers, you just need to follow the pattern..

Not so much of a project, but a relatively simple task for an experienced Microsoft Word geek. I have two Microsoft files. v1 was created and saved after 5mins in April this year. Unfortunately, it does not contain some final drafting that was lost when I clicked the wrong button at the time. v2 of the document is a simple cut-n-paste of the original with corrected 2nd bullet (highlighted) My Ask/Request Update to the original v1 document with the 2nd bullet replaced with (v2 Bullet 2) without changing the original Properties. OR the v2 document (as is, no change to document content) but showing the original document properties (last modified & created) see attached Word file called Document Properties. The final Word document - whichever approach (above) is taken needs to have h...