Excel vba create monthly sheets jobs

...Specialist with experience in piping engineering to assist in converting technical data from a PDF into an organized Excel spreadsheet. The source material is the "TROUVAY & CAUVIN – PIPING EQUIPMENT 2001" book, which includes detailed specifications of pipes and pipe fittings. Responsibilities: Thoroughly review the provided PDF document. Extract data related to pipes and pipe fittings, including dimensions, weights, and specifications. Organize the data into a well-structured Excel spreadsheet with appropriate headings and formatting for easy search and reference. Ensure accuracy of all data entries and correct formatting to maintain data integrity. Deliver a clean, searchable Excel file that categorizes different types of pipes and fittings ...

Task for UiPath Developer We are currently using UiPath for automation and need a developer to enhance workflow efficiency and ensure proper job handling. Scope of Work: 1. Prevent Unnecessary Execution: After completing the scraping process for a specific date, write "Done" in the corresponding Excel sheet. Ensure the process does not continue running when there are no new tasks. 2. Automate Video Upload & Processing: After uploading a video to YouTube, take the video file and upload it to for automatic processing and splitting into clips. 3. Upload Clips as Shorts: Once completes processing, upload the generated clips as YouTube Shorts and TikTok videos. Additional Information: A detailed video explanation of all tasks will be provided for clarity...

I need a professional to assist me with Microsoft Word, Excel, and PowerPoint. Key Responsibilities: - Document Creation and Formatting: Creating well-structured documents in Word with a professional touch. - Presentation Design and Enhancements: Transforming my ideas into compelling PowerPoint presentations. Ideal Skills: - Proficiency in Microsoft Word, Excel, and PowerPoint - Excellent document design and formatting skills - Strong presentation design abilities - Attention to detail - Good communication skills Note: I am open to suggestions and further enhancements based on your expertise.

I'm in need of an Excel expert who can help me create dynamic data connections using VLOOKUP and HLOOKUP. Key tasks include: - Using lookup and reference formulas to establish these connections - Assisting with the necessary formula setup Ideal skills include: - Proficiency in Excel, particularly with VLOOKUP and HLOOKUP - Experience in creating dynamic data connections - Strong problem-solving abilities to troubleshoot any issues that arise Ensure the data connections update automatically. Please include additional data processing as part of the project requirements. part numbers

Python Developer Needed to Deploy AI Chatbot & Integrate Live Google Sheets Database Project Overview I am seeking a highly skilled Python developer to help finalize, deploy, and integrate a custom AI chatbot (GPT-powered) that I have already developed. The Python code is already written. The chatbot is designed to guide users through a mental health crisis intervention framework, provide real-time resources, and integrate with FG Funnels. Key Objectives: ✅ Deploy the chatbot on a cloud server so it runs 24/7 (AWS, DigitalOcean, Render, etc.). ✅ Set up a webhook so the bot integrates seamlessly with FG Funnels. ✅ Connect the bot to a Google Sheets database, allowing me to dynamically update FAQs, crisis hotlines, myths/stigmas, and other knowledge without needing a...

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I need an expert who can create a detailed Amazon invoice. The invoice should include: - Customer details - Product details - Payment details - Shipping status - Tax details - Invoice number: Unique identifier for each invoice. - Purchase date: The date when the transaction was made. - Billing address: Full address for billing purposes, if different from the delivery address. - Order ID: Unique identifier for the Amazon order. - Delivery address: Full address where the product will be delivered. - Payment method: The method used for the transaction, e.g., credit card, PayPal. - Subtotal: Total cost before taxes and other charges. - Total amount: Final amount to be paid, including taxes and any additional charges. The ideal freelancer should have a keen eye for detail, experience i...

Certainly! Here's an updated version of your description, now including both Excel data clearing and technical support for mobile and laptop devices: --- **Excel Data Clearing & Technical Support for Mobile and Laptop Devices:** Are you struggling with messy Excel data or facing technical issues with your mobile or laptop? I’m here to help! With a strong background in both data management and technical support, I offer comprehensive services to ensure your technology is running smoothly and your data is organized perfectly. **Excel Data Clearing Services:** - Removing duplicates and irrelevant data. - Correcting formatting errors (dates, numbers, text). - Standardizing data entries (addresses, names, product codes). - Identifying and fixing m...

