Vba code update sheets excel jobs

I need a professional to generate customer invoices in bulk based on a Word template and data in a single Excel sheet. The generated invoices should be in PDF format. Key Requirements: - Proficiency in Microsoft Word and Excel, specifically Office 365 - Experience in bulk invoice generation - Ability to follow a Word template precisely - Skills in converting Word documents to PDF The data is organized in a single sheet with all the necessary information. The ideal freelancer for this project should be detail-oriented to ensure each invoice is correctly generated without errors.

...Customer Testimonials Section – Showcase client reviews for credibility ✅ Fast Loading & Mobile-Optimized – The homepage must load quickly on all devices ✅ SEO-Friendly Design – Ensure proper heading structures, meta tags, and image optimization ✅ Easy-to-Update in WordPress – Preferably using Elementor or WPBakery for easy future edits ✅ Contact Information & Google Maps Integration – Ensure visitors can easily contact us 2. Website Speed & Performance Optimization ? Optimize HTML, CSS, and JavaScript – Minify and clean up unnecessary code for faster loading times ? Reduce Page Load Time – Implement proper caching and script optimizations ? Optimize Images & Videos – Compress and properly format media withou...

...Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont wa...

I'm in need of a Power BI expert to develop a user-friendly, visually appealing, and insightful interactive dashboard for my healthcare business. The dashboard will need to facilitate data exploration through basic filtering and sortin...exploration through basic filtering and sorting. Key Dashboard Components: - Revenue Analysis: Monthly & Yearly Trends - Sales Performance: By Product, Region, and Team - Customer Insights: Demographics & Purchase Patterns Skills Required: - Proficiency in Power BI - Expertise in Data Visualization - Strong knowledge of DAX & SQL - Business Intelligence experience The data source will be provided as Excel spreadsheets. The ideal candidate will be able to translate complex data sets into understandable visualizations, aiding in st...

I run covering hospitality news from Romania and the Republic of Moldova. I've started using n8n to collect news into Google Sheets based on Google alerts rss, but need assistance to enhance my automation further with ai gents and reduce the manual work. The primary goals are: - Reducing the time spent on manually publishing news articles into my Wordpress backend - Identifying what steps are still mandatory to be done by a human - Improving overall workflow efficiency I hope to find a freelancer with: - Expertise in n8n - Skills in process automation and workflow optimization - Experience with Wordpress Your task will be to help me fully utilize the capabilities of n8n and streamline my news publication process, allowing me to focus on content quality rather than repetitiv...

I'm looking for an experienced data engineer to extract specific information from the ASIC website and create a comprehensive Excel database. Data to be extracted includes: - Type of appointment - Date of appointment - State - Company name - Administration company - Administrator - Contact person - Email address The ideal freelancer for this project should have: - Proficiency in web scraping - Experience with data extraction from ASIC - Excellent skills in Excel and database creation - Attention to detail to ensure all relevant data is captured - Ability to deliver the project within the stipulated time frame.

I'm searching for an experienced Django ...Django developer to create a straightforward Python application. The app should scrape mixed data from databases, store it in an SQL database (preferably PostgreSQL or MySQL), and expose it as a REST API with token-based authentication. Key Responsibilities: - Develop a Python application using Django - Scrape mixed data from a website - scrapping scripts available , which are now writing to excel - Store the data in an SQL database - Expose the data as a REST API - Implement token-based authentication for the API Ideal Skills and Experience: - Proficient in Python and Django - Experience with data scraping - Familiarity with SQL databases (PostgreSQL, MySQL) - Knowledge of REST API development - Understanding of token-based authent...

I need an Excel expert to help me create a well-structured employee list compatible with Mac and Microsoft. The list should be able to filter by continent and alphabetically. Details I need for each employee include: - Name - Address - Continent - Country - Email - Telephone - Brand - Start Date - And more The template I purchased requires some modifications, including color adjustments to light shades. I'm open to other employee lists that are comprehensive and useful. Ideal Skills and Experience: - Proficiency in Excel - Experience with data structuring and filtering - Ability to modify Excel templates - Attention to detail - Understanding of light color schemes Please ensure the final Excel list is neat, error-free and ready for immediate use.

