Excel vba lookup scriptJobs

...looking for a professional who can create a compelling Social Media Flyer, a persuasive PowerPoint presentation, and a clear recruiter script aimed at attracting qualified truck drivers to our logistics network. 1. **Social Media Flyer**: The flyer needs to be visually appealing and optimized for LinkedIn. It should highlight: - The job benefits - The application process - Our company values 2. **PowerPoint Presentation**: This should be a concise and persuasive presentation that outlines the benefits, requirements, and process for joining our team. The presentation will be shared with potential drivers via email or text. 3. **Recruiter Script**: The script should be professional, engaging, and clear, designed for our recruiters to use during phone calls...

I'm seeking a professional who can set up a system that fully automates the updating of my investment portfolio Excel sheet with the daily NAV values from a specific website. Currently, I access the NAV values through manual browsing. This project requires: - Creating an automation system that fetches the daily NAV values from the website without any manual intervention on my part. - Updating my Excel sheet with the fetched data. The ideal freelancer for this project should have extensive experience with web scraping, Excel automation and ideally has worked with investment portfolio data before. The aim is to have a seamless process where my Excel sheet is always up-to-date with the latest NAV values. Please note that the specific format of the daily NAV...

...employee task follow-up system using Google Sheets and Google Apps Script. This system should enable real-time input from my employees on administrative tasks that they have completed or are still pending. The system should also send auto reminders for pending tasks, and provide a daily summary report of what's happening. Key Features: - Task Completion Tracking: Employees should be able to log completed tasks in real-time. - Pending Task Reminders: The system should send pop-up notifications for tasks that are still pending. - Daily Summary Reports: A comprehensive daily report should be generated to summarize task progress. The ideal freelancer for this project should have extensive experience with Google Sheets and Google Apps Script. Understanding of task manage...

I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, implied volatility and total open interest. You need to ...

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. NEED TO CALL AND DISCUSS SOME DETAILS BEFORE STARTING WORK

### Description: I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. ...

I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, implied volatility and total open interest. You need to ...

I have 100s of bounced emails in my inbox The rejected email or emails are in the BODY of each bounced email report usually only 1 bounced email address is in the body but sometimes it can be 2 or more. i need a script or a quick way to extract ALL the rejected emails from the BODY of all the bounced emails at the moment i am doing ONE BY ONE which takes an eternity HELP! NO TIME WASTERS ITS A VERY TECHNICAL JOB AND MUST BE DONE RIGHT

I'm seeking a finance expert who can create a clear financial model with valuation in excel, focusing on our business, Flyer Eats and Swiss Cafe. This valuation is primarily for investment purposes, using the Discounted Cash Flow (DCF) method. I have historical financial data available for the past 3 years. Ideal skills and experience for the job: - Proficiency in financial modeling and valuation - Expertise in Excel - Familiarity with DCF method - Background in assessing businesses for investment purposes - Ability to present financial data clearly and succinctly

I need someone to assist in migrating user data from my online portal account to a CSV/Excel file. Ideal Skills: - Data Migration - Proficient in handling CSV/Excel files - Familiarity with online portals Experience: - Prior experience in similar data migration projects preferred.

I need assistance with the ORDX file format used in Microvellum CAD software. My goal is to have a script that can generate ORDX files based on the JSON output from my flatpack ordering site. Key Aspects of the Project: - Detailed Documentation: I require comprehensive documentation on the ORDX file format to understand how to work with it. - Script Development: While I'm willing to write the script myself, I would appreciate your help if you could build the script for me or explain the ORDX file format in detail. - Error Handling, Data Validation, Logging: Although I didn't specify these functionalities in the script, I recognize their importance. A well-structured script should incorporate these elements. Ideal Skills and Exper...

I am looking for an experienced Pine Script developer who can help me combine 4 different sets of technical indicators into a single Trading View script that generates trading signals. The signals should be based on the majority agreement of the indicators. (Any 3 should agree to generate buy/sell signals & alert) Specific requirements include: - Combining 4 different sets of indicators (details will be provided) - I have these indicators scripts with me through tradingview. - Signal generation based on the majority agreement of the indicators - Alert generation for buy / Sell -- Ensuring the script is efficient and easy to use Ideal Skills and Experience: - Extensive experience with Pine Script and Trading View - Strong understanding of various technical...