I'm seeking a skilled cold caller to help set appointments for my Google Reviews company. To learn more about the company, the URL is: dkreviews.org. Basically, we charge a monthly subscription to reach out to all of the companies past clients along with all of their future ones, asking them to leave a review in exchange for a certain discount or free service on their next visit. The primary industries of focus will be HVAC, landscaping, and car detailing. Ideal Skills and Experience: - Proven experience in cold calling - Strong communication skills - Ability to set appointments effectively - Familiarity with HVAC, landscaping, and car detailing industries is a plus

I'm seeking a project manager with expertise in performance tracking to help me customize a scorecard template I have for tracking the performance of individual project managers. The template currently tracks all projects per project manager for the current year. Key Responsibilities: - Adjust the layout/design of the existing template t...Responsibilities: - Adjust the layout/design of the existing template to better suit our needs - Ensure the scorecard effectively tracks key performance indicators: task completion rate, time management, and quality of work Ideal Skills and Experience: - Previous experience in project management - Strong skills in data analysis and performance tracking - Proficient in design/layout adjustments of Excel or similar templates - Excellent atte...

...visualizations are recommended: ________________________________________ 1. Real-Time Occupancy Data • Bar Chart or Gauge Chart: Show the current number of people in the office or at desks. • Heatmap: Display real-time occupancy across different zones or floors of the office. ________________________________________ 2. Historical Trends • Line Chart: Show occupancy trends over time (e.g., daily, weekly, or monthly). • Area Chart: Visualize peak and off-peak occupancy periods. • Calendar Heatmap: Highlight occupancy patterns by day or week. ________________________________________ 3. Space Utilization Metrics • Stacked Bar Chart: Compare utilization rates of different desks, rooms, or zones. • Pie Chart: Show the percentage of utilized vs. underu...

I need to create a CRM to manage drivers, trucks and services (trips). Currently we manage everything on spreadsheets. Core Features: Database Management Store, add, remove, and edit records for: Drivers (personal details, license, certifications, documents) Trucks (model, plate number, maintenance records, documents) Services (Trips) (routes, assigned driver & truck, client, pricing) Clients (contact details, service history, payment status) Service (Trip) Management Add new trips and assign: Driver Truck Client Set trip price and payment terms Payment Tracking Client Payments: Full and partial payment tracking Payment status indicators (Paid, Pending, Overdue, partial) Driver Payments Track payments to drivers (e.g., per trip, weekly/monthly salary) Truck Expenses...

I am looking for a data entry operator who can efficiently handle text data sourced from online forms. The data will need to be entered into Excel spreadsheets. The ideal freelancer for this job should: - Have excellent attention to detail - Be proficient in data entry - Have experience working with Excel - Be able to work independently and meet deadlines - Possess fast and accurate typing skills Please bid if you're skilled and experienced in this type of work. The expected weekly volume of forms to be processed is between 100 and 500.

I am looking for a skilled freelancer who can help me with specific formulae in Google Sheets to facilitate my financial calculations related to Medicaid billing and payments.

I'm looking for a professional who can help me develop a market risk model monitoring dashboard. This dashboard will primarily be used by our Fund Manager to keep tabs on our public, privet funds. Key Features of the Dashboard: - Monitor key metrics such as VaR (Value at Risk), Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and li... Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and limit checking. - Include any breaches in predefined risk thresholds. Ideal Skills and Experience: - Strong background in finance and risk management. - Proven experience in developing dashboards. - Prior work with public and privet funds is a plus. The dashboard should be developed using Excel...

For some reason, I'm unable to download the last 10 years of OHLC Nifty 50 data from my Fyers account. I need a professional to access my Windows computer, troubleshoot the issue, and download the data in Excel format. Key Requirements: - You must be able to remotely access a Windows computer - Proficient in using Fyers and troubleshooting data download issues - Able to download data in Excel format Ideal Skills: - Experience with financial data and stock market - Proficiency in using Excel - Good troubleshooting skills