I'm looking for a developer who can create a comprehensive freight booking form for me. This form will need to cater specifically to truck transportation. Key Requirements:...trucks: Standard truck, Flatbed truck, Semi Tautliner, B Double Tautliner. - It should collect specific details for the freight quote, including: Distance, Weight of the freight, Type of goods, and the required truck type. - It needs to provide a freight quote based on these details, with different booking and payment options depending on the distance. - I need full access to this form so I can update prices as needed. Ideal Skills: - Experience in developing booking forms or similar applications. - Knowledge of freight and trucking industry is a plus. - Ability to create user-friendly and easily accessi...

Please Sign Up or Login to see details.

I have a list of procurement managers and need assistance in gathering their email addresses and telephone numbers. Eg procurement manager, name email , tel Requirements: - Data Entry: You will need to fill in an Excel spreadsheet with the name, email, and telephone number for each procurement manager, along with two additional columns (to be discussed). - Data Collection: The ability to source accurate email addresses and telephone numbers is essential. Ideal Skills: - Proficient in Excel - Experience in data collection and entry - Attention to detail - Good research skills Project Scope: - Processing a list of approximately 100-500 entries. Please quote for your services.

Since a recent update, I'm facing Gradle sync failures with my Android Studio project. I made minor adjustments to the files prior to the update, but I'm unsure which specific Gradle version I was using beforehand. Your task will be to diagnose and resolve the Gradle sync failures, ensuring my Android Studio project is back on track. Your expertise will be greatly appreciated. Able to use any desk to connect to my Mac.

I'm looking for a professional web designer to give my website a much-needed facelift. Currently, the site connects users with online teachers and offers a range of learning materials. However, I want to shift the focus more towards our material services and enhance the overall user experience. Key Requirements: 1. Update the site design to prominently feature our material services over the teacher services. 2. Implement a modern, clean, and user-friendly design. Your design should reflect a trendy aesthetic. The ideal candidate will have experience in web design, particularly for educational sites or e-commerce platforms, and a strong portfolio of modern, clean designs. Creativity, attention to detail, and understanding of user experience design will be key to successfully c...

I need an expert Shopify developer to enhance the product gallery on my single product page. My product has 10 color variations, and each shares 5 common images, but 1 image will dynamically change based on the selected color variant. How it should work: - When a user selects a color variant, the product gallery should update to display all 6 images, including the specific color variant image. - The transition of the images should be smooth and seamless. All images for each color variant have already been uploaded to my Shopify store, so you won’t need to assist with that. The ideal candidate for this task should have: - Extensive experience with Shopify theme customization. - Proficiency in Liquid coding. - A portfolio that demonstrates similar dynamic image display impl...

...Management: o Allow admins to add, update, and delete products, specifying details such as name, description, price, categories, images, and stock levels. o Maintain a table for categories and subcategories, with relationships to products. • Product Listing: o Display products with options to sort and filter by criteria like price, rating, category, or popularity. o Search functionality to quickly find products by name or keyword. • Product Details: o API endpoints to retrieve full details for individual products, including images, specifications, and reviews. 3. Cart System • Add to Cart: o Allow users to add items to their cart, specifying the quantity. o Update stock in real-time to avoid overselling. • Manage Cart Items: o Enable users to view, ...

I'm looking for a skilled WordPress and WooCommerce developer who can help me enhance my WOO Product Table functionality. Key Requirements: - The attribute lists should update simultaneously based on the user's selection in the active list. - If an attribute list has only one option, it should auto-select that option. - The reset button should function correctly every time it's clicked, not just the first time. Current Setup: - WordPress version: 6.7.2 - WooCommerce version: 9.7.1 - WOO Product Table version: 6.0.7 You can see an example of the project here: The ideal freelancer for this project should have: - Extensive experience with WordPress and WooCommerce. - Strong problem-solving skills to ensure the reset