Please note that the Budget is fixed - Need beginner skills users only - budget is as de...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic u...

I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.

I'm looking for a Google Sheets expert to help me automate data entry using checkboxes on a mobile device. Specifically, I need assistance with: - Using checkboxes as buttons for data manipulation (add, delete, edit) on a sheet - Implementing the onEdit function to trigger these actions when checkboxes are edited This project requires a deep understanding of Google Sheets scripting and experience with data entry automation. If you're proficient in creating scripts that can streamline this process for me, I'd love to hear from you!

Ich habe eine PDF mit öffentlichen Einrichtungen und benötige diese als Exceldatei. Im PDF sind diese jedoch nicht in Tabellenform aufgelistet wie benötigt. Diese gehört formatiert, damit die Spalten jeweils sortiert werden können.

I have a Selenium Python script that needs to be upgraded. I require the script to integrate SOCKS proxies that will rotate with every session. Key Requirements: - Implement SOCKS proxies into my existing Selenium Python script. - Ensure that the proxies rotate every session. Ideal Skills and Experience: - Extensive experience with Python and Selenium. - Proven track record of working with SOCKS proxies. - Understanding of session management within Selenium.

...agencies You are required to: - Record a lively and emotional video with selfies lasting 15 to 60 seconds in vertical format - follow a simple script that we will send you. - To be sincere, positive and genuine. - Have a native level of English Requirements: - The video must be shot vertically on a front camera, do not use a tripod - Do not use filters, blurring or editing No skills or experience required, just be yourself! This simple assignment is suitable for all native English speakers who enjoy creative challenges You are required to: - Record a lively and emotional video with selfies lasting 15 to 60 seconds in vertical format - follow a simple script that we will send you. - To be sincere, positive and genuine. - Have a native level of English Requirements: - ...

I need a complete, customizable strategy built using a pine script for TradingView. Step 1: Identify the High and Low of every Closed Candle. Ignore trading the candles that don't break the high nor the low of the previous closed candle. Step 2: Place buy and sell stop orders at the high and low of each qualified closed candle. Step 3: Once price triggers an order, then an adjustable trailing stop loss will need to trail the trade until price takes out the order from the stop loss. Setup the inputs to read ticks. Once the input has been reached, then the adjustable trailing stop loss will need to be moved to 2 ticks above or below breakeven depending on the direction of the trade and follow price at the same rate of 2 ticks the more price goes into profit. Step 4: An ad...

I'm in need of a professional to assist me in preparing financial reports, analyzing expense data, and ultimately improving our financial performance. The reports should be in Excel spreadsheets.

Join the Top 1% of CRO Specialists! Do you excel at turning landing pages into lead-generating machines? Join our high-performing team! Position Overview We seek a results-driven CRO Specialist to optimize landing pages and digital funnels. Use your analytical and creative skills to drive campaign success and collaborate with clients for measurable results. Key Responsibilities Conduct data analysis and A/B testing for CRO strategies Design and implement conversion-focused strategies Collaborate with clients and internal teams for top-tier results Stay updated on the latest CRO trends Qualifications 2+ years in CRO with proven landing page success Strong portfolio showcasing conversion improvements Expertise with CRO tools (Google Optimize, VWO, Optimizely) Data-driven with exc...

I have a PDF file containing text and numbers that needs to be converted into Excel. Ideal skills and experience for this job include: - Proficiency in Excel - Experience in data extraction from PDFs - Exceptional attention to detail - Ability to work efficiently under pressure.

Rahul, Hello! A few months ago, you helped me to convert a Google Docs based spreadsheet ito an Excel format. I now need to use it for another client & want to change the values in the drop-down menu for the strengths/development areas. I was able to unhide the settings tab and update the dropdown menu source but now it causes a run error for our "start" setup function. What is the cost to fix this & also set it up so i can easily make these changes for other clients? Mary

Web scrape Automation: I can scrape multiple pages using Selenium and Python, extract all the data, and seamlessly convert it into an Excel file.