I'm looking for a professional who can develop a comprehensive, hands-on video tutorial course on Redhat Linux 9. The target audience is at an intermediate level, so the content should challenge them without being overwhelming. Key topics to cover include: - Installation and setup - System administration - Networking and security - RHCSA and RHCE Topics v9 The course should be over 12 hours long once edited, and I will require full ownership rights upon completion. Ideal candidates will have extensive experience with Redhat Linux, teaching, and video production. A prior portfolio of similar projects will be highly advantageous.

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: * Call logging: The tracker should allow for detailed logging of calls made by representatives. * Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: * Proficiency in Excel and data analytics * Experience with creating tracking systems * Understanding of sales and call metrics

I need a spreadsheet expert to help me analyze data related to divorces. The primary purpose of this project is data analysis. Ideal skills and experience for the job: - Proficiency in Excel or similar spreadsheet software - Experience with data analysis - Ability to identify trends, patterns and insights from data - Strong attention to detail

I need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dash...

I'm seeking a professional to create a Google Form for mixed data (text and numeric) entry. This project involves: - The creation of a Google Form or Web form for data entry. - Utilization of Google Sheets for data processing. - Implementation of coding for comprehensive data analysis. - Implementation of conditional logic to adapt form questions based on responses. - Setting up automatic syncing of form data with Google Sheets. - Thorough testing of the created Google Form or Web form for functionality and errors. - Setup of custom notifications or alerts based on specific form submissions. - Incorporation of user authentication to ensure data security. - Ensuring the form is responsive and works well on different devices. - Providing user training materials or...

...developer to create a WebApp for our Freight and Logistics company. This application will be responsible for collecting customer, job request, and vendor data. It will automatically generate quotations, and integrate with Odoo for seamless output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiar...

...content writing as well. Like social media posting, blog upload on WordPress, etc. If required, we will provide you training as well. Experience: - Relevant experience is a plus - A basic understanding of content creation and the ability to meet deadlines Working Days: - Mon to Sat - 10 am to 7:00 pm ** We always give you 5-star feedback ** We will not create or release milestones in advance. I will make payments on a weekly or monthly basis. ** Maybe Before Award, we will take a small unpaid test. ** Maybe you have to attend 7 days unpaid training before joining. ** bid ONLY if our rate and terms suit you. ** DON'T BID IF YOU'RE WILLING TO WORK 1 WEEK FOR A GOOD REVIEW. This is a full-time position offering ₹10,000/month....

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

I'm looking for an expert in Google Sheets and Apps Script to create a standalone project management dashboard. The dashboard is primarily for task tracking and performance metrics. Key Requirements: - Design a user-friendly, efficient Google Sheets dashboard for project management. - Implement task tracking and performance metrics functionalities. - Use of Apps Script for coding to enhance functionality and ease of use. - Create a standalone dashboard without any integrations with other tools. - Create a google sheet that incorporates google forms for order tracking , execution photos, quality and test results, issues during execution and customer feedback Ideal Skills: - Proficiency in Google Sheets and Apps Script. - Experience in designi...

Monthly ongoing seo for , with weekly work reports Include 300 backlinks and 10-15 keywords included

Create a website that will feature telecom job posting. I am looking to mimic Cabl.com. I do want to be slightly different. I want to have categories for the job postings: business to business, independent contractor, and Employment. The jobs posting would be free to view but would cost for the employer to post the job opportunity. Sub categories would be ones similiar to Cabl.com- cable installers, satellite installers, telco installers, etc. I will prove a list of sub categories once ready. In addition to a list view, I do want a map to display all of the jobs. For example, if an employer posted a job for “independent contractor- fiber splicer- Dallas, Texas”, there would be a color code sequence pin on Dallas Texas to show the job. I also want a page dedicated to &l...

READ FULLY BEFORE BIDDING. My Chrome extension, which is supposed to help me select rows and columns in a Google Sheet and format them for pasting into ChatGPT, is broken. Although I am the owner of the sheet, the extension is returning a "I am not owner" error due to permissions issues. I need a skilled professional to debug and fix the extension for me. Probably less than an hour. $50 is reasonable. I have included a video of the issue. To show you read this and did not auto-bid, but your favorite color in ALL CAPS as the FIRST word in your bid.