I'm looking for a skilled WordPress and WooCommerce developer who can help me enhance my WOO Product Table functionality. Key Requirements: - The attribute lists should update simultaneously based on the user's selection in the active list. - If an attribute list has only one option, it should auto-select that option. - The reset button should function correctly every time it's clicked, not just the first time. Current Setup: - WordPress version: 6.7.2 - WooCommerce version: 9.7.1 - WOO Product Table version: 6.0.7 You can see an example of the project here: The ideal freelancer for this project should have: - Extensive experience with WordPress and WooCommerce. - Strong problem-solving skills to ensure the reset

Please Sign Up or Login to see details.

I need a Python code that uses Selenium WebDriver to launch Opera and Mozilla browsers, navigate to the same URL and then perform a few tasks. Ideal skills for this project: 1. Proficient in Python 2. Experienced with Selenium WebDriver 3. Familiar with browser automation 4. Able to troubleshoot browser-related issues 5. Good understanding of URL navigation Please provide your best bid for this project.

I'm seeking an Excel expert to design a comprehensive retirement planning spreadsheet. The sheet should assess: - Savings growth - Investment returns - Expenses tracking It should also provide monthly budget recommendations. The sheet must incorporate various investment types, specifically: - Stocks and bonds - Mutual funds Skills in financial forecasting and Excel automation are crucial. Please include in your bid examples of similar projects you've completed. Kindly provide any prior experience proof for hiring you

...application for data entry and management. This application will primarily use Excel as the database. Key Features: - Data Entry: Using a form with some drop down lists and radio buttons. The application should also have the ability to upload several PDFs (all PDFs are stored together in the cloud). - Data Search: Using a form to search on various parameters like name, supplier, etc. There should also be an option to download the PDFs. - General Management: The application should allow adding and deleting PDFs, and altering the data entered (like updating a phone number). Ideal Candidate: - Proficiency in Desktop Applications development. - Experience with data entry and management systems. - Familiarity with Excel as a database. - Ability to incorporate cloud-based PDF ...

Please Sign Up or Login to see details.

...Key Responsibilities: - Optimizing listings for T-shirt designs, including title, brand, bullet 1, bullet 2, and description. -This is Results based. Rank first page get paid. Will pay $3-5 per first page ranking - Conducting a FREE test listing to determine if you can rank on first page (And can do what you say you can). You will provide title, brand, bullet 1, bullet 2, and description. I will update listing link so we can both watch and follow. If it ranks then we can begin and I will send you batches of listings to optimize on an ongoing basis -Will determine if you know what you are doing with Merch on demand for Amazon tshirts (not products which are different) The ideal candidate will have a deep understanding of the Amazon A10 algorithm and can demonstrate their ability...

I'm seeking an expert in UiPath to set up automation for my work. The specific tasks I need automated include data entry, report generation, and email processing. Requirements: - Create new workflows from scratch in UiPath - Interact with various data sources, including databases, Excel files, and web applications Ideal Skills: - Extensive experience with UiPath - Proficient in workflow creation - Familiar with data handling across various platforms Please bid if you have the necessary skills and experience.

Branding & Brochure Design Brief Project Overview We are seeking an experienced graphic designer to refresh our brand identity and create marketing materials for our brand. Our brand specialises in racing simulators, used by professional drivers and high-net-worth individuals. The logo was create a while ago and we want to retain it's essence but update it for use throughout our website, marketing materials, and product brochures, ensuring a cohesive and professional look that resonates with our audience. Branding Requirements Our goal is to enhance and modernise our brand identity while preserving its core recognition. The new branding should communicate premium quality, exclusivity, and high performance, appealing to our audience of professional racers and luxury con...