I'm seeking an Excel expert to assist with semi-monthly payroll calculations. Tasks will mainly involve tracking hours, vacation pay and holiday pay. The project has the following components: - Gross pay calculation: Accurately determining pre-tax earnings based on hours worked and other factors. - Tax deductions: Applying the correct tax rates and ensuring compliance with relevant regulations. - Net pay summary: Summarizing post-deduction amounts in a clear, concise manner. Skills and experience in data analysis and financial modelling are a plus, as is familiarity with macros and automation. The ideal candidate will be detail-oriented, reliable, and able to validate data to minimize errors.

Tenho ums sitema proprio utilizando apenas a linguem vba e o banco de dados acces, atualmente emito nfce e nfe atraves do site do sebrae, mas quero automatizar utilizando apenas o vba e o openssl para a assintura digital para conseguir automatizar o processo. entao o que estou tentando fazer éutilizar um modelo de xml , editando os dados e adicionando os dados de mais itens conforme necessario, assinado digitamente atraves do openssl (isso eu ja tenho pronto, ja consegui estrair os dados e as sub que fazem este processo), falta a estruturação do xml e validação junto a asefaz.

I'm in need of a customizable Excel template specifically designed for project management. This template should allow a user to input a project name and its go-live date, and in response, automatically populate all related deadlines, legal references, and resources. Please note, I will populate the actual document with the data, but require a fully functional template with adjustable formulas. Key Requirements: - The template must include deadline formulas that populate fields based on the proximity of the go-live date, taking into account: - The year (i.e., the year prior, odd years, etc.) - The number of days (i.e., 45 days prior to go-live, 60 days prior to go-live, etc.) - The month and/or day of the week (i.e., first Friday in August prior to go-live, second Thursda...

Project Description 1. Read data from Nse Bhav copy excel file 2. Do calculation as an output I need 9-10 columns after calculation 3. I need a code/ Software which I can use in my laptop 4. This code will ready the input file which I will put in a folder 5. Also calculate OI change activity if it getting in creased or decrease. 6. Oi change calculation input data will be in the same file 7. Calculate OI Interpretation

I am looking for a proficient Excel expert to design an Audit Tracker for me. This tracker will manage and monitor up to 50 separate audits. The tool should be capable of tracking both corrective and preventative actions as statistics. It should also present a live stats dashboard that displays the progress of all audits, current outstanding audits, and their respective progress. Key requirements: - The tracker should be able to identify and reflect audit trends for the year as audits are added. - The dashboard should include visuals primarily in the form of bar charts. - Additional information to be displayed on the dashboard includes: audit completion rate, monthly audit trends, and audit compliance scores. Ideal skills for this project: - Advanced Excel skills, including...

...de cálculo de importación desarrollado en PHP. Este sistema calcula el precio de costo de una compra del exterior, considerando múltiples datos como el precio de costo, el flete marítimo, el almacén fiscal, el agente aduanal, el flete interno, entre otros gastos. Los datos se manejan en dos monedas: USD y CRC, y el cálculo final siempre se convierte a CRC. adjunto el mismo calculo en excel un ejemplo en excel puedo dar acceso via AnyDisk, o por FTP Cambios y mejoras requeridas: Edición de facturas Al editar una factura desde la página principal, se abre otra página. En esta sección, se deben realizar las siguientes revisiones: Campo de porcentaje de gasto: Verificar que el cálculo del porcentaj...

I'm looking for a talented voice artist to record the attached 30 second script for a promotional video. Ideal Skills: - Authentic, Enthusiastic Script is attached. Just need voice-over. Length needs to be 28-30 seconds, closer to 30 the better, no more than 30 seconds

Project: Automated Lucky Jet Game Data Analysis & Notification System This project involves developing a Python script to monitor the Lucky Jet game, analyze its data, and send automated Telegram notifications. Key Features: * Data Extraction: The script will extract real-time game data, specifically the multiplier achieved in each round, likely through web scraping. * Data Analysis: The script will continuously monitor the sequence of multipliers. * Trigger: A notification will be sent via Telegram when the multiplier fails to reach 3x for 12 consecutive rounds. * Automation: The script will run continuously or on a schedule with robust error handling and recovery mechanisms. Technical Requirements: * Proficiency in Python with libraries like requests,...

The indicator includes TP levels, dynamic Buy Orders, entry shifts, and SL, coded in Pine Script for TradingView.