I'm looking for a freelancer to create and manage a faceless Instagram page for me. The main goal of this project is monetisation, so the content needs to be engaging and shareable to attract a large audience. Content Type: - The posts should primarily be quotes and text-based posts. - The overarching theme of the posts should be motivation and inspiration. Ideal Skills: - Social media management - Content creation - Understanding of Instagram algorithms - Ability to create engaging motivational and inspirational quotes

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.

I need profiles created for individual practitioners at a private practice psychiatric clinic on various medical service sites. The profiles should be made on general health directories and psychiatric specialty sites, with a focus on accuracy and adherence to specific guidelines I will provide. Key Responsibilities: - Create detailed profiles for each practitioner, including their biography, clinic contact details, and a list of services offered - Ensure all information is accurate and adheres to the provided guidelines - Use discretion and judgement to represent the clinic and its practitioners in a professional manner Ideal Skills and Experience: - Familiarity with general health and psychiatric specialty sites - Excellent written communication skills - Attention to detail - Ab...

I am providing 2 month seo service at rate of 3000 monthly

As per your request. Total budget is 6000 inr .now you can accept. And it may take 8 days maximum. Thanks

We are looking for a freelancer to help build a blog focused on self-development and personal growth. The blog will share practical tips on improving self-confidence, generating passive income, and enhancing personal organization. Additionally, there’s an interest in exploring print-on-demand products that complement these themes.

We are looking for a skilled designer to create a compelling ad image (with supporting text) for a Google/Facebook ad campaign. The goal is to generate leads and attract Amazon Delivery Service Providers (DSPs) to try our advanced fleet management software, Fleetour. Requirements: 1.) Target Audience: Amazon DSPs – our solution is tailored to their specific needs. 2.) Brand/Background Info: Use Startseite - as the primary source for product information, brand style, and imagery. 3.) Key Selling Points: - AI-powered fleet management Real-time analytics & route optimization Scalability for Amazon DSPs of all sizes Streamlined operations and cost reduction 4.) Creative Direction: Bold, modern, and professional design Include a clear call-to-action (e.g., “...

Please Sign Up or Login to see details.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I am in need of a Google Sheets expert who can assist with creating custom functions and formulas to facilitate conditional formatting and dynamic updates within the sheet. Key Responsibilities: - Develop and implement custom functions and formulas in Google Sheets - Automate various processes using scripts - Ensure effective use of conditional formatting for data visualization and monitoring - Ensure data security and privacy compliance The ideal freelancer will have a deep understanding of Google Sheets and a proven track record of developing complex scripts. Experience with integrating data from Interakt WhatsApp will be an added advantage. Please provide examples of similar projects you have completed in your proposal.

I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

Seeking Expert Digital Entrepreneur for Profitable Online Business Venture Description: Are you a successful online business entrepreneur looking for your next big opportunity? I'm seeking a proven expert to help build a profitable digital venture with the potential to earn $2,000 - $20,000 monthly. Expertise and track record in one of below: - Verifiable track record of successful online businesses - In-depth knowledge of e-commerce and dropshipping - Experience with digital products (ebooks, templates, software, graphics) - Proficiency in content creation (YouTube, blogging, newsletters) - Expertise in affiliate marketing The ideal candidate will: - Demonstrate a history of achievements in online business - Provide a clear, step-by-step strategy for business growth...

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

Create cv for me. I pay project fees, your 100 rupees fees, write a good review, and invite for potential new projects I have for you. The ideal cv will be plain, easy to understand and is minimalistic with no designs but is organized. I can share my photo to add into it. Canva can be used but designs are banned and must not be used. My linkedin profile will be shared with you to create this cv. I will also provide additional details as we work through. Thanks

***LONG TERM POSITION AVAILABLE*** We are looking for a skilled 3D Render Artist who can produce high quality renders, with experience in banner design and branding a bonus. The brief is as follows: 1. Create and photo realistic render a controller that matches or improves on the quality of the sample HERE: 2. Create a web banner in size 1920 x 700px using the rendered image(s) you create, with the following text: Line 1 (main text) "10% OFF Personalized Controllers" Line 2 (sub-text) "Using Code 10CMODZ" You have full flexibility in terms of the web banner, You can download all of the model files and textures below: Please see the examples of banners we like the style of (but

please accept the quote and create the milestone for the monthly SEO working

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.