Excel vba extract data web page jobs
...comprehensive plan for creating Excel sheets with detailed product information from the following link: Grab Mart Merchant Link. ( ) Project Overview The goal is to compile full product information, including price, product photos (edited with a white background), product weight, and product category. Each category will have its own separate Excel sheet and corresponding Google Drive folder for storing photos. The product name on the photo and in the Excel sheet must match. Additionally, we will need to find barcodes for all products, as none are provided in the link. The total number of products is approximately 2,600. Steps to Complete the Project Data Extraction: Visit the provided
I'm looking for a web developer to build a single page WordPress website for my business. Key Requirements: - The website will serve as a business profile. - It should have a 'Services' section that describes the services we offer. - The 'Services' section should contain detailed descriptions about each service. Ideal Skills: - Proficient in WordPress development. - Experience in creating engaging, informative business profile websites. - Strong understanding of UI/UX principles to make the site user-friendly.
I need a spreadsheet expert to help me streamline my expense tracking tables with automatic calculations. My spreadsheet contains financial data and is primarily used for tracking expenses. The goal is to make the tracking process easier and more efficient. Ideal Skills: - Proficient in Excel or Google Sheets - Experience with financial spreadsheets - Knowledge of creating automatic calculations - Attention to detail for tracking accuracy - Ability to optimize and improve existing tables Please provide examples of similar projects you have completed in the past.
...resume that highlights key strengths. Include sections for education, work experience, skills, certifications, hobbies, and career goals. Use clear and professional formatting suitable for entry-level positions in marketing or project management. Provide both one-page and two-page versions of the resume in PDF and editable formats. Details to Include: Education: From high school to bachelor’s degree. Internship Experience: Responsibilities and accomplishments at BrightFuture Solutions as a Marketing Intern. Skills: Technical tools (Excel, Tableau, Canva, etc.), soft skills (communication, collaboration). Hobbies/Interests: Basketball, photography, traveling, and graphic design. Career Goals: Focus on marketing and project management roles. Requirements: Prov...
I'm looking for a talented graphic designer who can create a modern and sleek flyer for The Word Church. The flyer is to be sized 1024X768 and should prominently feature our 2025 theme: "Upgrade, Elevate, & Excel" (Ephesians 3:20). Key elements to be included: - The text: "The Word Church", "2025: Upgrade, Elevate & Excel (Ephesians 3:20)", "Tony Ray Smith, Senior Pastor", "". - A focus on the theme of 2025: Upgrade, Elevate, & Excel. - Our church logo. - A photo of our pastor. Example IMG_9673 ' Design specifications: - A modern and sleek style. - A dominant blue and silver color scheme.
...skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to writ...
I'm in need of a professional who can assist me with entering financial records into spreadsheets and making cold calls. Data Entry: - You'll be entering financial records into spreadsheets. - I have a general idea of how the spreadsheets should look, but I will need your input and expertise to create a clear and efficient format. Cold Calling: - You'll also be making cold calls on my behalf. - Excellent communication skills and a persuasive demeanor are essential. Ideal Skills: - Proficiency in data entry and spreadsheet software (preferably Excel). - Previous experience with financial data is a plus. - Strong communication skills for cold calling. - Ability to understand and contribute to spreadsheet design. Please provide examples of y...
...straightforward website. This landing page will serve as a reference point for my customers, allowing them to view my artwork and understand my business. Key Components of the Landing Page: - An image gallery showcasing my resin art - A section with contact information and a form for inquiries - An 'About Us' section detailing our story and mission - A section highlighting the companies we've collaborated with - A display of customer reviews The ideal freelancer for this project should have experience with web design and creating image galleries on websites. They should be able to design a user-friendly, aesthetically pleasing landing page that does not require advanced SEO or marketing features. The goal is to create a simple yet effective l...
We need to add thousands of products to our ecommerce website. Most of our suppliers do not provide the product images and product documents like specification and installation documents. We need help getting these images and documents from supplier websites. You will be provided with excel files for each supplier with the full list of product for which to get images and documents
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I need a fillable PDF created from an Excel worksheet. The PDF will be used to conduct a survey and will include both multiple choice and short answer questions. Key Requirements: - Convert specified Excel worksheet into a fillable PDF. - Incorporate various types of survey questions (multiple choice and short answer). - Ensure the PDF can be easily returned via email once completed. Ideal Skills: - Proficiency with Excel and PDF creation software. - Experience in designing user-friendly fillable PDFs. - Understanding of survey design and data collection processes.
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
I need a WordPress page to be created that is exactly like the one on Alqamees. The URL is: This project requires a keen eye for detail and strong WordPress skills to ensure the page functions and appears exactly the same as the reference. please check this page and only bid if you can make exact page like this
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and can deliver a robust model that me...
I am looking for a WordPress expert to create a one-page website exactly like this: It should have the same WooCommerce integration with 3D product models. Please review this page and let me know the estimated time required to complete it. I have only 5 hours to present this to my client. Additionally, provide your final budget and bid for this project. I also have custom CSS for this page, and I need you to integrate it into WordPress along with the WooCommerce integration for 3D models.
I'm currently working on a fiction book and need assistance with formatting it properly in Word. The goal is to prepare it for print. Key Tasks: - Format the book according to print standards - Ensure the layout is polished and professional - Make it easy for me to extract chapters for email Ideal Skills: - Proficiency in Microsoft Word - Experience with book formatting - Knowledge of print standards Please note, I am uncertain about the print size my book should be, so I will rely on your expertise to guide me in choosing an appropriate size.
...statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify Transactions: Review and categorize all business-related transactions from each accounts transactions that have already been converted to excel from the PDF statements, including: ...
...experienced SEO specialist for off-page optimization to join my team for a long-term collaboration. The primary focus will be on building high-quality backlinks, competitor analysis, and increasing website authority, while working closely with developers and content writers. Responsibilities: - Develop and execute off-page SEO strategies (link building, outreach, competitor analysis, etc.) - Conduct keyword research for relevant topics and prepare content guidelines for writers - Collaborate with developers and content writers to ensure seamless integration of technical SEO and high-quality content - Monitor SEO performance and provide regular reports (traffic analysis, domain authority growth, SERP rankings) Requirements: - Proven experience in off-page optimiza...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the need for precision, analytical skills, and a structured approach.
I'm in need of a service-oriented, financial advisory-focused landing page that's purpose-built for lead generation. The primary goal of this LP is to collect contact information of potential clients. Ideal Skills: - Web Development - UI/UX Design - SEO Optimization - Digital Marketing Experience in the financial advisory sector would be a plus. Please ensure to incorporate best practices for lead generation and data collection.
...for an experienced Shopify designer to enhance our product page layout. The main purpose of this redesign is to improve the user experience. The new layout should put emphasis on customer reviews, product images, the 'Add to Basket' button and 'Buy Now' options. Key Requirements: - Re-designing the structure of our product page layout - Adding 'items we recommend' upon checkout - Following a minimalistic and clean style or theme Ideal Skills: - Extensive experience with Shopify - Proven track record in UI/UX design - Ability to create a minimalistic and clean design - Excellent understanding of e-commerce best practices Please provide examples of previous Shopify projects you have worked on, particularly those involving product page...
I need a simple 1 page HTML page copied for me with logos removed and color changes I also need VPS with cPanel + domain + SSL bought for me and configured and set up proper and have the html site put on it I will release the hosting cost funds upfront and then the rest when project is done My budget is $317 My deadline is 1 day
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organized spreadsheet (Excel, CSV).
I'm in need of a comprehensive spreadsheet to track various employee absences. The types of absences I want to monitor include sick leave, call-o...spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
Hi Sameen, Key requirements: - Experience with Shopify - Ability to create a user-friendly and attractive one-page site - Knowledge of e-commerce best practices - Use our branding pack complete with fonts, graphics, colours and images this is to complete the website in a mix of styles : or using spotify Everthing as discussed in previous message
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
I need an experienced web developer to create a professional and corporate-style splash page for my law firm. The primary objective of this page is lead generation. It needs to capture the following information from visitors: - Their name and email - Phone number - Case details Ideal candidates should have: - A strong background in web development - Experience creating lead-generating splash pages - A portfolio demonstrating a professional and corporate design style Please include similar projects you've worked on in your proposal. Thank you!
...part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to detail to ensure all data...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset sho...
I'm looking for an experienced web scraper to extract data from several retail websites. The goal is to compile a list of products and compare their prices across different platforms. The ideal freelancer for this project would have: - Extensive experience in web scraping and data analysis - Familiarity with retail websites - Excellent attention to detail The project will involve: - Scraping specific retail websites to be communicated post-hiring - Collecting product names, prices, and descriptions - Compiling the data into a comparative list A strong understanding of data manipulation and pricing analysis is crucial for this project. Please provide examples of similar projects you have successfully completed.
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
I'm looking for a professional and formal half-page flyer design. This should incorporate: - 3 pictures - 1 QR code - The name of my company The focus of the design is to integrate all these elements cohesively. It should represent a professional and formal style, without being overly complicated or cluttered. Ideal candidates should have prior experience in graphic design, particularly in creating flyers or similar promotional materials. A portfolio showcasing similar work would be highly beneficial.
I'm Dr. David Alan Binder, an author seeking a professional with Wikipedia expertise to create a page about me. The page should focus on my published works, specifically book titles and summaries, and include a mention of the one or two notable awards I’ve received. Please note that payment will only be made if the page is successfully published and accessible on Wikipedia. Ideal skills and experience for this job include: - Proven track record of creating Wikipedia pages - Excellent understanding of Wikipedia's content guidelines - Strong writing and summarizing abilities - Experience in highlighting and structuring information in a compelling way - Ability to navigate the Wikipedia approval process My website is
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...design and build a 2-page sales funnel for our brand. The funnel will be designed to align seamlessly with our website’s design aesthetics and overall branding. The project will involve the creation of two essential pages: 1 - Lead Capture Page 2 - Upsell Page Project Goals: 1 - Create a visually appealing and conversion-optimized Lead Capture Page where visitors will exchange their email addresses for a freebie. 2 - Design an engaging Upsell Page to offer a complementary product to the lead. Both pages should: 1 - Reflect our brand’s design and tone. 2 - Be responsive and user-friendly across all devices. 3 - Utilize proven design principles to maximize conversions. 4 - Be fully functional within the Shopify ecosystem using PageFly....
...for employees and their dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
We are looking for an experienced Python developer to create a web scraping script using Scrapy. The script should scrape property data from Idealista and extract detailed information for all types of properties. Framework: The project must use the Python framework Scrapy. Key Data to Scrape: - Title of the listing - Price of the property - Location (address, neighborhood, city) - Property features (size, bedrooms, bathrooms, type, orientation, floor) - Description of the property - Highlighted features (year of construction, energy rating, heating, elevator) - Image URLs - Floor plan (image or URL if available) - Extras (storage, garage, pool, common areas) - Contact information (name or agency and contact details) - Environment (proximity to transport, scho...
I'm looking for a web developer to create a stock signal page with admin panel for posting daily signals. Key Responsibilities: - Develop a stock signal page (single page) - Implement user registration via email through a popup - Integrate various ad platforms such as Google AdSense, Facebook Ads, Amazon Ads and any other effective ones Ideal Skills: - Proficient in web development - Experience with creating stock signal pages - Knowledge of ad platform integration - Skills in implementing user registration systems
I need a script urgently that can read a PDF file, extract data from a CSV, and generate a new PDF with the extracted data. budget: 50$
I'm seeking an Excel expert to help build a dashboard for a monthly employee task tracker. The excel sheet is on Google shared folder so we need to work together The dashboard will need to display: - Employee names and tasks completed - Performance metrics The visualization of the data will primarily involve: - Charts and graphs This dashboard will be used by: - Managers Ideal skills for this job include: - Advanced Excel proficiency - Experience with data visualization - Understanding of performance metrics Please bid if you have the relevant experience.
...results through data-driven strategies. Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses an...
I need a stock signal page that displays stock suggestions. The page should integrate rewarded video ads and interstitial and banner ads for monetization. The ideal freelancer for this project should have experience in web development and ad integration.
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I'm looking for a skilled web scraper to extract data from Bet365 across all sports markets. Key Requirements: - Scraping all available data across every market on Bet365 - Delivering the data in a structured JSON file - Specifying the frequency of data updates Ideal Skills: - Proficient in web scraping tools and techniques - Experience with sports data - Ability to structure and deliver data in a JSON format. The scraper should provide real-time updates (milliseconds) Java is mandatory We need only the consultantion for connection to the websocket Project target is live. Any solution to the PM would be appreciated