I'm seeking a talented logo designer to create a logo for my brand, "Birthday King". o create a similar "Birthday King" glitter-themed design, here’s an analysis and guide: Key Visual Elements: Typography: Two distinct fonts: "Birthday" in a script-style font with flowing, elegant curves. "KING" in a bold, uppercase sans-serif font for emphasis and impact. Crown Motif: A central crown placed above the text, emphasizing royalty. A smaller crown element below the word "KING" for balance. Decorative Elements: Arrows with glitter texture framing the top and bottom of the design. Stars to add symmetry and a festive touch. Glitter Effect: A gold glitter texture applied to all elements for a glamorous and celebratory feel. ...

...information from both platforms in Namibia on a daily basis. The scraped data should be neatly organized in an Excel spreadsheet. Key Requirements: - The scraper should pull data from all relevant sources, including government websites and social media. - Information to be collected includes: the name of the entity or organization, tender advertising date, due date, a clickable link for document download, and contact details. - One of the primary websites to scrape from is: , which mainly hosts government tenders. - The scraper must ensure no tender is overlooked. Ideal Skills and Experience: - Expertise in web scraping and data collection. - Familiarity with Excel and data organization. - Experience in developing scrapers that gather information from both web and socia...

Python Programmer for PayPal to Create a Script To Bypass Captcha Send Verification Code to 200,000 Phone Numbers Daily Create a Script for PayPal The purpose of this script is to write the phone number in the registration field. And bypass the captcha

I need an Excel expert to create monthly reports for my crockery and cutlery inventory. Sales Report: - Should include total revenue. Inventory Report: - Should include sold items and quantities. Sold Items Breakdown: - By category (e.g., crockery, cutlery). The ideal freelancer for this project would have extensive experience in Excel and data analysis, with the ability to create clear, concise reports. Familiarity with inventory management and sales reporting would be a plus.

Graphics and design are two important elements in data visualization and effective communication. Here are some tips for creating good graphics and designs: Chart 1. Choose the right graph type (bar, line, circle, etc.). 2. Use contrasting and harmo...6. Use animation wisely. Design 1. Choose a font that is clear and consistent. 2. Use colors that match the theme. 3. Arrange the composition and free space. 4. Create a simple and intuitive design. 5. Ensure alignment of visual elements. 6. Use relevant images and icons. Graphic Creation and Design Tools 1. Adobe Illustrator 2. Canva 3. Tableau 4. Power BI 5. Google Data Studio 6. Microsoft Excel Additional Tips 1. Know your audience and goals. 2. Use accurate data. 3. Create a responsive design. 4. Test and refine. 5. Ensure acce...

I'm looking for a skilled developer who can create a script for me. This script should automatically click at the same point in multiple browsers and windows. Key Requirements: - The script should be compatible with the Windows operating system, as well as Android. - It needs to support Google Chrome, with potential for future compatibility with other browsers like Mozilla Firefox and Microsoft Edge. - The trigger for the script to click should be based on the page load or a specific event, not just time intervals or user interaction. Ideal Skills: - Proficiency in scripting languages. - Experience with web automation tools. - Familiarity with browser-specific scripting. Please provide examples of similar projects you have completed in your bid.

Project: Automated Lucky Jet Game Data Analysis & Notification System This project involves developing a Python script to monitor the Lucky Jet game, analyze its data, and send automated Telegram notifications. Key Features: * Data Extraction: The script will extract real-time game data, specifically the multiplier achieved in each round, likely through web scraping. * Data Analysis: The script will continuously monitor the sequence of multipliers. * Trigger: A notification will be sent via Telegram when the multiplier fails to reach 3x for 12 consecutive rounds. * Automation: The script will run continuously or on a schedule with robust error handling and recovery mechanisms. Technical Requirements: * Proficiency in Python with libraries like requests,...

I'm in search of a creative and skilled screenwriter to pen an action movie script aimed at young adults. The film's primary theme centers around 'overcoming adversity'. Key Requirements: - Proven experience in writing action screenplays - Ability to craft engaging narratives for a young adult audience - Understanding and ability to convey the theme of 'overcoming adversity' in a compelling way - Excellent understanding of screenplay structure and formatting - Ability to create relatable characters and thrilling action sequences Please provide samples of your previous work in the action genre.