...comprehensive dashboard created on Google Sheets that tracks various metrics for each clinic and aggregates them across all clinics. The dashboard should include: - Amounts and percentages of opportunities (column O) booked by each employee (column T) within a user-adjustable range (column E). - A breakdown of appointments booked by each type (column J). - A count of opportunities (column O) booked by each employee (column T) with companion. - A tally of appointments booked by referral type (column AN). I might have more dashboards needed in the future. The dashboard must be created using an existing Google Sheet and should incorporate visual data representation through charts. Ideal skills for this project include: - Proficiency in Google Sheets - Knowledge of data ...

...for an Excel expert who can program a comprehensive Excel sheet for managing the purchase and sales orders of TMT Rebars, with features supporting both Sales Order Processing and Purchase Order Processing. Key Features: - Sales Order Processing: The sheet should be able to handle the entire sales order process, tracking orders from initiation to completion. - Purchase Order Processing: Similarly, the sheet should manage the purchase order process, keeping track of purchases made for TMT Rebars. Data Analysis and Reporting: - Sales Reports: The sheet should generate detailed sales reports, providing insights into sales trends and performance. - Purchase Reports: It should also create purchase reports to keep track of the procurement process and expenses. Multi-user Acce...

I'm seeking a skilled Google Sheets developer to create an interactive, web-based curriculum tracker for a primary school. This tool will primarily be used by teachers. Key features to include: - Progress Tracking: The software should be able to monitor and display students' progress in real-time. This will help teachers assess the effectiveness of their lessons and adapt accordingly. Ideal skills for this project include web development, software design, and ideally, experience working on educational tools. A keen understanding of primary school curriculum and teaching methods would be a significant advantage. The goal is to create a user-friendly, efficient, and effective tool that can enhance teaching and learning experiences.

...management systems. Key Features Required: 1. Collating Vehicles Based on Load Capacity The system should be able to categorize and allocate vehicles efficiently based on their carrying capacity. Optimize vehicle selection to reduce fuel consumption and maximize space utilization. Ensure that vehicles are assigned in the most cost-effective manner. 2. Daily Route Updates & Optimization Automatically update and suggest the best routes daily based on traffic, weather, and fuel efficiency. Provide real-time route modifications if needed, ensuring minimal delays. Reduce operational costs by choosing fuel-efficient paths. Login IDs for Workers and Reviewers Workers should have access to assigned routes, delivery schedules, and vehicle details. Reviewers (Managers/Supervisors) ...

I need a Google Sheets expert who can help me sort my data. Key Requirements: - Sort the entire sheet based on Date/Time data - The sorting should be done in a chronologically descending order Ideal Skills: - Proficient in Google Sheets - Strong coding skills for data manipulation

I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.

I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions

I require an expert in Excel to design a formula that will automate some of my daily tasks. The main tasks to be automated include: - Data Entry: This involves inputting various data points into the spreadsheet - Generating Reports: This will be based on the data compiled in the spreadsheet. Ideal Skills and Experience: - Proficient in Excel with advanced formula knowledge - Experience in automating Excel tasks - Ability to create automated report generation The tasks need to be automated for daily execution.

...extract from PDFs (OCR if needed, e.g., Tesseract). * Investment Research: Parse ~2000 PDFs using PyMuPDF, PDFPlumber, or equivalent. * X Posts: Scrape relevant posts via X API or third-party tools. * Websites: Extract data with BeautifulSoup or Selenium. * Internal Memos: Fetch from Notion API. * Transcripts: Summarize with LLM (e.g., OpenAI, Claude, or Gemini). * Valuation Data: Process Excel files with Pandas and integrate Bloomberg/FactSet API calls. 2. Data Processing & Storage * Transform and store data for fast, accurate retrieval: * AI/NLP: Summarize content and tag entities (e.g., companies, metrics) using LLM and NER. Storage: * Structured data in PostgreSQL or MySQL. * Unstructured data (e.g., transcripts) as vector embeddings in Pinecone or E...

