Vba for programmersроботи
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selecti...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
...looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience ...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I'm looking for programmers with solid experience in DeFi app development, particularly related to Liquidity pools, Yield farming, and Staking rewards. Key requirements for this project: - Creating a DeFi application that incorporates the above-mentioned features. A fully automated platform, that searches for highest return per transaction, and yet lowest or no risk opportunities in , liquidity pools , arbitrage of all sorts, staking, yield farming and any potential combination to achieve same goal. Ideally, this will be a platform similar to Krystal, but with the added features of above automation based on user request for each item of opportunity. Software must be able to find, on all existing platforms and exchanges these opportunities, evaluate ...
...advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an und...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA...
I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and respond to client.
I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used ...
...using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attent...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
PLEASE DO NOT CONTACT US DIRECTLY. WE WILL NOT HIRE YOU IF YOU DO. ALL COMMUNICATIONS MUST BE DONE THROUGH FREELANCER. We are looking for a freelancer who is experienced in Zoho CRM editing. The job involves making necessary modifications to our existing Zoho CRM system to meet our specific needs. The freelancer should be familiar with the functionality and customization options within Zoho CRM. The responsibilities of this job include updating fields, layouts, and modules, creating custom fields and workflows, and integrating third-party applications. Additionally, the freelancer should have knowledge in data migration, data cleaning, and report generation. Relevant skills: - Zoho CRM customization - Field and layout updates - Custom field and workflow creation - Third-party...
crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understandi...
Please bid only if you have extensive experience with Odoo SAASkit Module by Pragmatic Pragtech.co.in. We only need people with expereience in that specific module, and donm't need anyone without experience with this specific nmodule We are looking for freelancers that have vast experience with Pragtech Odoo Saas Kit, we are a group of programmers We need guide, escort and support because Pragtech company is fraudulently trying to bill us for houndreds of hours instead of giving simple support We will pay handsomely for whoever help us going over some issues we have
We are looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Exp...
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking w...
We're seeking freelance programmers with a flexible skill set as the specific programming languages and project objectives weren't defined. An ability to adapt to various programming languages would be ideal, encapsulating yet not limited to Java, Python, and C++. As the project's main target and functionality weren't specified, experienced bidders with diverse backgrounds in creating mobile apps, website development, and software application building would be preferred. This project may contain elements like user authentication, database integration, and payment processing. It's important you're adaptable and comfortable with possible modifications as the project progresses.
...and text to voice features - Experience in developing RAG web applications Data Analysis: - Strong analytical skills and experience in handling data - Able to provide insights and make recommendations based on data - Proficient in Python data analysis libraries In particular, I need the voice to text and text to voice functionality to be focused on converting text to speech. Ideal candidates for this project should have: - Proficiency in Python, with a strong focus on web development and data analysis - Experience in creating user registration and login features, content management systems, and voice to text and text to voice functionalities - Previous work on RAG web applications - Strong analytical skills and experience in handling large sets of data - Excellent communicatio...
...that is training AI algorithms for military use. We need a logo designed for business cards and our website. We want a cool, dangerous logo that reflects what we do - build weapons of war. Most defense companies like Boeing, Lockheed-Martin, General Dynamics, etc. have very boring, blue and white logos. Most tech companies have logos that look like something a 2-year-old would play with. As a defense-tech startup, we'd like a logo that gets away from the trend of blocky, minimalist tech logos and boring, unassuming defense company logos. We want a logo that says danger, intelligence, sophistication, and cool. As the person in charge of the logo, I've decided that I'd like a dark red on gunmetal grey color scheme, with black and white as additional colors ...
...Store Inventory Management System. It's crucial for the system to streamline inventory tracking, significantly enhance order processing efficiency, and provide robust reporting capabilities. To create a custom inventory software tailored to the requirements of a folding and sliding door manufacturer workshop, you'll need to develop a comprehensive solution that encompasses the entire workflow. Here's a breakdown of how you could approach each step: 1. **Job Order Management:** - Allow users to create job orders with reference numbers for each project. - Capture project details such as customer information, project specifications, deadlines, etc. 2. **Requisition to Store:** - Enable users to create requisitions for materials needed for...
...conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de Excel que se está creando, incluyendo las funciones específicas que se espera que realice y los datos que debe m...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc....
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within 3-4 weeks.
I need group of skilled programmers that are aware of a game called “rise of kingdom”. Project budget is 20k-40k. Basically i want to make a bot for the game that does most of the things.
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the versi...
I'm seeking an experienced freelancer to debug and build my GitHub actions for 2 of my Android Java projects. The main task involves using building variants of my android application for the "development", "staging", and "production" environments which will all have separate API endpoints, package names, and app icons. Experienced Android Java programmers with a solid understanding of GitHub action builds, API implementation, and flexible design skills will be the ideal fit for this project.
Cautam programator cu experienta in crearea de site-uri custom si wordpress. Dorim sa colaboram doar cu o persoana serioasa si cu experienta in programare pentru angajare sa colaborare pe proiect. Oferim si solicitam seriozitate si rapiditate in dezvoltarea proiectelor. (Romanian programmers Only)
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...
As an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Stron...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be deliver...
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentat...
...you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excellent communication skills, as the explanation of each step will be vital for...
I'm seeking an expert Python developer to integrate the Sales, Inventory, and Accounting modules of Odoo with WooCommerce. This is an advanced task that requires deep knowledge of Python programming ...platforms. KEY TASKS: - Develop a robust API connection between Odoo and WooCommerce. - Ensure seamless data exchange between the Sales, Inventory, and Accounting modules. REQUIRED SKILLS/EXPERIENCE: - Expert-level Python programming skills. - Extensive experience with Odoo and WooCommerce integration. - Experience with API development and integration. This project is not for beginners or intermediate level programmers. I need someone with a high degree of skill and proven proficiency in Python, Odoo, and WooCommerce. If you meet these requirements, I look forward to ...
...looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a no...
Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA
...Proposals in response to deep reading and understanding of the project requirements (only seniors make bids! The project has a Penalty clause for the deadline) I'm on the lookout for a talented web and mobile app developer who can help bring my cloud restaurant concept to life. Here's what I need: Features: 1. Online Ordering - For easy and convenient customer orders. 2. weekly menu (a page to show our weekly menu) 3. Menu Management - Ability to add, edit, remove, and categorize menu items based on my needs, plus setting item availability. 4. Delivery Tracking - Allowing customers to check their food order status. 5. Nutrition Coaching Reservation - Capability for customers to reserve sessions with a dietitian. 6. Customized Ordering - Feature tha...
I'm in need of an experienced Excel professional to help me build a sec...handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand ...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
...Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: Contact Name: Date Created: Ticket Number: The...
