Vba excel script import data webdela

Bonjour, Nous recherchons une personne experte en Microsoft Excel pour gérer, trier et nettoyer un fichier contenant plus de 50 000 lignes de données (contacts). Ces fichiers regroupent des milliers de candidats et contacts enregistrés au fil des années. L’objectif est de pouvoir croiser les données, filtrer les candidats en fonction de plusieurs critères, notamment leur qualité, le secteur d’activité, ainsi que le poste et l’entreprise pour lesquels ils ont été positionnés. Nous comptons sur votre expertise pour nous accompagner dans cette tâche complexe et stratégique.

...and automating my Excel data. I'm unsure if everything is possible to do, but maybe a few steps can be disregarded. The perfect scenario would be: Create a simple form to add 'ID number' to process and file name for the new file. The automation: Open designated file with info. Create columns (based on character lenght) Format columns (set length, add '0's eg '234' formated to '000234'. Get only rows where Column C matches the input 'ID number', and column B has fixed value. Insert row at top with column header titles. Save file (as excel 97-2003 format), with the input filename. If all works out well, I will have another project where similar things are needed. Ideal freelancers for this project shoul...

I'm looking for a skilled animator to create a 30 second 2D animation video for marketing purposes. The animation should convey a professional tone throughout. 30-Second Animation Script [Scene 1: Restaurant Interior – Happy Atmosphere] Wide shot of a lively restaurant. People are enjoying their meals, chatting, and smiling. The camera pans to one table where a customer finishes eating. [Scene 2: Customer Pays Bill] The customer gets up, picks up their bill, and walks to the counter. The cashier smiles as the customer pays the bill. CLOSE-UP: The cashier hands the bill back to the customer. [Scene 3: Main Door – Smooth Exit] The customer approaches the main door. They scan the QR code on their bill at a sleek scanner near the door. The scanner lights up GREEN, ...

I have a 500-word script that needs proofreading. The script's purpose is to entertain a general audience. While the main task is proofreading, I am open to feedback on the overall tone and flow of the script, although it is not a requirement. Ideal Skills: - Strong command of English grammar and punctuation - Experience proofreading scripts - Ability to provide constructive feedback