I require a set of Stationery using my existing designs as the basis for a new company and social media square version of the logo as well. -Please see attached my ex...looks best. Grey to be the same grey as the current design and then grey and black to match the new logo colour sets. -Please decide a nice font that goes with it for the text and confirm the font name. -Business card size is 85mm x 55mm + 3mm bleed on all sides -Compliment slip size is 210mm x 98mm + 3mm bleed on all sides -Please include all source files as well as print ready PDF. -Please update the address details, phone number and email to below Hagley Stoves St Kenelm's Rd, Romsley, Halesowen B62 0PG 01562 700 005 Also add email address to be info@ hagleystoves . co . uk (Less spaces) Any questio...

...WhatsApp Business API with an AI chatbot that will automate shift updates, inquiries, and workforce communication for our part-time employees. The system must also sync with Google Sheets to log shift requests in real time and automatically notify WhatsApp groups for different outlet locations. Key Features & Requirements: ✅ 1. AI-Powered WhatsApp Chatbot Workers send shift-related messages via WhatsApp. AI bot understands and categorizes messages (e.g., "I’m late", "I need to swap my shift"). Auto-responds to common questions (e.g., "What’s my schedule?"). Flags urgent messages for manual review. ✅ 2. Google Sheets Integration Logs shift updates with details: Timestamp | Worker Name | Outlet | Shift Date | Shift...

I'm looking for an expert in Excel or Google Sheets who can help me set up a monthly housekeeping inventory or stocktake. The format needs to be straightforward and user-friendly, making it easy to monitor. Key requirements: - Track item names and quantities. - Create a simple, easy-to-use inventory spreadsheet in Google Sheets. - Update the inventory on a monthly basis. Ideal skills for this project include: - Proficiency in Excel or Google Sheets. - Experience in inventory management. - Ability to create user-friendly spreadsheets.

I'm in need of a talented developer to create a stock tracking program for me. This program should be...talented developer to create a stock tracking program for me. This program should be able to analyze historical data, specifically focusing on trend analysis, performance comparison, and data visualization. Key Requirements: - The program must be a desktop executable version. - Integration with financial APIs for real-time stock data. - Utilization of Excel (VBA) and Python for seamless functionality. Ideal Skills: - Proficiency in VBA and Python. - Experience with developing user-friendly applications. - Strong attention to detail and problem-solving skills. If you have a passion for programming and can deliver a robust, intuitive stock tracking program, I...

I'm looking for a talented developer to improve my existing stock tracking program and create a Windows-compatible desktop executable. The program should be developed using Excel (VBA) and Python, ensuring smooth integration and functionality. Key Improvements: - Enhancing the user interface to make it more intuitive and user-friendly - Improving data processing speed for efficient stock tracking - Developing a desktop executable version of the program Ideal Skills: - Proficiency in both VBA and Python - Experience in developing desktop applications - Strong attention to detail and problem-solving skills - Passion for programming and creating user-friendly applications If you can provide these enhancements and have the required skills, I look forward to hearing...

I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.

I'm looking for a skilled React developer to update the front end of my website. The primary focus will be implementing new features, specifically interactive dashboards. Key Tasks: - Integrating interactive dashboards into the existing UI - Ensuring these dashboards connect seamlessly with our data source, Supabase Ideal Skills: - Proficiency in React - Experience with UI redesign and implementing new features - Familiarity with Supabase and creating interactive dashboards Your role will be crucial in enhancing our website's interactivity and user engagement. If you have a knack for front-end development and a keen eye for details, I'd love to hear from you.

I need someone to merge and reformat the contents of the sheets "Copy of database" and "study" from this Google Spreadsheet into a PDF. Key Requirements: - The final output should be a PDF, formatted for both phone screens and A4 paper. - The visual appearance of the document is critical, so please pay close attention to this while merging the content. Ideal Skills and Experience: - Previous experience with data formatting and PDF creation - Excellent attention to detail, particularly with visual presentation

