Excel vba lookup script jobs
Looking for an experienced proofreader to review my film script. It’s approximately 120 pages and has been through several edits already. Your focus should be on spotting errors, maintaining consistent tone, and polishing the dialogue and structure where necessary. Familiarity with screenwriting formats (like Final Draft or similar tools), attention to detail, and strong communication skills are crucial. I’m on a tight budget as a senior on Social Security, so affordability without compromising quality is key.
I need to convert tables from a MS Word file into a MS Excel file. The project involves: - Transferring all tables from the Word file into one Excel sheet - Performing basic cleanup to remove empty rows and columns Ideal candidate should be proficient in MS Excel, have a keen eye for detail and able to perform basic data cleanup tasks. Experience with data entry and Excel is highly preferred.
...elementor - ideally you are designer background with strong skills in WordPress - Strong understanding of e-commerce best practices - Ability to create engaging website content - Familiarity with PayPal integration for e-commerce sites Please note, the site must be fully prepared and content ready for launch. Extra info: It's just 18 products. Need to remove background from images and there is excel file with detail on that product. Rest of content you need AI assistance to generate data that is relevant. This job will suit someone who is to take ownership and launch site like their own and intend to continue to work on it in regular engagement after launch rather than a one of task. In your application, please send me link of 1-2 WooCommerce sites you have done in wome...
I need someone experienced with WordPress and product uploads to help me upload two Excel sheets of products to my site. - One sheet contains over 3,000 products with compressed images. - The other has about 40,000 products without compressed images. I would like to know if I can upload the compressed images later in bulk after the 40,000 products are uploaded. Please let me know if this is within your capabilities. Ideal candidates for this project should have: - Proven experience in WordPress product uploads - Ability to handle large data sets - Understanding of bulk image uploads - Excellent attention to detail to ensure every product is listed correctly. I have attached the file. Please import the products on your website to show me and apply for the job.
I'm seeking assistance with comprehensive data analysis in Excel, as well as generating reports and creating formulas. The job also involves sending multiple email attachments via Gmail. Ideal skills and experience for the job: - Expert level proficiency in Excel, particularly in data analysis, formula creation, and report generation. - Experience in managing and sending multiple email attachments through Gmail. - Strong attention to detail and ability to work efficiently.
**"Set Cookies from JSON File and Refresh Webpage Content Dynamically"** --- ### **Project Overview** The objective of this project is to create a script or program that loads a set of cookies from a JSON file, applies them to a specified website, and refreshes the webpage to reflect the updated cookies. This tool will allow users to simulate custom sessions or user states for testing, automation, or development purposes. --- ### **Project Requirements** 1. **Load Cookies from JSON** - The JSON file should contain an array of cookies with standard properties (e.g., `name`, `value`, `domain`, `path`, `expiry`, etc.). - Validate the structure of the JSON file before processing. 2. **Set Cookies for the Target Website** - Programmatically set cookies ...
I'm seeking a skilled data entry professional to assist with cleaning and formatting my Excel spreadsheets. The primary task will be identifying and removing duplicates from the data sets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data cleaning and formatting Please bid only if you can deliver quality work promptly. Thank you!
i need a website scraped in the craft area the headings are Name Description sku price image url Diamensions Weright isbn format page url pages Autoir in excel format url script built
...and export them automatically to Google Sheets, including carrier details, costs, and estimated delivery times in dedicated cells. Create shipping order: Generate the shipping order directly in Sendcloud using the data provided in the spreadsheet. Key Requirements: Strong knowledge of REST APIs and the ability to work with API documentation (specifically Sendcloud). Experience with Google Apps Script or similar tools to automate Google Sheets. Ability to implement conditional logic, such as applying percentage markups to calculated prices. Familiarity with the shipping workflow: rate calculations, listing options, and creating orders. Attention to detail and thorough testing to ensure smooth and reliable automation. Primary Tasks: Configure API calls for required functions (rat...
I need an expert in Pine Script to assist with my TradingView project. Key Tasks: - Merging two indicators: CPR and Algo Trade - Adding trade entries based on the merged indicators Ideal Skills: - Proficiency in Pine Script - Experience with TradingView - Understanding of CPR and Algo Trade indicators - Ability to implement trading strategies based on indicators Please get in touch if you have the relevant experience and skills.
I need a skilled programmer experienced in Python or Node.js, who can create a script for me that will parse Google SERP data through our rotating proxy provider. The script needs to extract data points such as Titles and URLs, Meta descriptions, and Search result rankings. Key Requirements: - The script should run daily as an API enpoint which will get settings for scraping (google domain, language code, country code, proxy settings, keywords) - The output data needs to be in JSON format Since Google has recently updated its system to block bots/scrapers, the script needs to effectively navigate through this challenge. Experience with web scraping, working with proxies and understanding of Google SERP is a plus. Please apply if you have the relevant skills a...
I need a specific excel sheet made up for me. Instructions for excel sheet: First, there should be cell A designated for company name. Cell B will be "customer cost" where the "single letter" value will be entered (see values/definitions below). Cell C will be "number of licenses" and will be a numerical value input by the user. Cell D will be the product of cell B multiplied by cell C. cell B multiplied by cell C equals cell D (p) * 10 = 100 (p) = 10 (see values/definitions below) cell A = MOCK company A cell B = (p) cell C = 10 (numerical value input by user) cell D = 100 Then, cell E will be "MSP cost" and will be the "double letter" value entered. Cell F will be the product of cell C multiplied by cell E. cell E mul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I need a detailed proofreading of my adventure game script. The main focus areas will be the character dialogue and the overall story flow and coherence of the script.
I'm in need of an Excel expert to assist me with a data transfer task. This involves pulling information from one spreadsheet and adding it to a column in another. Key Tasks: - Transfer of text data from one spreadsheet to another - Matching of data based on an exact match in a single column - Formatting of some data during the transfer The data in the spreadsheets is a mix of both specific categories and plain text columns, and there are more than 1000 rows that need to be transferred. Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks - Ability to perform basic data formatting and transformation
I'm looking for a script that can help me manage my Snapchat friends on my iOS device. This script should automatically remove friends who are inactive. Key Features: - The script should only work on iOS. - It should remove friends who are identified as inactive. This includes friends who have not sent me any recent stories, have not sent me any recent messages, and have not been active for a set period. Ideal Skills: - Proficient in iOS scripting. - Familiar with Snapchat's friend and story interface. - Experience with creating scripts for social media management. Please provide examples of similar projects you've completed in your bid.
I'm looking for a freelancer who can compile a comprehensive list of stock codes for all companies per year from the specified website - A spreadsheet should be created with a tab for each yea...from Yahoo finance. For example, where the company name is Apple, I would expect the code AAPL to be returned. The specific requirements are: - The stock codes should be taken from Yahoo Finance - The data should only include the stock codes, not historical data or current status. - The final deliverable should be in an Excel file. Ideal skills and experience for the job: - Familiarity with stock exchanges and their coding systems. - Proficiency in data compilation and Excel. - Attention to detail for ensuring accuracy of stock codes.
I'm seeking assistance to extract data from a conference website. The task involves gathering information on all attendees and their respective companies. Key Requirements: - Extract a list of attendees and their in...attendance (one column: Company). The data needs to be extracted from a publicly accessible section of the conference website. The task needs to be completed before noon EST on January 21st. I will make a decision on whom to select by 9:00pm EST on January 19th. Ideal Candidate: - Previous experience with data extraction and web scraping is preferred. - Proficient in using tools like Python, Excel, or any other data extraction software. - Attention to detail to ensure accurate data collection. Successful execution of this project may lead to future work on a...
I have an Excel database consisting of 100,000 records of loan requests along with their acceptance status. I need a freelancer with strong expertise in Python, data manipulation and AI to develop an AI model that will evaluate new loan requests and predict their approval status based on the training from this dataset. Key aspects of the project: - Data Preprocessing: The data will require normalization, handling of missing values, and feature extraction. - Model Development: Using Python, you'll build an AI model to train on the database. - Prediction: The model will assess new loan requests and indicate if they should be accepted or rejected. The ideal candidate will have extensive experience with AI model development, and will be proficient in Python, and data manipulati...
I'm looking for an AppleScript expert who can help me automate the printing of a PDF document from my local storage. The project involves writing a script that will send the document to my printer when executed. Ideal Skills: - Proficiency in AppleScript - Experience with automating print commands - Familiarity with Mac OS Please provide examples of similar projects you've completed.
I'm looking for an expert in Excel to help me create a special spreadsheet that will collect and organize vital customer information. This project will involve detailed manual data entry. Key Requirements: - Collecting customer contact details (name, phone, email) and purchase history. - Organizing this data in an efficient and easy to understand manner in Excel. Ideal Skills: - Proficiency in Microsoft Excel. - Excellent attention to detail for data accuracy. - Experience with data entry and data organization. - Good understanding of customer data and purchase history. Please note, the data will need to be entered manually, so patience and diligence are essential for this task.
I'm looking for a developer who can create a script or software that automatically downloads product listings from eBay and uploads them to my Shopify store. Key Requirements: - The software should be able to scrape the product title and description, images and prices, and stock availability from a specified eBay store URL. - The software should check the daily price and stock on eBay for the items that I have listed on my Shopify store. - It should send me notifications for price changes. - It should also send a notification for stock changes, rather than automatically marking items as out of stock or removing them from the Shopify store. Ideal Skills: - Proficient in web scraping and API integration. - Experienced in Shopify development. - Knowledgeable in eBay's li...
Modifying existing pine scrip codes
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. call required before offering job to go over important details of the job NO EXCUSES POOR QUALITY WORK WILL NOT BE PAID ANY CRYING OR ABUSE WILL NOT BE TOLERATED ALL I AM AFTER IS FAST HIGH QUALITY WORK FROM A PROFESSIONAL. IF U CANT DO IT DONT APPLY. REMEMBER IM HIRING YOU COS I DONT HAVE THE TIME TO DO IT MYSELF. I CAN DO THESE IN MAX 3 HOURS PER SHEET. 1 SHEET ON AVERAGE SHOULD TAKE 3 HOURS. LATE WORK WILL BE PAID AT A REDUCED RATE AND ALSO ANY MISTAKES MUST BE ELEMENTARY. WORK MUST BE ALMOST PERFECT ON FIRST DRAFT AND PERFECT ON SECOND DRAFT OR PAY WILL BE REDUCED. DO NOT DEMAND PAY FOR WORK FULL OF ERRORS IF I SAY THE WORK IS POOR T...
I'm looking to build a comprehensive e-commerce site, ideally using a React.js Backend with a Tailwind front end, or PHP/Laravel. The site needs to have several key features including: - Shopping functionality - UPI payment integration - WhatsApp API integration - Ability to upload products via CSV/Excel sheets - User recommendation form connected through WhatsApp API for scheduling meetings I would prefer MySQL as the database for this project. The admin panel should specifically allow me to manage product inventory. User accounts will use standard email/password, social login authentication. New freelancers are welcome to bid, but you need to demonstrate your skills or provide a detailed plan on how you intend to execute this project. Please share any relevant projects yo...
I'm in need of a comprehensive database containing contact information for Real Estate Professionals (Agents and Brokers) associated with @properties, covering all cities they operate in. The data should be structured in an Excel spreadsheet and must include: - Name - Address - City - Email (Any email addresses available) - Phone number - Company name Key Requirements: - I'm looking for as many contacts as possible, ideally in the thousands. - The email addresses do not need to be verified, but any available email is acceptable. - Prior to engaging in further conversation, I would like to see at least 10 examples of the data you've gathered. Please note that this task may be straightforward for those experienced in data scraping. A successful completion of this pro...
I'm seeking a corporate and professional style promo video for a product targeting B2B clients. The video should succinctly showcase the product's features and benefits in a way that resonates with business clients. Ideal skills for this project include: - Video production and editing - Script writing and storyboarding - Understanding of corporate communication Experience with creating B2B product videos is a definite advantage. Please provide examples of similar work in your portfolio.
I'm looking for a talented Pine Script developer who can merge two TradingView indicators for me - the Pivot Sweep and the Fair Value Gap, i already have the source code so only need to modify it. The project involves: - Combining the two indicators into one cohesive tool - Implementing a variety of alert features based on: - Price crossing indicator line - Specific signal generation - Custom conditions being met. The ideal candidate should have substantial experience with Pine Script and a deep understanding of TradingView indicators. They should also be able to create a reliable alert system that accurately reflects the specified conditions.
I have a PHP script that needs urgent work. The project involves integrating a third-party marketing API into the PHP script. Ideal Skills: - Expert in PHP script development - Experience with third-party API integration, particularly marketing APIs Please only bid if you can start working immediately. Thank you.
I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.
I'm seeking an expert v...voiceover artist to create a professional tutorial video demonstrating our sign-up process. This 30-45 seconds video, intended for both our customers and sales agents, will guide viewers on how to complete our sign-up link. Key Requirements: - The video should not just capture the screen but also include a voiceover (VO) in a formal and professional tone, ideally in an American accent. - I have a script that can assist, but I also expect your expertise in making the video engaging and clear. Branding: - The video will need to incorporate our company logo, brand colors, and brand fonts. Ideal skills for this project include video production, screen recording, voiceover, and understanding of brand consistency. Experience creating tutorial or promo vi...
I'm seeking an experienced Pine Script developer who can create a custom alert for me on TradingView. Key Requirements: - The alert should be based on a custom condition that I will provide. - The developer should be able to create the alert from an existing custom indicator and report. Ideal Skills: - Proficiency in Pine Script and TradingView. - Experience with developing custom conditions for alerts. - Ability to translate complex trading concepts into functional scripts. Please provide examples of similar projects you've completed in the past.
I'm looking for a proficient web developer to create a user-friendly, web-based portal for project collaboration, which will replace my current cumbersome Excel sheet system. The primary goal is to streamline the process, enhance collaboration and make the project management more efficient. Key Requirements: - The portal should replicate the collaboration and comments features from my Excel sheets. This involves creating a space for team members and clients to leave feedback, ask questions and contribute to the project. - Incorporate task assignment and tracking capabilities. I want to be able to delegate tasks and monitor their progress within the portal. - Implement an admin and user role access control system. As the project owner, I need to have full control over th...
Hi everyone! I’m working on a project for the Medical Education Technology Center (MITC), focusing on analyzing simulation events scheduled from 01.08.2023 to 31.01.2025. We’re using the “SimPlan” calendar to manage events, but I need help organizing a...instructor and venue utilization, including peak hours and percentage of usage. Understand student participation across different events and semesters. Compare growth in event frequency and duration between Fall 2023 and Fall 2024. Identify trends like most/least attended skill groups and time spent on events with keywords (e.g., “excursion,” “first aid”). If you have expertise in data analysis, Excel, or tools that can help process and visualize this type of information efficiently, I...
I'm looking for an experienced Pine Script programmer to create a version 6 code for TradingView. This code will implement the following: 1. Draw a Simple Moving Average (SMA) with a period of 20 on the main chart (overlay = true). 2. Draw an Exponential Moving Average (EMA) with a period of 200 on the main chart (overlay = true). 3. Draw two Exponential Moving Averages (EMA), one with a period of 5 and another with a period of 25, below the main chart (overlay = false). 4. Draw Tenkan-sen and Kijun-sen on a separate pane (overlay = false). 5. Draw ADX, +DI and -DI on a separate pane (overlay = false) with a horizontal line at 20. 6. Draw RSI(9) with horizontal line at 50. Draw an upward arrow if all the below conditions were fulfilled: 1. Previous closing price candle > Pre...
I'm looking for a Python expert to help me create an automation script that scrapes news articles from the US scheduler. Requirements: - Experience in Python and web scraping - Ability to work with scheduling systems - Understanding of news article structure and scraping techniques Please reach out if you can assist with this project.
I'm in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes D...in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriately sorted into separate columns for positive and negative amounts. Ideal Skills: - Proficiency in Excel is a must. - Previous experience with QuickBooks and CSV file formatting is highly preferred. - Attention to detail to ensure all data...
I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only...
I need a professional to convert my current Pine Script, which utilizes candlestick patterns, into a NinjaTrader 8 script. The new script should automate trading based on a trend-following strategy. Key Requirements: - Convert existing Pine Script to NinjaTrader 8 script - Implement automated trading functionality - Incorporate a trend-following strategy Ideal Skills: - Proficient in Pine Script and NinjaTrader 8 scripting - Strong understanding of candlestick patterns - Experience with trend-following strategies and automated trading I have so many scripts to convert i just would like to start from one to check your expertise.
I'm looking for a talented Python programmer who can craft a script for me, tailored to my specific vision, to automate trading in my Fyers and AngleOne demat accounts. Key Requirements: - The script needs to handle automated trading, executing trades on its own based on pre-defined parameters. - The trading strategy to be implemented is mean reversion. This involves identifying and capitalising on price movements reverting to the mean. - The script will be used to trade options specifically. Ideal Skills: - Proficiency in Python programming, with experience creating trading scripts. - Understanding of mean reversion strategy and its application in options trading. - Familiarity with Fyers and AngleOne trading platforms is a plus. Please provide examples of s...
I'm seeking a Python expert to help me troubleshoot a script that's encountering logical errors. The bugs are pervasive throughout the code, not confined to specific sections. Ideal skills and experience for the job: - Proficient in Python - Experienced in debugging and troubleshooting - Able to identify and fix logical errors - Capable of enhancing code functionality
I'm seeking a comprehensive list of 70 rent-a-car companies in Dubai, specifically their CEO and Managing Director contact details. The final deliverable should be an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data collection and research - Experience in creating comprehensive, accurate spreadsheets - Understanding of corporate hierarchies, particularly in the transport and rental sectors Please ensure the information is current and accurate, as this will be crucial for my project. Thank you.
I'm experiencing an issue with a combobox in my MS Access database. It's directly bound t...experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am no...
We are seeking a skilled freelancer to install and configure the Whoxa Chat Script, similar to WhatsApp application with support for web, iOS, and Android platforms. This project focuses on deploying the provided ready-made script rather than developing a custom solution. The installation will include setting up the website, mobile apps, and admin panel. What You’ll Do: Script Installation: -Install and configure the Flutter-based iOS and Android apps. -Set up the Node.js backend with for real-time chat functionality. -Install the React.js admin panel for easy management. Basic Customization: -Apply our branding (e.g., logos, colors). -Make minor adjustments to settings or configurations, as needed. Testing: -Ensure the website and apps are functioning smoot...
I'm seeking a skilled and creative 2D animator with a knack for cartoon-style animation. The project involves producing a series of door-themed videos that will be used for marketing purposes. Key Requirements: - Experience in creating engaging, high-quality cartoon-style 2D animations. - Ability to transform a script into a visual narrative, as I only have a script and not a complete storyboard. - Understanding of marketing principles and ability to tailor content to a target audience. Having a strong portfolio demonstrating previous work in a similar vein will be a significant advantage. The ideal freelancer will be able to deliver a product that is not only visually appealing, but also effective in conveying a marketing message. Please share your portfolio also
I'm looking for a capable developer to create a JavaScript script that automates the connection of various payment tools to Facebook, reducing the need for manual linking. I have a similar tool that can be of great assistance, as well as audio recordings that can guide you. The better the script, the more efficient the process will be. Key requirements: - Expertise in JavaScript. - Experience with Facebook's payment tools and APIs is beneficial. - Ability to work with provided resources to maximize efficiency.
...Astrodynamics • Orbital mechanics (e.g., transfer orbits and escape velocity). • Tidal forces and interactions between celestial bodies. 4. Computer Science and Data Analysis (Optional but Beneficial) For handling complex data and simulations, some expertise in programming and computational tools is valuable. • Python or MATLAB • For analyzing star charts, light curves, and celestial simulations. • Excel or Data Visualization Tools • Useful for plotting and analyzing observational data. 5. Problem-Solving and Test-Taking Skills In addition to mastering these subjects, experts should: • Practice solving past USAAAO and international Olympiad problems. • Develop speed and accuracy in solving MCQ and computational problems. •...
I'm seeking a dedicated individual to filter and provide me a list of 2000 Instagram influencers. The goal is to identify suitable partners for a drop shipping venture who can make a promotional video of a product. Key Requirements: - Influencer...who can make a promotional video of a product. Key Requirements: - Influencers should have between 1,000 followers - The primary content category of these influencers should be related to drop-shipping. An ideal candidate for this project would be someone with a keen understanding of the drop shipping industry and experience in influencer marketing and expert in filling and filtering data in Excel. Skills in social media analysis and data filtering will be highly beneficial. Please be prepared to demonstrate your ability to meet ...
This logo for "Sewing and Solitude" embodies a minimalist yet elegant design, blending creativity with tranquility. It features: A Zen-inspired feminine face outline, symbolizing calm and creativity. A lotus f...minimalist yet elegant design, blending creativity with tranquility. It features: A Zen-inspired feminine face outline, symbolizing calm and creativity. A lotus flower, representing serenity and balance. Sewing needles and threads, showcasing the core theme of the business—handmade bags and quilted products. A dress sketch, adding a touch of sophistication and style. Typography: A combination of script fonts for “Sewing” and “Solitude,” offering elegance and harmony. Color Palette: A soft beige background with black, coral, and subtl...