Advanced excel macros vba jobs
...Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets and efficiently use all its functionalities. - Experience with dynamic drop-downs: You must have worked with dynamic drop-down creation and manipulation before. - Detail oriented: Attention to minute details is important for the success of this project to ensure the correct values populate the drop-do...
As a client, I need a skilled software developer to design a high-functioning calculator. This should be able to solve linear equations, quadratic equations and provide additional capabilities. It should include the following features: - Linear equation solving - Quadratic equation solving - Trigonometric function capabilities - Exponential function calculations On top of these functionalities, this project requires the calculator's design to be visually appealing. It should offer a colorful and attractive interface which can engage users. Applicants possessing a good sense of aesthetic design along with solid mathematical knowledge would be ideal for this undertaking. Please reach out if you have the relevant skills and experience to execute this project competently.
I'm looking for an experienced Python developer to critically analyze and enhance the efficiency of an existing Py... - Faster execution time - Ability to deliver more accurate results 2. User Flow Improvement: - Enhanced user interface for better interaction - Smoother transitions between functions - Clearer error messages to ease the debugging process 3. Additional Capability: - Incorporate built-in data visualization features to the code. Ideal skills and experience for this job include advanced Python programming, proficiency in data analysis and visualization libraries, and a solid understanding of user interface design principles. Your ability to fine-tune the system for enhanced performance while maintaining code readability will be key to the success o...
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...
I am looking to enhance our existing Salesforce Journey Builder with advanced features such as email automation, personalized messaging, and customer journey mapping. The system will primarily target Business-to-Consumer (B2C) audience. The successful freelancer should have proven experience in Salesforce CRM integration with Journey Builder. Where possible, the freelancer should: - Enhance the email automation system for effciency - Develop personalized messaging to engage our consumer base - Implement customer journey mapping features to better understand our users’ experiences Skills and Experience needed: - Experience working with Salesforce Journey Builder - Expertise in CRM integration - Understanding of both the email automation processes and personalised messaging...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard...
...developer to create a robust ads manager for my website. This tool will be vital in scheduling and placing ads, as well as assessing their performance using advanced reports. Key Features: - **Ad Placement and Scheduling:** - The primary function of the ads manager will be to place and schedule ads on my website without any hitches. This should be user-friendly and efficient. User Authentication: - **Social Media Login:** - I'd prefer user authentication to be through social media login, making it convenient for users to access the ads manager without the need for remembering yet another set of login details. Reporting and Analytics: - **Advanced Level:** - The reporting and analytics generated by this tool should be comprehensive and insightful. It should be...
Please Sign Up or Login to see details.
...clients to our services. Key tasks are as follows: 1. Concept Development: Conceptualize and storyboard a compelling 30-second ad that conveys our services effectively. 2. Production: Filming and directing the ad utilizing professional equipment and techniques for high-quality output. 3. Post-Production: Editing the video for clarity, brevity, and impact. Ideal skills and experience: - Advanced knowledge in videography and professional-quality equipment. - Proven experience in developing and producing live-action promotional videos. - Deep understanding of certification body industry. - Proven ability to create engaging, sales-driven content for marketing purposes. The successful freelancer should be able to showcase a portfolio containing similar previous projects. Co...
...feature within Copilot Studio to enable users to quickly find relevant code snippets, documentation, and resources across projects. Key Requirements: • Intuitive search interface accessible from any section of Copilot Studio. • Fast and accurate search results based on keywords, tags, or filters. • Integration with code repositories, documentation libraries, and external resources. • Support for advanced search features such as autocomplete, filtering, and sorting. 3. In-App Communications with Actions: Objective: Facilitate seamless communication and collaboration among Copilot Studio users by integrating in-app messaging with actionable features. Key Requirements: • In-app messaging functionality allowing users to communicate with team members or collab...
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...
I'm seeking a consecutive in...USCIS asylum interviews, for an asylum interview in Miami, FL at the USCIS Asylum Office (1501 Biscayne Blvd, Suite 300, Miami FL 33132) on 7 June 2024 at 10:00. Ideal candidates will possess the following qualifications: - High-level proficiency in both English and Spanish. - Previous experience interpreting consecutively. - Ability to be physically present at the event. Please note that advanced level experience with asylum interview is not mandatory (since the most important skill is the ability to interpret fluently between English and Spanish), but it is definitely an added advantage since USCIS has its own interpreters listening in for accuracy and will not hesitate to interrupt as many times as it is necessary to correct any inaccurate ...
I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...
...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...
I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and ma...
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of data min...
...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level...
I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. Note: I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills to effectively assess the website's current performance and make data-...
Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.
...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Ex...
I'm seeking an experienced MATLAB expert to assist with an important optimization project. Your role will involve leveraging your proficiency in MATLAB to optimize a mechanical system. The main goal of this project is to achieve the best possible performance of the mechanical system through your advanced MATLAB skills. Key responsibilities that the ideal candidate will handle include: - Utilize MATLAB to optimize a complex mechanical system - Implement advanced algorithms for system enhancement - Ensure the system is running optimally through your expertise The ideal freelancer for this role should have a strong background in: - Mechanical Engineering - MATLAB - Optimization techniques - Prior experience in similar projects would be a huge plus If you're confi...
I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct matching of SKUs an...
...out and provide a seamless experience to users. - Advanced filtering options: I need advanced filtering options implemented on the website to simplify the shopping experience for my visitors. - Single product page customization: The position of product attributes information needs to be altered. I am not looking for a simple color change or layout adjustment, but a more advanced customization. The ideal candidate should possess the following skills and experience: - Extensive experience in WordPress website development, especially with affiliate marketing sites. - Proficiency in customizing themes and plugins, particularly the Rehub theme. - Strong design skills to create a unique product grid and filter. - Experience in implementing advanced filtering opt...
I am in need of a skilled professional with expertise in CrewAI, Langchain, and Langraph to help me implement an advanced workflow automation system. This project involves integrating autonomous agents into the workflow and implementing CrewAI for an enhanced automation experience. Key Project Details: - This project focuses on increasing efficiency through workflow automation. - The integration of autonomous agents into the workflow will allow for a more seamless and productive system. - Utilizing CrewAI will further optimize the automation process. Ideal Skills and Experience: - Proficiency in CrewAI, Langchain, and Langraph is a must. - Previous experience in implementing workflow automation systems and integrating autonomous agents would be highly beneficial. - A track reco...
I need a proficient data scraper to help in generating Instagram leads. The focus will be on the extraction of Instagram usernames from the followers of a specific account, which I will provide. The successful freelancer should demonstrate advanced web scraping skills with a track record of similar projects. Attention to detail, ensuring accuracy, and maintaining a high level of confidentiality are desired traits essential for this project. Key responsibilities: - Scraping Instagram usernames - Ensuring high data accuracy - Ensure no duplication of leads Ideal Skills: - Web Scraping - Data Mining - Instagram API - Strong Attention to Detail - A strong understanding of privacy and confidentiality principles.
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora
I am looking to develop a Variable Message Sign (VMS) software. The software should be: - Compatible with Windows - Able to facilitate message scheduling and display - Support remote management and control - Allow for advanced message customization - This SAAS (Software As a Service) based Software will be display a content publishing management system for PC, which is installed in the Windows operating system and allows editing solutions and playing the solutions on LCD or LED displays. - The software will be SAAS Based, On which multiple clients will be added, and the APIs of the device sold will be integrated into the Software. - This software will have a variety of media: you can add general windows, cut-to-display windows, Office documents, images, videos, GIFs, text, colo...
...be a U.S. Citizen Minimum 5-10 years experience Possess a solid understanding of object-oriented software Ability to learn desktop software development or web development technologies, tools and methodologies Possess a solid understanding of applicable development platforms such as Microsoft Stack or AWS Knowledge of building applications and user interfaces (e.g. Javascript, HTML/CSS, XML, C#, VBA and VB.NET) and/or databases (e.g. SQL) is desirable Proficient in all MS Office applications Demonstrated ability to creatively solve technical challenges Possess excellent communication and collaboration skills Salary Range: $98,000 - $125,000/Year, DOE Education A bachelor’s degree in computer science (or other relevant concentration) required. An additional three years of...
For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.
...**Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commercial Platforms (Optional for Initial Development)**: - **8th Wall**: - Features: Advanced AR tools - Plan: Free Starter plan available ### Implementation Considerations: - **Skill Set**: Proficiency in JavaScript, familiarity with WebXR and WebRTC standards. - **Development Effort**: While open-source solutions like , MindAR, and might require more initial development effort, they provide a cost-effective way to build WebAR experiences without recurring costs
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...
I am currently seeking a skilled and experienced C# developer with expertise in the .NET framework. The primary task at hand is to implement advanced background job features within the project, with a specific focus on Asynchronous Processing and Queue Management. Key Deliverables: - Implement Asynchronous Processing: The developer should be able to design and implement a system where tasks can be processed concurrently, allowing for better performance and resource utilization. - Implement Queue Management: The project requires a developer who can set up a robust queue management system, ensuring tasks are executed in the correct order and at the right time. Specific Requirements: - Maximum Queue Size: The system needs to be designed with scalability in mind. You should be able ...
...Qualifications: College degree in Information Technology or Computer Science related fields 3+ years of successful experience in a similar role with similar responsibilities 3+ years of experience supporting systems and related systems. 3+ years of experience in developing .NET MVC applications. Proficiency in C# SQL Server database and T-SQL code experience Knowledge of Persistence frameworks Advanced knowledge of HTML, CSS, and JavaScript. Knowledge of REST APIs Experience with Version Control systems (Git, SVN, etc.) Preferred Qualifications: Experience or familiarity with Content Management Systems Experience with Continuous Integration tools Familiarity with Python Only US Candidates can apply!...
I'm looking for a skilled app developer to create an exciting and engaging Augmented Reality (AR) application, specifically designed for iOS and Android platforms. Key Requirements: ...display and interact with objects in real-time. - User Engagement: The application should be designed to engage users with technology and streamline manual processes. Ideal Skills: - Proficiency in AR development for both iOS and Android - Experience with developing engaging and interactive applications - Strong understanding of user-friendly design and interface - Ability to incorporate advanced AR features into the application This project is ideal for a developer with a passion for immersive technology and a track record of successful AR applications. Looking forward to seeing ...
Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...
I am seeking an experienced developer or team to create and integrate an advanced automated options trading bot into my Demat account via API. This project will involve the development of a bot that utilizes both predetermined trading signals and artificial intelligence to adapt to market conditions. The successful candidate will work closely with me to ensure the bot operates within the parameters of my trading strategy while maximizing efficiency and profitability. Key aspects of the project include: - Understanding the intricacies of options trading and the specific requirements of my strategy. - Developing a robust and secure bot that can perform high-frequency trades with precision. - Implementing machine learning algorithms to enable the bot to learn from market patterns and ...
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
Company Name: Overview: is a pioneering technology company specializing in delivering cutting-edge AI solutions to businesses across various industries. we are committed to harnessing the power of artificial intelligence to drive innovation, optimize processes, and create value for our clients. Mission: Our mission at is to empower organizations by integrating advanced AI technologies into their operations, enabling them to make data-driven decisions, boost productivity, and stay ahead in the competitive market. Our Services: At , we offer a comprehensive range of AI services tailored to meet the unique needs of our clients. Our services include: ∙AI Consulting: We provide expert guidance and strategic insights to help businesses understand
I'm in need of an intermediate level Java trainer who would help uplift my skills in this area. The selected freelancer must be proficient in: - Core Java - Java frameworks including, but not limited to, Spring and Hibernate - Advanced Java such as J2EE, JSP, Servlets In-person sessions are preferred, so facilitators who can deliver on-site training will be much appreciated. Prior experience in delivering Java-based tech training programs would be great. The perfect freelancer for this role is one who possesses precise technical knowledge, patience, as well as excellent teaching skills.
'Alvo' means 'Target' in Portuguese. Business overview: Alvo is an expert sales prospecting services. We connect our customers with the right prospects, helping them to grow their pipeline and close deals faster. What We Do: Identify Ideal Prospects: Our team uses advanced data analytics to pinpoint the perfect leads for your business. Engage Effectively: We craft personalised outreach email campaigns that resonate with your target audience. Logo colours: Please look at logos with orange, white and maybe green. Logo feeling: clean, modern, technology and if possible a design that makes you think of a target or dart board.
I require an experienced business plan writer for my tech start-up. Our primary goal is not only to guide operations but most importantly, secure funding. - First, we operate in the technology industry, giving the task an innovative feel. So, a flair for crafting compelling na...Secondly, we're at the start-up stage. Consequently, the potential for growth and scalability is immense. Candidates should be able to effectively communicate this potential onto paper. - Lastly, I would like to attract investors. Your experience in pitching businesses to investors, understanding their expectations and key concerns, will be highly appreciated. Skills ideal for this job would be advanced understanding of the technology industry, experience in start-up development, and strategic fina...
We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks
...brochures, flyers, whitepapers, and company profiles in the IT or technology sector. Additional Requirement: We only accept freelancers who use the Freelancer.com Desktop App to track their time while working on our projects. This tool is essential for maintaining transparency and ensuring project tracking aligns with our billing procedures. Emphasis on Skills and Capabilities: You should possess advanced knowledge in the mentioned software and a deep understanding of marketing and effective project management. Your creativity and eye for design are also of great importance. Request for Competency Confirmation: Can you please confirm that you can meet the above requirements, especially the creation of unique designs without using standard templates from Envato Elements, and th...
I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.
I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.
