Optimisation simplexe vba jobs
My VBA script was written in Windows Excel and now i'm trying to use it on Mac Excel and its not work
I am looking for a freelancer who can build a MACRO in Excel to ...Excel to automate a task for me. Specifically, I need the MACRO to handle file management for both CSV and XLSX formats. The ideal candidate for this project should have experience in Excel VBA programming and be able to deliver a high-quality, error-free solution. Key requirements for this project include: - Automating file management tasks in Excel using VBA - Expertise in handling both CSV and XLSX formats - Ability to deliver a high-quality, error-free solution - Strong communication skills to ensure that the project is completed on time and to my satisfaction. If you have experience in Excel VBA programming and are interested in this project, please submit your proposal with your relevant experi...
I have a function with just 1 line of code. Need to convert it into vba Here is the link to that 1 line of code:
I am looking for a freelancer to develop an expense tracking software using MS Excel for my personal use. The software should have the following features: - Expense categorization: I need to track my expenses by categories such as groceries, utilities, transport...transportation, etc. - Customizable reports: I want to be able to generate reports based on my expenses for a specific period of time or by category. - Custom-built solution: I prefer a custom-built solution that is tailored to my specific needs. The ideal freelancer should have experience in developing MS Excel-based solutions for expense tracking. Strong skills in Excel formulas, macros, and VBA programming are a must. The project timeline is flexible, but I would like the software to be completed within a reasonable t...
I am looking for a freelancer to create a full branding package for my business, targeting other businesses. The ideal freelancer should have experience in creating modern branding designs. Specifically, I need the following materials: - A logo that represents my business - A color scheme that is professional and modern - M...that is professional and modern - Marketing materials for both print and digital media The preferred style for my branding is modern, with a minimalist approach. The freelancer should have a good understanding of current design trends and be able to create a unique and memorable brand identity for my business. Further information: The company is a cloud technology company focused on cloud optimisation and cost savings. This needs to be factored into th...
The programme is about ESS Operation in DED, and I need to transfer a GAMS code for optimisation into pyomo code, using Jupyter notebook and Gurobi solver. It is a simple code, which contains two small tables of data, and nine equations. For the output, it has a table and three diagrams. However, I have met several bugs for my code, I am looking for someone who can debug them for me. The work is expected to last no more than one hour. The code must have an output listing all the optimisation result, containing a table with variables and numbers, as well as three diagrams. The diagrams are: 1. "power/energy vs time(h)"; 2. "Charge/discahege(MW) vs Time(h)" and 3. "Pg,t(MW) vs Time(h)". For diagram 1, I want to have three lines with dots, 1. Tot...
This is a request for a VBA code that I can use to extract data. Scope: Only need everything under Expense section. No need any subtotal or grand total grouping. Want a vba code that I can run because we have this once a year for budget. This is unfortunately the only way to get the data as everything is entered manually into the system and we do not have any access to the backend data. (Screenshot 1) Output needed is excel (screenshot 2) There can be up to 100-300 tabs with somewhat similar format where we have to tweak the pattern where only expenses is what we needed so after Expense but before Total Line2. If there is any tabs that do not have expense budget will just skip those.
My need is to get a VBA script for Excel that I can run to read from a Workbook, the data from a sheet called "Calendar" and represent them in a new sheet to be generated calling it "Gantt". Brief description of the scope of application: I have a professional training school with 7 classrooms and I carry out a variety of courses both in the classroom and remotely in e-learning mode. Each course has a variable duration, which can even last several months and almost always has a fragmented cadence. In other words, the days of attendance are almost never consecutive from Monday to Saturday. The daily duration of each "course" event can also be variable. With the aim of optimizing the filling of my classrooms, I need to represent the course commitments al...
I NEED A VBA EXPERT I have a very poorly formatted excel sheet that need to be transfer into a access database. I already have all the regex figure out, and all the VBA is already written, just need some fixing. Very easy and quick project for an expert in VBA.
I have 40 excel files from those file I need to remove duplicates and if possible merge all files in one. I need urgent this donen like in next 2 hours. the files are larger like ea...am looking for a freelancer who can remove duplicates from all excel files in a folder. The files are in .xlsx format and I would like the duplicates to be removed both in-place and saved to new files. Additionally, I would like a report on the number of duplicates removed from each file. Ideal skills and experience for the job include: - Experience with Excel and data manipulation - Knowledge of VBA or other programming languages to automate the process - Attention to detail to ensure all duplicates are correctly identified and removed - Good communication skills to provide updates on progress and del...
...against data entry - canned / custom reports. SKILLS REQUIRED Advanced Formulas & Tools: such as - nested IF statements, INDEX-MATCH, SUMIFS, COUNTIFS, array formulas, Pivot Tables, Power Query (Get & Transform), data validation, etc. Visual Basic for Applications (VBA): Strong knowledge of VBA programming language to automate tasks, develop custom macros, and build interactive user interfaces. This includes creating custom functions, loops, conditions, and handling events, implement error handling techniques, and debug VBA code using breakpoints, watch windows, and error handling routines. Excel Add-ins: Familiarity with creating and utilizing Excel add-ins to extend Excel's functionality, such as building custom functions, integrating external da...
in plain English here it is: Check column G of Issued Items and select the worksheet if the content of that cell is Head Office select the worksheet Stock Levels - Head Office, if the content is West Metro select the worksheet Stock Levels - West Metro, if the content is North Metro select the worksheet Stock Levels - North Metro, if the content is South Metro select the worksheet Stock Levels - South Metro, f the content is Gippsland select the worksheet Stock Levels – Gippsland, if the content is North East select the worksheet Stock Levels - North East, if the content is South West select the worksheet Stock Levels - South West, if the content is North West select the worksheet Stock Levels - North West then find the cells that matches the contents of row 3 of the wor...
...will provide you with all the necessary content, descriptions, and category organization for support in the Georgian part. Please write KoreanCosmetics in your proposal, to understand that you have read the description. Project Details: - Logo and Template/design for the website will be provided; - Website should have 5 pages; - there are around 45 products in 10 categories; - Relative SEO optimisation should be included with provided tags and informations (no research required from the developer) Please read carefully the details, the budget for the project is 300$ and no more will be accepted, changing the price after the proposal will be automatically rejected. Write .no more than 300. too in your proposal. Functionality: - I would like an integrated payment system to ...
I am looking for a skilled freelancer who can create a macro to transform a column of text/strings. The transformation required is to split the text into separate columns. I am open to suggestions on how to best format the text during the transformation. Ideal Skills and Experience: - Expertise in Excel macros and VBA programming - Experience with text/string manipulation and data transformation - Strong problem-solving skills and attention to detail - Ability to communicate effectively and provide suggestions for the transformation process.
For Task 1, the following requirements need to be fulfilled: 1. Implement a basic search functionality for URLs and notes. 2. There are different approaches you can take to achieve this. You can either retrieve all the data from the database and filter it on the frontend (although this approach is not recommended), perform a classic query by iterating through all the data, or implement Mongo Atlas Search and set up search indexes (which is the recommended approach). 3. To enhance your project further, you can implement auto-complete functionality, which is also recommended. Feel free to enhance the search functionality as much as you want, as there are no limitations on the improvements you can make. Task1 : Description above ^ Task2 : Implement Authentication using JSO...
I am looking for an expert professional who can do the SEO Optimisation and Backlink of my e-commerce website and generate traffic and sales over my website. The person should also handle the stock updation over the website. My Budget is - Rs10000 to 12000 pm. We can discuss in detail further over chat.
...and content to increase organic traffic to digital channels. - Demonstrated success in increasing website traffic and improving conversion rates - Social media marketing: Managing, developing and growing our online presence by creating strategies and content for social media channels such as Facebook, YouTube and Instagram - Proficiency in Google Ads - Knowledge of keyword research and optimisation - Ability to analyze and interpret data for optimization purposes - Strong communication skills for ongoing updates and collaboration ...
I have a function 20 lines of code. Need to convert it into vba
I am looking for a skilled professional to conduct a thorough audit of my website and optimize it for better performance. My primary goal is to clear off all unnecessary stuff and improve the user experience. Specifically, I need improvement in clearing off all unnecessary elements and improving the site speed, navigation and layout, and content and visuals. The project needs to be completed within one week, and I am seeking a freelancer with experience in website optimization and auditing.
My website's search engine optimisation is currently in poor condition and I'm looking for an experienced SEO professional to help me improve it. I have a general idea of the keywords I want to use, but I'd appreciate any additional suggestions. My main goal is to improve my search rankings across the major search engines so I can get more organic traffic and boost my online visibility.
Hi, I'm looking for someone to help me with a small Excel project. I just need you fix my formula or find another solution. - I have 2 list in 2 columns (A and C) - I need to find if the text in column C is present somewhere in column A (anywhere in the cells) You will attached the file with my formula (column B) I prefer a solution based on formula, not VBA.
Have a product company related to consumer electronics, need help with SEO and above.
I am looking for a skilled developer who can create a macro to transfer data from an XLSX format excel sheet to an online form on the FRRO site. The project requires transferring more than 20 data fields from the excel sheet to the online form. Ideal skills and experience for this job include: - Proficiency in Excel macros and VBA coding - Experience with online form platforms, particularly the FRRO site - Attention to detail to ensure accurate data transfer - Ability to work efficiently and meet project deadlines
Welcome to my project- Find My Fixes! As an entrepreneur, I’m looking to develop graphical or motion content for Social media platforms and an SEO expert who can optimize website ranking that is optimized for search engine rankings. To do that, I am looking for an experienced SEO specialist and graphics designer to join my team and create designs that stand out from the competition. I am looking for someone to provide a comprehensive SEO & graphics design service that includes both on-page and off-page optimization elements. This includes researching and selecting the right keywords to target, optimizing content, link building, and setting up analytics tracking. Additionally, I require someone with social media graphics design experience to develop engaging visuals to post acr...
I need a freelancer who can help me with an API call from Rex to Excel for Mac using web query. My primary goal is to retrieve data weekly. The ideal freelancer should have experience with both Rex API and Excel for Mac. The project will involve: - Setting up the API call from Rex to Excel for Mac using web query or VBA - Retrieving data from Rex on a weekly basis - Ensuring the data is accurately imported into Excel for Mac If you have experience with both Rex API and Excel for Mac, please apply for this project.
I need a proficient Excel expert who can create a data entry form with VBA and advanced Excel skills. The purpose of the form is data manipulation and it will need to handle both numerical and text data. The form should have automated calculations to streamline the data entry process. I require someone who has experience in creating Excel forms and is proficient in using VBA and advanced Excel functionalities. The ideal candidate should be able to incorporate automated calculations into the form and ensure it is user-friendly. Additionally, some knowledge of conditional formatting and drop-down lists would be an added advantage.
The company needs US based freelancer to publish articles on various company websites using WordPress. The person needs to understand Wordpress with ability to use advanced publishing features, such as search engine optimisation, linking of internal and external pages and use of markup syntax. The company may send articles in batches which need to be published in specific time intervals to attract readers.
I am in need of a VBA expert to fix functionality errors in my current time sheet code. The issues are causing errors in calculations and need to be resolved immediately, within 24 hours. I have not made any changes to the code since the issue occurred. Ideal skills and experience: - Strong proficiency in VBA coding - Experience with time sheet applications - Ability to troubleshoot and fix functionality errors - Attention to detail and ability to ensure accurate calculations - Ability to work quickly and efficiently to meet the tight deadline.
I am looking for an experienced SEO specialist to improve the current poor state of my website's SEO. Specifically, I would like to focus on keyword research and optimization. I do not have a list of target keywords and need assistance in this area. The ideal candidate should have a strong understanding of SEO best practices and be able to provide recommendations for improving my website's visibility on search engines. Key skills and experience include: - Keyword research and optimization - On-page optimization - Backlink building - Familiarity with SEO tools and analytics - Strong communication skills and ability to provide regular progress updates.
the VBA code is not pulling data from the correct location in a table.
Hello Freelacers, I need a project with below requirements. 1. The code should be in VBA only. 2. The trading platform to be used for automation purpose could be Angel One, Alice Blue or Kotak only. 3. the automation tool should perform below steps.... .... 1. Should login to trading platform virtually 2. tool should store the OHLC data in excel of any date and any timeframe provided by user in excel sheet . 3. The tool should place the orders in trading platform.
Maintenance of Corporate Website Links and Optimization we have a website with 4 languages. We have changed our host and our site links are changed . I am in need of a freelancer who can help me maintain the links on my corporate website and optimize its loading speed. The website contains several pages and links, and I have noticed that some of the links in the pictures and pages are incorrect. Key Requirements: - Experience in maintaining corporate websites - Expertise in identifying and fixing broken links - Knowledge of website optimization techniques to increase loading speed The ideal freelancer should be able to start working on the project as soon as possible and complete it in a timely manner. Please reach out to me if you have the required skills and experience.
I have url with parameters. I want to post request with these paramaters in VBA MS Access using x-www-form-urlencoded and finally read the response
I want to use VBA to connect to my remote mySQL database. I do not want to downlad a connector. If anything needs to be downloaded it should just be the .dll (or other) files that can be loaded through the VBA code.
I currently have a website, and its functioning. The problem is our post is not ranked higher on google, so, we are looking for someone who can optimize SEO for our website so that it can be rank higher.
I am looking for a freelancer to automate the extraction of number and text data from PDF files and input it into an Excel spreadsheet. The ideal candidate for this project has experience with VBA programming language and is skilled in data extraction. Specifically, the project requires the following: - Extraction of number and text data from PDF files - Input of extracted data into an Excel spreadsheet - Formatting of the output Excel file to match a specific format provided by the client - Use of VBA programming language If you have experience with VBA and data extraction, please apply for this project.
I am looking for an experienced SEO specialist who can help me improve the search engine rankings of my website. The main goal of this project is to increase visibility and drive more traffic to my site and have ny website on top 5 first page of google. I am targeting specific keywords and phrases, but I am open to suggestions and a combination of both. Ideal skills and experience for this job include: - Proven track record of successful SEO campaigns - Expertise in keyword research and analysis - Knowledge of on-page and off-page optimization techniques - Familiarity with Google Analytics and other SEO tools - Strong communication skills and ability to provide regular progress updates.
I am looking for a freelancer who can fix an existing project management Excel sheet for me. The main purpose of the sheet is to manage my project tasks effectively and tell me when was the last date I worked on it. I would like the sheet to have advanced features such as macros or VBA. The specific task that I need the Excel sheet to perform is task tracking. Ideal skills and experience: - Advanced Excel skills - Experience in creating project management tools using Excel - Knowledge in macros or VBA programming
I need Amazon API two endpoints in VBA. Contact me for more details
Search Engine Optimisation - 2023 (United Kingdom)
need to have a show button macro for value column in the sheet assumptions for the pivot table
trying to create a workbook for our company CPHSP, I have done most of it but struggling with the VBA code to transfer rows from 1 sheet to another, I have got it working but when I more more than 1 row it overwrites the the last row I moved instead of stacking them like a list
...into how hydration care is actually delivered in the ward. For example, I have already observed how patients are asked about their fluid intake and output, how they are offered fluids and how they are monitored for signs of dehydration. I observed these when conducting all the ‘Service Evaluation’ and the ‘Qualitative interviews’. ---------------------------------- This project needs text optimisation (stitching paragraphs together, editing, updating references in order to ensure they are up-to-date references and working further on the Integration and Triangulation sections as well as all the other sections in the chapter). Although the job is mostly done, it needs to be taken to an advanced, high-quality well-hedged level. I would like you to ensure t...
...into how hydration care is actually delivered in the ward. For example, I have already observed how patients are asked about their fluid intake and output, how they are offered fluids and how they are monitored for signs of dehydration. I observed these when conducting all the ‘Service Evaluation’ and the ‘Qualitative interviews’. ---------------------------------- This project needs text optimisation (stitching paragraphs together, editing, updating references in order to ensure they are up-to-date references and working further on the Integration and Triangulation sections as well as all the other sections in the chapter). Although the job is mostly done, it needs to be taken to an advanced, high-quality well-hedged level. I would like you to ensure t...
...update the script and template - remove not working modules - upgrade shops to the new version - check operation and function - check product cards for fast loading - implement redis Important: url structures must not change due to seo and speed of shops. Urgent order Required functions: Test environment / development version Implementation of Prestashop CastomizationsLeoTheme Optimisation of the speed of operation if not suitable min 80% mobile 90% pc check work: scripts inGoogleTagManager theSEO modifications in the old shop status of theCDN server module Translated with (free version) Template / individual design: as it is now
I am looking for a freelancer who can work with collaboratively with the team on a project. The work is related to landing page optimisation and customisation which is developed on Wordpress. The scope of work is mentioned below. 1. Optimize the loading speed of our landing pages to ensure fast and seamless user experiences. 2. Conduct thorough performance audits and implement necessary improvements to enhance website speed. 3. Identify and resolve any responsiveness issues across different devices and screen sizes. 4. Collaborate with our development team to implement best practices for website optimization.
I am looking for a skilled developer who can optimise my WordPress website's load speed, without resorting to shortcuts tactics. My website's current load speed is more than 5 seconds, which is not acceptable. My primary goal for optimisation is to improve user experience and increase search engine ranking. The ideal candidate should have experience in: - WordPress website optimisation - Implementing performance-enhancing techniques such as caching, minification, and image compression - Using tools like GTmetrix and Google PageSpeed Insights to identify and fix issues - Working with plugins and themes to ensure they don't negatively affect load speed If you have a proven track record of improving website load speed and can deliver measurable results within a ...
I want a VBA function called IsPrime(x) that returns true, if x is a prime.