I need a skilled Pine Script developer to enhance my existing code with a new feature. Specifically, I want to incorporate a Volume Renko indicator into the script. Ideal Skills and Experience: - Proficiency in Pine Script - Experience with creating and modifying indicators - Knowledge of Volume Renko brick behavior - Ability to integrate new features into existing code Your role will involve: - Adding a Volume Renko indicator to my existing Pine Script code - Ensuring the indicator behaves as expected and integrates seamlessly with the current code Please provide examples of similar projects you have completed in your bid.

Figma file: Write the script that does the takes the input JSON: { "words": { "hello": { "en": "hello", "es": "hola" }, "soda": { "en": "soda", "es": "refresco" } } } Go through each word and: Replace text in layers named label_{languageCode} with the right translation. Find and replace image in layer main_image with image_{word_key} (e.g., image_hello or image_soda). Since script is sandboxed, the images would have to be added to the project with those names (image_hello, image_soda, etc.), s...

Its urgent...I'm preparing for a finance interview and need an advanced Excel sheet that I can use to demonstrate my skills. The Excel sheet should be able to handle budget and forecasting data, and it should include the following features: - Pivot tables and charts: These should be used to summarize and analyze the data efficiently. - Advanced formulas and functions: I need the sheet to incorporate complex calculations to showcase my understanding of Excel. - Data visualization and dashboards: The sheet should be able to present the data visually, making it easier to understand and interpret. The ideal freelancer for this project should have extensive experience in creating sophisticated Excel spreadsheets, particularly for the finance sector. They shoul...

...our product, an eBook. This project requires producing multiple ad variations to effectively showcase the eBook and connect with our target audience. Scope of Work: Edit 60-second Instagram reels based on the provided script and Heygen custom avatar. Integrate a celebrity hook at the beginning of each reel, aligning it seamlessly with the script and overall narrative. Utilize visual storytelling techniques to create ads that resonate with the audience. Incorporate shots of our custom avatar to ensure the video appears original and personalized. What We Will Provide: Script and Heygen custom avatar for the video. Shortlisted celebrity hooks to begin with. Requirements: Proven experience in creating short-form video content, especially for social media platforms l...

...am looking for a skilled Python developer with expertise in web scraping to enhance an existing script designed to extract product data from Walmart's online store. The current script retrieves only 10 items at a time, while the website displays 40 items per page. The task involves addressing the infinite scroll or JavaScript loading mechanisms that are limiting data extraction. Key Responsibilities: - Modify the existing Python script to enable it to scrape all 40 items per page. - Implement solutions to effectively handle infinite scrolling or dynamic content loading. - Ensure the script is efficient and adheres to best practices in web scraping. - Conduct thorough testing of the updated script to confirm accurate data retrieval. Requirements:...

...company, it develops YouTube, Instagram, Tik Tok and Telegram channels, which already have thousands of subscribers. All our processes are automated as much as possible, we have our own schemes, scripts and tools for work. Now we are planning to create a new YouTube channel, and therefore we are looking for the main character. The tasks will include: - Bug fixes in the main script for long YouTube videos. The script has been pre-translated by artificial intelligence and contains about 4,000 words; - Translation of scripts into the Malaya or Philippine language, about 700 words. This is necessary for shooting short material for the Telegram channel; Conditions: - Payment will be made immediately after filming. - At the first shooting, it will be necessary to sign an ND...

I'm looking for a freelancer to help me with data entry in Excel. The job involves using basic arithmetic functions. Ideal skills for the job include: - Proficiency in Excel, particularly with data entry - Familiarity with basic arithmetic functions in Excel - Attention to detail to ensure accuracy in data entry Experience in similar projects would be a plus.

We would like to ask you to record a script for a 2-minute video in accordance with the timing. Video: Script:

I'm seeking a talented story writer to craft an engaging short movie script for me. Key Requirements: - The story should belong to the Drama genre, with a central theme of Love. - The setting of the story should be in the Rural countryside. Ideal Skills: - Creative storytelling with a deep understanding of dramatic structures and themes of love. - Experience writing scripts for short films. - Ability to vividly depict rural settings and create relatable, compelling characters. I look forward to collaborating with a writer who can bring this vision to life.