Complete project vbaJobb
excel vba programming convert excel sheet function into VBA
I NEED HELP WITH BUILDING AN AGENDA LANDING PAGE, FOR AN E-FLYER invitation. i ALSO NEED SOME MINOR FONT CHANGES TO AN EXISTING E-FLYER. IT WILL TAKE NO LONGER THAN 15MINS. PLEASE HELP . HERE IS LINK
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...
...confirm the shipment. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to the courier for confirmation. Technical Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel fil...
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 integr...
Rebuilding a fullscreen section in Elementor on your server Content Homepage / Fullscreen Section: Animated font Animated flipping image menu Please only report freelancers who can realize this today. It is not a very big task Thank you
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).
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("0:00:...
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 have an old drawing plan that I'd like to transform into a modern,...like to transform into a modern, eco-friendly residential space. The project involves a complete redesign, incorporating sustainable features such as solar panels and energy-efficient insulation. Key Tasks: - Complete redesign of an existing drawing plan - Integration of sustainable features like solar panels and energy-efficient insulation - Ensuring the new plan is optimized for residential use Ideal Skills and Experience: - Previous experience in residential design - Proficiency in incorporating sustainable features in design - Ability to create detailed and comprehensive plans - Understanding of structural elements and architectural principles Please bid if you have the right skills and...
I am in the process of implementing a final year project focused on Precision Farming. The project aims to leverage real-time crop images and AI to enhance crop monitoring, ultimately increasing crop yield and reducing water usage. Key requirements and deliverables include: - Building an intuitive Web UI that can analyze and display real-time crop images - Implementing machine learning algorithms using Python to interpret and predict the crop health and water requirements - Designing a robust backend system that can process and store large volumes of image data The ideal freelancer for this project should have: - Proficiency in Python programming - Experience in developing machine learning algorithms - Strong background in image processing and analysis - Prior expe...
I need a professional adept at 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 outpati...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 understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more...
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
I am looking for a skilled developer to create a customized iOS and Android app for my e-commerce business. This app will need to be fully integrated with WooCommerce, as I don't currently have a website so this will be the primary platform for my products. Key Requirements: - The app needs to have a seamless and intuitive user interface, ensuring a smooth shopping experience for customer...gateway is a must, although I'm open to suggestions in this area. I'm seeking a developer with experience in building e-commerce apps, particularly those integrated with WooCommerce. Prior experience in handling payment gateways would be a definite plus. Your ability to create an app that is not only functional but also visually appealing and user-friendly will be crucial to the succes...
I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored 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 inv...
I'm looking for a skilled video editor who is proficient in Canva to help me complete a 1 hour 7 minutes Canva video. 17 minutes have been created. We need to follow the same formatting / style to complete the video. We add slides (use the templates we already used) and video and some animation elements to make it look good. The voice over has been fully uploaded so the slides, video clips just need to correlate with the provided audio. Key Requirements: - Length: The final video should be 1 hour 7 minutes long. I need someone who can ensure the pacing and flow of this length is maintained. (50 minutes remaining - no modifications on existing 17 minutes) The main message of the video is to educate and inform the viewers. It is essential that the enhancements made help ...
Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs for data retrieval and manipulation. Ensure seamless integration with the chosen frontend framework. Sections Requiring Backend Functionality: User Authentication and Authorization Data Retrieval for Services Newsletter Subscription Management Interactive Content Management Blog and Opinion Management Event Management Comment Section Functionality Social Media Integration Contact Form Submission Handling Specific Requirements...
I'm seeking a skilled professional to develop a Solidworks macro for spec...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 as re...
I have multiple Excel spreadsheets containing c...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 attention to detail is a must. - Communication: Regular updates and clear communication throughout the project are essential. Please include your relevant experience and any strategies you would utilize to ensure an efficient and precis...
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.
I'm looking for a talented designer who can help me with a variety of design tasks to refresh and enhance my company's branding. - **Logo Vectorization**: I currently have a JPEG version of the logo and would like it to be converted to a high-quality, scalable vector format. This is essential for maintaining the highest quality of the logo across all branding materials. - **Namecards De...presentation should be engaging, easy to read and consistent with our new branding. Ideally, you should have: - A strong portfolio of similar branding projects - Proficiency in graphics design software - Understanding of branding and corporate design - Excellent communication skills and a creative mind Please provide examples of your previous work and let me know how you plan to approach ...
I'm looking for a talented designer to create a full brand identity package and website. **Logo Design and Tagline:** - Main objective is to establish brand recognition. - I envision a modern and minimalist style, so the logo should reflect that. **Typography, Color Palette, and Branding Guidelines:** - Develop a cohesive typography and color palette for the brand. - Create a set of branding guidelines that include imagery ideas for social media posts and web banners. **Master Packaging & Label Design:** - Design a master packaging and label template that can be used across different products. **Website:** - Build a website with an online store. - This website should reflect the modern and minimalist style of the brand. **Social Media & Website** -Ideas for banners, po...
I require comprehensive assistance in setting up a Tmall store. The store will be dedicated to selling a specific brand of wine. Requirements: - Full setup of the Tmall store - Knowledge in wine listings - Experience with marketing a specific brand Skills & Experience: - Previous experience setting up Tmall stores - Strong understanding of wine products - Proven track record in brand marketing - Adept at writing engaging product descriptions.
My website has over 100000 pages and I am looking for an expert to ensure that all pages are indexed in Google search. While I've done some work on the SEO, it's not comprehensive enough. What I need the most is assistance with page indexing as well as a general look over to see if there's anything else that could be improved upon. Right now 5 lac pages are indexed, 2.5lacs are crawled not indexed and remaining has to be submitted for crawling. Key requirements: - Experience with SEO and particularly page indexing. - Ability to do a general audit of the website and suggest any other improvements. - Good understanding of Google search algorithms.
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 mod...
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.
...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 understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
I'm looking for a skilled and experienced developer to finalize the creation of our email marketing software. Specifically, I need a hand with: - Email campaign management system to help schedule and easily manage robust campaigns. - A genuinely sophisticated HTML e...customization like altering layout and design, not just basic font or color changes. - Subscriber list management offering simple, well-structured list administration. - Comprehensive analytics tracking and reporting, such as open rate, click-through rate, unsubscribe rate, and user location. Knowledge and experience in email marketing platforms and email template customization are a must for this project. Previous work on similar projects would be a plus. Additionally Experience with mern stack, aws ses and mon...
Complete FusionPBX Setup and Configuration - dialplan outbound - outbound call - 2 did inbound - different group ring - announcement
**Project Description:** We are seeking an experienced Laravel developer to build a complete single e-commerce website from scratch or integrate into an existing professional frontend. The website will serve as a platform for selling products online, with a custom frontend design provided by us. The successful candidate will be responsible for building the entire website, including frontend and backend development, and integrating Razorpay as the payment gateway and Shiprocket as the delivery partner. **Key Responsibilities:** 1. **Complete Website Development:** Building the entire e-commerce website from frontend to backend, ensuring seamless integration and functionality across all components. 2. **Frontend Development:** Implementing a custom frontend design pr...
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 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 will be a plus point. Please make sure your bid covers the overall efforts to complete t...
Setup Project and do minor enhancement. Developer who can work with ftp and follow to fix issue one by one. Project can be complete today, small work only.
Project Description: We are looking for an experienced WordPress developer to help us complete the final touches on our website. The website is already 80% complete, and we need assistance with implementing various features and improvements to enhance user experience and functionality. Also, PWA apps are necessary to be created for this website. Project Tasks: 1. Improvement of Graphics and Design: Enhance the visual appeal of the website through design changes and improvements. 2. Arabic RTL Support: Integrate Arabic RTL support to cater to our Arabic-speaking audience. 3. Marketing Plugins: Integrate marketing plugins to enhance promotional efforts and drive traffic to the website. 4. Web-based Mobile Apps (PWA): Implement Progressive Web Apps (PWAs) for a...
I am seeking a skilled freelancer experienced in Shopify to complete set up my online dropshipping store and and bring sell. The following outlines the primary tasks: 1. STORE SETUP: Configure my Shopify store and ensure it's ready for the dropshipping business. Prior experience in dealing with dropshipped products is crucial. 2. INTEGRATIONS: Incorporate a payment gateway, inventory management system, and a customer review feature. It would be best if you have proficiency in implementing these functionalities in Shopify. 3. SELL: Bring traffic to my to my store and sell products. Your depth in understanding Shopify and the dropshipping model could make this task straightforward and successful.
Seeking an experienced full-stack developer to collaborate on a project. The project utilizing React, NodeJS, and Express JS. A Figma link will be provided for reference. Given the urgency, we require someone capable of completing the project within a tight 2-week deadline. Please apply only if you can commit to this timeframe. Key Responsibilities: - Develop a comprehensive E-commerce platform. - Integrate a Learning Management System. - Implement a discussion forum for user engagement. Further details will be shared upon selection. To express your interest and be considered, kindly begin your bid with word 'Interested'. Looking forward to working together to bring this project to fruition.
I have a project that requires the migration of all product information from a Wix platform to a Shopify store. I have exported the data to an Excel CSV file which includes: - Product names and descriptions - Product images - Product prices - Product options and variants - Product skus Given the format, an Excel specialist with thorough experience in CSV file formatting would be particularly suited to this project. Experience with Shopify's product listing format will also be immensely valuable. The task at hand is to modify the CSV file accordingly so it's compatible with Shopify's import method. - Key Skills: Excel, CSV file formatting, Knowledge of Wix and Shopify's product data structure - Ideal Experience: Previous product data migration between C...
...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 a specific project. - Include details such as quantity, description, project reference, etc. 3. **Store Confirmation:** - Once the store receives the requisition, confirm the availability of requested items. - Update inventory levels accordingly. 4. **Stock Management:** ...
...necesitará 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...
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. I'm ready to s...
...multiple platforms. We require a creative and experienced graphic designer who can work with our existing logo and brand identity, which we will provide, to develop a comprehensive suite of marketing essentials. This project is perfect for someone who enjoys creating cohesive and visually appealing materials that reflect a brand’s identity. Requirements: - Logo Redesign: Refresh our current logo to resolve issues with pixelation and enhance overall quality. - Video Call Backgrounds: Design custom backgrounds for video calls that reflect our corporate identity. - Word Templates and Project Proposals: Create templates for documents and proposals that are user-friendly and visually aligned with our brand. - PowerPoint Templates: Design templates for presentations that...
I'm looking for a skilled developer with experience in food delivery apps...I'm considering using scripts from Envato or Code Canyon as a base for this project. Any framework compatible with these scripts would be acceptable. - **Timeline**: I don't have a strict deadline for this project, but I'd appreciate if the work could be done as efficiently as possible without compromising quality. Ideal skills for this job include: - Proficiency in the selected platform/framework - Experience in integrating user-friendly and efficient food delivery features - A portfolio of similar projects or experience in the food delivery sector - Ability to work on multiple platforms and app types Please provide examples of your previous work and let me know how you plan ...
As the client, I am looking for a reliable professional to build a customized Excel plugin that will ...to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. - All source code must be posted with c...
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, specifically any proje...
I'm looking for an experienced...you'll have to source suitable faces. Please come with creative options. - Adjusting lighting in the photos for a more "fresh image" - Adding a few elements to the photos for aesthetic or creative purposes (to be discussed during project execution) The ideal freelancer for this job should: - Be highly proficient in photo editing software. - Have previous experience in product photography editing or similar projects. - Show creativity in sourcing and selecting replacement faces. - Have an eye for detail and aesthetics, considering the product and brand image. This project requires not just skill, but also a creative eye and the ability to understand and enhance my vision for the product photos. If this sounds like your kin...
...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 - Strong background in data analysis a...