We are seeking a skilled Python developer with expertise in computer vision and image processing to develop a solution for extracting individual objects (nails) from an image or a set of images. The ideal candidate will have experience with segmentation te...attention to detail. Preferred Qualifications: • Experience with segmentation models like Mask R-CNN or U-Net. • Familiarity with hand or object detection projects. • Knowledge of working with datasets and annotation tools (e.g., LabelImg, CVAT). Deliverables: • A Python script/tool that: • Processes one or multiple input images. • Identifies and extracts specific objects (nails) from the images. • Saves each extracted object as a separate image file. • Basic documentation and in...

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment (with price table and direct checkout). It must have a form plugin to do questionnaire (jotform). At the end of the questionnaire the AI must show a report based on answers. The job to do: make the landing pages with information of service, add the buy page of service using table price and direct ckeckout (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary use a plugin to create the tables and save the answer add a plugin or code to comunicate with a...

I need a short Python program that can extract transaction details from my PDF bank statements into both CSV and Excel formats. All my statements are in the same format, so consistency won't be an issue. Ideal Skills: - Proficiency in Python - Experience with PDF data extraction - Knowledge of CSV and Excel programming This project is a great opportunity for a skilled Python developer with experience in data extraction and a keen eye for detail.

...proficiency in at least one vector design program (e.g., Adobe Illustrator, CorelDRAW, or similar). • Specialization in the design of any printed material such as logos, banners, or business cards. • Ability to work remotely with discipline. **Benefits** • No experience in printing or production is required. • Each area of expertise is evaluated separately, so you will only work on the areas you excel in. For example, a designer specialized in business cards will not be assigned packaging design tasks. • Workload is evenly distributed among multiple designers in the team. **Application Process** **Before applying, we recommend learning more about our company by searching “SignsAtelier” on Google and visiting our website.** • Plea...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

I need a professional to analyze some data from an Excel file. The project primarily involves numerical analysis with a focus on identifying trends and patterns in sales data. Ideal candidate should: - Have proven experience in data analysis, particularly with Excel. - Be skilled in identifying and summarizing key trends and patterns in numerical data. - Be able to present findings in a clear and concise manner. - Have a good understanding of sales trends.

...worth of historical data from an existing real estate MLS server. 3. Use RESTFUL API to set up daily, incremental downloads of the same data. The existing database is a real estate MLS using a very well established RESTFUL API standard called RESO Web API Core 1.0 (). The reason for using the RETS system to do the initial download is that the number of historical records in some of the data fields has proven to be impractical (tens of millions of records) to download using the API as it is simply too slow. I am open to alternative methods here though. There will be a limited number of transforms (calculated fields) based upon the existing data structure, perhaps 15-20. Ideally, once the database is set up, I'd like to create a system (Excel...

I'm looking for a professional visual style for an interactive schedule planner in Excel. This project will require some experience with the developer tab. Key Requirements: - The schedule planner should feature automatic updates, conditional formatting, and data validation. - It should have a polished, professional appearance. - User interaction will be primarily through selecting from drop-down lists. Ideal Skills: Provide ideas that will make the spreadsheet user-friendly - Advanced Excel skills including developer tab proficiency. - Excellent understanding of conditional formatting and data validation. - Strong design skills for creating a professional layout. - Experience with creating interactive Excel tools. Please provide examples of sim...

I’m looking for someone to search for products on Amazon and list them in an Excel or Google Sheet. What you’ll do: Search for products in specific categories that I will provide. Record the product title and the link to the product page. Requirements: Basic knowledge of Excel or Google Sheets.

I need a professional to set up an email notification system for my staff, using Excel and Outlook. Key requirements: - The system should send an email to each staff member whenever a cell related to them changes value. - The cells are populated with dropdown list values. - The emails should be simple text, not HTML or pre-designed templates. Ideal skills for this project include: - Advanced Excel skills - Proficiency with Outlook - Experience with setting up automated email systems - Good understanding of drop down lists in Excel This is an opportunity to help me streamline communication with my staff and ensure they are updated in real time.

Bonjour, nous avons deux fichiers Excel comprenant deux colonnes comportant des codes postaux français : colonne C "CP départ" et colonne D "CP arrivée". Nous avons besoin que dans la 3e colonne "Distance en KM" vous trouviez via google ou par VBA Excel la distance en KM entre ces deux codes postaux. Exemple ligne 2 du fichier "Tri 2024" : CP départ 54710, CP arrivé : 28500, distance en km : 408 km

I require assistance with cleaning up my Excel files. I have three Excel files, and I need duplicates in one specific column of the first file removed from all 2 files. The structure of all files is the same, with identical columns. Ideal skills for this project include: - Proficient with Excel - Attention to detail - Experience with data cleaning Please be prepared to delete identified duplicates from all files. Budget $5

I am looking for help with creating a simple Python strategy to be used for crypto trading on Binance. The script is basically a simple trade management and hedging script that will allow me to open and manage multiple orders in hedge mode. The key input variables to be specified by the user are: Trading Symbol Upper Limit Price Lower Limit Price Take Profit (In Percentage) Stop Loss (In Percentage) Initial Trade: Long or Short Hedge Multiplier Maximum Number of Hedges If the user specifies Initial Trade = Long, the trading engine will seek to open BUY STOP orders at the Upper Limit Price and undertake SELL STOP orders at the Lower Limit Price (as a hedge) Let’s assume that the current market price is $100. The user specifies Initial Trade = Long and sets t...

Sto cercando un collaboratore per il mio canale YouTube, specializzato in ricerca di mercato e scrittura di script coinvolgenti. Il tuo compito sarà analizzare le tendenze del settore, studiare il pubblico target e trasformare le idee in script ben strutturati e accattivanti per i video.

I'm looking for a seasoned Solana blockchain developer to create a high-performance trading script tailored for high-frequency trading. Required Features: Command-line interface for buy/sell operations on Ubuntu server Integration with Helius RPC (developer plan) and/or Bloxroute (free tier) Support for both Raydium and Jupiter aggregator Transaction optimization using Jito bundles Dynamic compute unit and fee optimization Detailed transaction monitoring and reporting Technical Requirements: Transaction Speed: Target execution time: 2-3 seconds maximum Optimized for shared RPC performance Fast confirmation prioritization Command Structure: Simple CLI commands: node tokenaddress and node tokenaddress Configurable SOL amount for initial buy Automatic full position liquidatio...

...prioritize keywords. Include columns/tabs for capturing key SEO metrics (search volume, CPC, competition/difficulty, intent, etc.). Offer a clear workflow: from brainstorming seed keywords to final content mapping. Maintain consistent formatting that remains stable when exporting to or opening in Excel (if using Google Sheets) and/or in platforms like AppSheet. Make it intuitive and visually organized, with instructions or user notes so anyone on the team can use it easily. Key Features / Requirements Data Collection Tab Columns for keyword metrics (search volume, CPC, keyword difficulty, search intent, etc.). Ability to easily sort/filter based on priority or relevance. Brainstorm/Seed Keywords Tab A simple “dump” area to collect raw ideas. Minimal formattin...

I'm looking for a PHP web application function that can compare two Excel sheets. - The function should highlight the differences between the two sheets. the web app should provide the output excel as coded. Ideal candidates for this project should have: - Strong skills in PHP and web app development. - Experience with Excel sheet manipulation and comparison. - Ability to implement a user-friendly interface that highlights differences clearly.

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to select prev...

I need a scraping expert to debug my Python script that's supposed to be fetching financial data from APIs. Currently, the script is failing to retrieve some data. Ideal Skills and Experience: - Proficient in Python and data scraping - Experienced with financial data APIs - Strong debugging skills - Knowledge of data parsing and handling - familiar with yahoo finance data

I'm looking for a skilled video editor who can use After Effects to create an cinematic text video for me. I'll give you a reference video and script. Budget is very low currently but can give work in bulk

I need a skilled Python developer to resolve import errors for a project built in 3.9 to 3.13. The application uses a few external libraries. There are issues with hierarchial imports. I am trying to run this Project in Python 3.13: Key Requirements: - Expertise in Python, particularly versions 3.9 and 3.13 - Experience with command-line tool development - Ability to troubleshoot and resolve library compatibility issues - Knowledge of external libraries commonly used with Python Your Role: - Upgrade the tool to Python 3.13 - Ensure all functionalities are preserved post-upgrade - Identify and resolve any compatibility issues with external libraries - Provide recommendations for any necessary library updates or replacements When

I'm seeking assistance with customer analytics specifically tailored for a real estate operator. I've provided four recordings detailing the three deliverables needed: overview https://www....5a96621c deliverable 2 - identify highest CLV attributes deliverable 3 - prospect velocity thru 5 deal stages All three deliverables are of interest to me, but if you can solve 1 or 2 that is fine. I don't have a specific tool or software preference. I'm open to using Excel, data analytics platforms - whatever can solve the job accurately and that you're comfortable with. As for the format of the final deliverables, I'm flexible, whatever can present the deliverable accurately.

I'm looking for a detail-oriented professional to help with spreadsheet data entry. The task involves transcribing product information from PDF files into a spreadsheet. Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets) - Attention to detail - Ability to transcribe data accurately from PDF files - Understanding of product inventory management (preferred but not essential)

...or complex design elements into Canva-friendly formats if needed. - Ensure all assets are optimised for digital use. 3. Rebuild in Canva - Set up a new Canva document with proper dimensions, margins, and grid structure. - Recreate each page layout, ensuring accuracy in typography, spacing, and visual hierarchy. - Recreate text styles and colours using Canva’s built-in tools for consistency. - Import and place images, icons, and graphics. - Adjust any design elements that may not translate directly from InDesign. - Creating a clickable table of contents for digital usability 4. Review & Refinement - Cross-check against the original InDesign file for accuracy. - Make refinements to ensure brand consistency and readability. - Test the document’s editability by maki...

I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection ...

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...

...create a logo for my brand, "Senvia". The brand is dedicated to providing calming items and activities for elderly indivuals. The logo should effectively communicate warmth, calmness, and security, while distinctly steering clear of a medical aesthetic. Key Elements: - The logo must feature a minimalistic tree symbol, with one or two hands positioned beneath it. - The brand name should be in a script font. - The color scheme is to be composed of warm and calming colours. - The symbol should be separate from the brand name, positioned either on top or to the left. - The logo must be easily identifiable, even when very small, and effective on both black and white backgrounds. ---> Should be easily identifiable in favicons and profile picture thumbnails (IG, FB, etc......

...Closing Skills Ability to proactively communicate, engage, and influence proper decision makers Ability to execute sales strategies, think clearly and overcome objections Strong personal accountability with track record for delivering on expectations/commitments with focus, perseverance, and tenacity Requires knowledge of and the ability to use computer software such as MS Office Suite (Word, Excel, PowerPoint, Salesforce, and Outlook)...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I need a skilled web scraper who can extract data from a members area of a website. The data should be compiled and delivered in an Excel file. Website Scraping of Members Area Ideal Skills: - Web scraping expertise - Proficiency in Excel - Attention to detail

...three Python scripts for an analysis project involving NASDAQ data . These scripts will scrape stock prices and dividends from free stock data site (i.e., ), place the data in a single-sheet Excel file, and create a line graph similar to an attachment I will provide (). Script 1: Download stock prices (for a year - Download Historical ) and dividend data (for a year) for a given stock Script 2: save data to a single-sheet Excel file Script 3: Create a chart in the Excel file The ideal freelancer for this project should have: - Extensive experience with Python, particularly with libraries for web scraping and data analysis. - Proficiency in creating and manipulating Excel files with Python...

I need an expert in Excel to help me with an Index Match formula. It's intended to locate numeric data from a single table based on 2 criteria. Key Requirements: - Proficiency in Excel, particularly with Index Match formulas - Experience working with numeric data - Ability to match data based on multiple criteria If you have the requisite skills and experience, I would greatly appreciate your assistance.

Hi. I would like to scrape oddsportal for game results,closing and opening all odds import them into excel. I am interested in soccer matches. The scraper should be able to scrape data according to date i.e. I would like to input a date range and sport (soccer) and get the match details for those matches. Further details will be discussed with bidder. I should also mention that date range for scrapping data could be quite long (i.e. months) so the output xls could be quite big. It is very important to me that scraping is done as quickly as possible (seconds) with as less clicks as possible and without hanging-up or crippling my PC while scraping. PROJECT DETAILS: Sport:----------------------Football Bookmaker:------------------Bet365, BWIN, Pame Stoixima, ...

I'm looking for an expert in AI tools to scrape a website for me. The goal is to extract specific contact information and organise it neatly in an Excel sheet. Data to be Scraped: - Email addresses - Phone numbers - Names - Zip Codes The ideal candidate should have prior experience in web scraping and data management. Proficiency in using AI tools for this task is crucial. Data Formatting: - I need the data to be sorted into separate sheets for each type of information. Please provide examples of previous similar tasks you have completed successfully.

I'm looking for a freelancer who can create an Excel spreadsheet containing names and verified email addresses of businesses located in specified postcodes in Sydney, Australia. The project entails: - Collecting data on approximately 1500-2000 businesses - Including business names and email addresses in the spreadsheet - Ensuring that all email addresses are verified The ideal freelancer for this project should have experience in data collection and spreadsheet creation, with a keen attention to detail. Prior experience in sourcing business data will be an added advantage. Please note that the types of businesses and additional data points (like physical address, phone number, or website URL) are yet to be determined. The primary focus at this stag...

...developer to help complete and debug a nearly finished web application project. My original programmer was 95% done but has gone MIA, leaving the script untested and unfinished. The project is ready for final touches and testing in a dev environment. About the Project: The application is designed to track and analyze trade ideas from Telegram groups. The key features include: Telegram Group Downloader: - Use the Telegram Client API (e.g., Telethon or Pyrogram) to download messages from public groups. - Extract trade details such as: - Coin/Pair (e.g., BTC/USDT) - Entry points - Stop Loss (SL) - Take Profit (TP) levels Trade Tracking: - Record each trade’s entry, SL, and TP levels. - Fetch real-time price data from a cryptocurrency ...

...project that’s 95% complete. My original developer went MIA before testing or deploying the script in a development environment, leaving the work unfinished. The project has solid foundations but needs someone to test, debug, and ensure it’s fully functional. What You’ll Be Working On: Components of the Application: 1. Website data download: - Uses libraries like BeautifulSoup and requests to download website data. - Extracts specific information, such as brand, type, model, and cost. 2. Database Setup: - MySQL database to store downloaded data. - SQLAlchemy (Python ORM) for seamless database interaction. 3. Backend and Frontend: - Flask-based web interface for searching, sorting, and organizing the data. - HTML templates ...

I need a logo that features a marlin on the left side, with the text "Byrns Electrical Services" incorporated. The color scheme is blue and white. The font style for the text should be clean and simple, as opposed to bold or script. The marlin should be designed in a way that complements the overall simplicity of the font. Ideal candidates for this project would be graphic designers with a strong portfolio in logo design, particularly in creating minimalist yet engaging visuals. Familiarity with maritime themes is a plus. Please provide examples of past work that you feel aligns with this project.

We need to write function for JITO in already existing script

I'm looking for a skilled Excel expert to create a comprehensive Excel sheet for managing our swag items. The sheet should include the following columns: - Brand - Category - Campus - Item - Cost per item - Quantity - Item link - Dropbox link to the design The sheet will primarily be used for order planning and will need to be updated weekly. It should contain calculations for the total cost and a summary of quantities. Pricing details for various items are provided, and the Excel sheet should accurately reflect these costs. Ideal Skills: - Proficiency in Excel - Experience with inventory management - Ability to create complex formulas Key Features: - Order planning focus - Weekly updates - Total cost calculation and Quantity summary Please note, th...

I'm seeking a skilled modder and scripter to enhance my Marvel Spider-Man video game experience. The goal is to introduce Villain NPC fights throughout the city, creating engaging side-quests for players. Key Responsibilities: - Script and implement mod to spawn villain NPCs across the city. - Design and integrate these encounters as captivating side-quests with possible existing fighting styles and models. Skills and Experience: - Prior experience with Marvel Spider-Man modding is a significant plus. - Proficiency in game scripting languages. - Creative mindset for designing engaging side-quests. - Strong understanding of RPG mechanics.

Hello I have a GCP environment and would like to setup a script to create a user account Thank You for being here I have a JSON file that gets me access. Expect to do run Powershell and create a user admin account GCP Cloud Identify (using email as input) can we do this in 2 hours? can we have a max budget of $12 ? Please let me know any questions; this is all I know, if there is something ELSE to figure out let me know. Please ask me specific questions; if you say "tell me more about it" then all I can do is paste what is here? Thank you Again

I need a proficient Excel professional to assist me with some office work. My data is currently organized in a single spreadsheet with multiple tabs. The tasks I need help with involve: - Formula creation and calculations - Data analysis and reporting - Organizing my data according to specific requirements It's worth noting that I have a combination of prepared data and data that needs to be gathered. The ideal freelancer for this project should be well-versed in Excel, with a strong understanding of data organization, formula creation, and data analysis. Good communication skills are essential, as well as the ability to follow specific instructions for data arrangement.

I'm seeking a financial expert to create an Excel spreadsheet that projects the financial trajectory of an investment portfolio as it transitions from an operating company to three holding companies. These holding companies will serve the purpose of funding life insurance premiums. Key components of the project include: - Annual funding of a life insurance policy from the investment portfolio, coupled with a life insurance premium loan each year. This should detail the interest rate, annual deductions, and the net cost of the loan. - Retirement amounts for each of the three holding companies, sourced from both the insurance and investments, from ages 71 to 90. - Demonstrating the accumulated growth of the portfolio, with $3.9M in each holding company, and life insurance death ...

I need a HIGHLY skilled professional t...additional numerical entries to automatically calculate. Currently doc is in Word, but not opposed to Excel if it is faster and easier. Doc also needs page numbering (no page number on first page). Will need a grand total at end of doc. Deadline is Saturday, 01/25/25 or Sunday, 01/26/25. Key Requirements: - Add formulas to calculate the sum and averages of current and future entries. - Ensure calculations update automatically when new entries are added. Ideal Skills: - Proficiency in Microsoft Word and Excel. - Experience in creating automated calculations in documents. - Ability to translate numerical data into meaningful insights. Your expertise will ensure I can easily track and understand my data without having to...