I'm looking for a professional web developer to create a website primarily focused on student loans. The website will serve as an informational resource, providing comprehensive insights, updates, and advice about student loans. Key Responsibilities: - Design and develop a user-friendly, engaging website - Integrate SEO best practices to enhance visibility - Regularly update the site with the latest information on student loans Ideal Skills and Experience: - Proven experience in web development, particularly in creating informational websites - Strong understanding of SEO - Familiarity with student loans and the education finance sector would be a plus

I'm seeking assistance to help upload data onto my website. The task involves researching and finding every run club in m...all required information: run club name, description, city, suburb/neighborhood, exact meeting point, run type, time and day of the week, website and Instagram. - Save the list of found run clubs into an Excel spreadsheet, with each piece of information in a separate column. - Provide a brief overview of each run club in the submission. - Ensure high accuracy in all fields. Ideal Skills and Experience: - Proficiency in data entry and research. - Familiarity with run clubs or running culture is a plus. - Excellent attention to detail for ensuring information accuracy. - Experience with Excel and submission forms. - Ability to leverage AI tools respo...

...Business & Research Support: Conduct research, prepare reports, and analyze business or industry trends. - Data & Excel Work: Organize and manipulate data in Excel, including formulas, pivot tables, and reports. - E-commerce & Online Presence: Assist with e-commerce tasks (eBay, Shopify, etc.), product descriptions, and online store management. - Basic Graphic Design & Content Editing: Work with tools like Photoshop or Canva to create and edit visuals. - CRM & Analytics: Manage CRM tools, track performance data, and generate insights for decision-making. Requirements: - Proven experience in personal assistance, marketing, or business support. - Strong skills in Excel, Google Sheets, data analysis, and reporting. - Knowledge of digital ma...

...endpoints to update and fetch inventory data. - Implement logic to update inventory based on tool detection and OCR results. #### Milestone 4: Notification and Monitoring System - Build a dashboard to display real-time inventory status on a connected monitor. - Integrate with the 3CX API to send notifications via calls or messages. - Add configurable notification rules (e.g., alert when a tool is overdue or inventory is low). #### Milestone 5: Testing, Optimization, and Deployment - Conduct unit tests for each module (detection, OCR, inventory, notifications). - Optimize image processing speed and model accuracy. - Prepare a deployment script to automate server and Raspberry Pi setup. - Run end-to-end tests with real-world tool usage scenarios. ### Deliverables: - Full ...

I'm looking for a professional who can help me update the content on my website. The updates will primarily involve text, images, and videos, specifically on the homepage and product pages. Ideal Skills: - Content Management Systems - Basic Graphic Design - Video Editing - Web Development - SEO Optimization

Build a cloud based hotel booking app with standard functionalities including reservation, check-in/checkout, date checker/picker, rooms management, room status update, Pricing, Bills, etc

Scope of Work: Fix Website Issues Without Elementor Pro Subscription Project Overview: We are experiencing issues with the display of the three Testimonials and pictures as well as the Our Blogs sections at the bottom of the website, www.jbncapital.com. After the integration of an AI bot and the update to Elementor Pro, these sections no longer appear as intended. The hosting company has suggested updating Elementor Pro to resolve the issue, but we do not wish to subscribe to Elementor Pro. The goal is to find a solution that does not require the renewal of the Elementor Pro subscription, restoring the Testimonials and Blog sections on the website. Objectives: Restore Testimonials Section: The Testimonials section is currently not visible on the front end of the website. This se...

I'm seeking a freelancer who can meticulously extract data from all verified businesses on Entrupy's website. The information should be compiled in a Google Sheets document. Key Data Points: - Store names - Complete addresses - Websites (if available) - Email addresses - Phone numbers - WhatsApp details (if available) - Links to their Instagram and Facebook accounts Ideal Skills: - Proficiency in data extraction and web scraping - Experience with Google Sheets - Attention to detail - Ability to understand and comply with data privacy regulations Please note, I need this data to be as comprehensive and accurate as possible. The successful freelancer will have a keen eye for detail and be able to deliver this project in a timely manner. Budget $10 only. This is an...