Excel vba list web files jobs
I'm looking for a skilled professional to automate the generation of historical data reports for NSE Nifty option contracts. The primary purpose of this automation is to facilitate report generation, which should be delivered in Excel format. The reports need to be generated at very specific intervals—every 5 minutes. Ideal candidates for this project should have: - Proficiency in data automation tools and programming languages such as Python or R - Experience with financial data, particularly options contracts - Excellent skills in Excel and report generation - Ability to deliver work on a tight schedule In your proposal, please provide examples of similar projects you have completed.
Trasfering arabic information in PDF to Excel data Manually (Example attached). This project for arabic speakers only
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
I'm looking for a dedicated professional to assist me with various data entry tasks. Key Responsibilities: - Inputting data into spreadsheets - Managing databases - Providing transcription services Ideal Skills: - Proficient in Microsoft Excel - Experience with Spreadsheet data input, Database management, and Transcription services - Attention to detail and ability to work independently.
I've developed a construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features -...
...There will only occasionally be tasks that require urgent attention. The attached document: ‘Duties for Personal Assistant’ explains what is involved in more detail. The ideal person will have: Excellent / professional level written English, and Fluent spoken English. Professional, but also fun, easy-going / casual and happy, positive personality and communication style. Email Online calendar Excel Word Looking for an on-going, casual, working relationship over several years. Experience / knowledge of the Entertainment industry desirable, but not essential. Ok with being paid every month or every 2 months (to reduce transaction fees). I have not had a personal assistant before, so I am used to doing these Admin processes myself. So it may take some time for us t...
Cricket ball Logo. I have between 4 low-quality PNG images that need to be transformed into high-quality, editable CDR (CorelDRAW) files. These files will primarily be used for printing, so they need to match the originals closely with sharp edges, clear details, and scalability for print. Key Requirements: - Skilled professional with experience in creating vector designs. - Special attention needed for text elements within the PNG images. - Timely delivery of the completed project. - Can suggest more enhanced designs Please include samples of similar work you've completed in the past.
I have several PDF files I’ve converted to DOCX. There is a total of 143 pages. Each file contains subtle errors and formatting issues that need to be corrected. I need someone with a keen eye for detail to go through the original PDFs and compare them to the Word documents to spot and correct discrepancies. The primary type of content in these PDFs is textual documents. You should expect to encounter: - Font style and size inconsistencies. The corrections should be marked as follows: - Using 'Track Changes' in Word. Ideal Skills and Experience: - Excellent command of English language. - Prior experience in proofreading and formatting. - Proficient in using Microsoft Word, particularly the 'Track Changes' feature. - Ability to pay meticulous attention t...
...Python/Jupyter notebooks. Your task will be to check that each student has completed their respective assignment. There is no need to grade the submissions for accuracy, simply confirm whether each assignment has been completed or not. Requirements: - Provide each student's name and their corresponding grade on a separate sheet. - The format of the student names and grades can be in any form (Excel spreadsheet, CSV file, or even handwritten/scanned). - No specific comments are required on the assignments, just a confirmation of completion. - Results can be organized in any order (alphabetically by student name, in the order assignments were reviewed, or grouped by assignment). Ideal Skills: - Familiarity with Python and Jupyter Notebooks - Attention to detail - Ability t...
...can help me streamline our HR processes using Microsoft Forms and Excel. The main aim is to utilize Microsoft Forms for case raising, where employees can report various issues. Key Responsibilities: - Set up Microsoft Forms for case raising - Utilize Excel to track each client, employees, auto send email notification with a unique ID - Implement direct data import from Microsoft Forms to Excel and a dashboard -Excel dashboard for clients and employees Ideal Skills: - send email via outlook to each client absence data weekly -Excel invoice system - Save files auto from email to drive or excel - Proficiency in Microsoft Forms and Excel - Experience with HR processes - Ability to create and manage a unique ID system in Excel...
I'm looking for an expert in Excel who can help me analyze some racing data. The main tasks will be comparing performances and identifying trends. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data analysis - Knowledge of racing data is a plus.
...are looking for a skilled freelancer to scrape Google and compile a comprehensive list of national facility management companies operating in the United States. The goal is to identify businesses similar to the following examples: • The Centurion Group • Broadway National Deliverables: A complete list of facility management companies, including the following information for each company: 1. Company Name 2. Website URL 3. Phone Number 4. Email Address 5. Headquarters Address (if available) 6. Other Relevant Contact Information (e.g., contact person, LinkedIn profiles) Requirements: • Scrape Google, business directories, or other publicly available resources to find relevant companies. • Ensure the list includes only companies with a n...
I'm seeking a professional to assist with my eBay listings and dropship product sourcing. Your tasks will include: - Locating Amazon U.S. suppliers for specific product categories - Extracting dropship products into an Excel spreadsheet - Creating custom eBay template descriptions - Optimizing draft listings and making auction posts live The ideal candidate should have prior experience with eBay product sourcing and listings, and be proficient in Excel. Understanding of product categories and ability to create appealing product descriptions will be a plus. Your primary focus will be on specific product categories, so familiarity with these categories will be beneficial. You will need to extract the following information for each dropship product: - Product title, pri...
I have multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: - Advanced ...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforward solution with clear explanations ...
I'm looking for a web interface to help soccer coaches and parents track player training progress. This platform will monitor multiple soccer and kinesiology metrics, providing a comprehensive view of each player's development. The dashboard will need KPI summaries, time-series trend analysis, peer comparison charts, and gamification widgets. The goal is to deliver a storytelling-driven experience that cleanly displays each player's progress, compares them to peers or bio groups, and helps parents and coaches quickly get actionable insights. Key Features: - Tracking of various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your delivera...
...Prompt the admin to input the message and attach any media (optional). 2. Ask if the message should be sent immediately or scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an Excel report listing: • Serial Number () • Name • Telegram Username of each user. 3. Prize Distribution • The bot will handle contests where users can win prizes. • Command: /prize ...
We have an existing Google Sheet that we want to turn into an Excel Sheet, but when we download it and open in excel the formulas to not come with it properly. Wanted to see if y'all could help us with it?
I am looking ...Breakdown: Casu: 136 products DCT: 327 products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Description 3) Product page URL 4) Image URLs (usually only one, but up to four images per product, if available) 5) Additional description, if available If any errors or issues occur (e.g., missing data, broken links, unavailable products), leave a clear comment in the designated "Comments" column explaining the problem. This can be done manually with copy paste, og with web scraping tools, as long as you got attention to detail to ensure high-quality data entry. Pay per hour, or fi...
...help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel, and MS-Outlook - Knowledge in creating both HTML and plain text versions of emails I appr...
I'm seeking a Python developer proficient with the Deepgram API to create code that extracts VAD variables from WAV files. The extracted data should be displayed against the corresponding sound files. Key Requirements: - Implement using Python, as it's my preferred language for this project. - Use the Deepgram API to extract VAD variables. - Include Speech-to-text transcription in addition to the VAD variables. Ideal Skills: - Deepgram API experience - Python programming - Audio processing knowledge - Speech-to-text transcription skills Please note, I will be providing WAV sound files for this project.
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
...should skip the additional fields and proceed with the normal checkout process, including any athlete-specific data fields. Data Fields to Collect for Athletes: The form must capture specific details such as: Full Name Date of Birth Blood Type Allergies Passport or ID copy upload (mandatory) Export Functionality: The system must allow the export of all registered athletes into an Excel file. The exported Excel file should include all the collected personal data in separate columns (e.g., Full Name, Date of Birth, Blood Type, Allergies, etc.). Uploaded documents (e.g., Passport or ID copies) should also be exportable or downloadable. Additional Notes: The solution must integrate seamlessly with WooCommerce's existing checkout process. The form and its functionality s...
Please Sign Up or Login to see details.
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
...the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5. 6. 7. 8. 9. https://www.truckplanet.com/Tanker+Trucks 10. 11. Then for any vehicles that meet all of the Criteria listed below, fill out all of the columns of the Excel sheet. You will
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
I have 12 months worth of bank transactions from three different accounts that need to be consolidated into a single spreadsheet. Key Responsibilities: - Convert transaction logs from PDF to Excel format - Create a spreadsheet that includes: - Account name - Date - Description (only keywords from the full transaction description) - Address - Amount - Balance of each transaction Required Skills: - Advanced Excel - PDF Conversion Software Please note: I will categorize the transactions once all data is combined into one document. The freelancer will not need to do anything besides conversion and/or copy from one format to another.
...This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property & Unit Management • Track properties, define units (rent amount, occupancy status). • Link units to tenants, show vacancy vs. occupied, manage lease ...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce ...
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that the data is correctly organized.
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
I'...a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and ability to present data cle...
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: ...Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of ...
...link exchanges. Provide regular reports on progress, including sites contacted, agreements made, and live links secured. Ensure high-quality and niche-relevant links (no spammy or unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.
I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you...
...Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Google Sheets). Strong web research skills f...
PHP Survey Script Tweaks Project Description: I have installed a raw PHP survey script and require the following customizations to improve its functionality and user experience: Optimize CSV Import Performance: Currently, importing large CSV files takes too long and sometimes fails to provide a file for download. I need this process optimized for efficiency and reliability. Enhance Graph Display: The results include graphs, but the values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph ...
Delivery Cost Mapping for WooCommerce example below Base Pricing by County and Weight Tier County Light (€) Medium (€) Medium Heavy (€) Heavy (€) Very Heavy (€) Fastway (€) Dublin 20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcha...
I'm looking for a web developer to create a five-page website that publishes data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to ...
I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .
