Excel vba create monthly sheetsdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

Rad bi izdelal kviz ki bi obsegal razlicna podrocja, za zacetek na primer vprasanja iz racunalnistva, excel-a, podjetnistva,.. V kolikor pa bolje spoznate na kaksno drugo podrocje in se vam zdi da bi bila vprasanja uporabna tudi za ostale, se lahko zmenimo tudi za kaksno drugo podrocje vprsanj. Poleg vprasanja bi bili ponujeni 3-je mozni odgovori, med katerimi bi bil en pravilen. Za vsako podrocje bi imeli vprasanja razlicnih tezavnostnih stopenj, na primer Lahka, Srednje in Tezka. Bonus tocke za: -Vprasanja niso predolga, da ne zahtevajo ravno predolgega branja -Nekaj vprasanj lahko vsebujejo tudi kaksen smesen ali pa nenavaden ponujeno odgovor

need help with spreadsheet formula

...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...

Solicito ofertas para realizar la Primera Parte de una Macro de Excel cuyas instrucciones están en los siguientes vídeos ( ; (copiar y pegar en el navegador). (ambos vídeos son consecutivos y deben verse uno a continuación del otro para entender esta primera parte). Me gustaría que las ofertas estuviesen fundamentadas sobre el contenido de los vídeos y no fuesen ofertas automáticas (sin ver los vídeos)... Este detalle para mi es importante y me dice mucho sobre qué ofertantes son los auténticos profesionales. Gracias por la atención.

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.

Looking to Setup WhatsApp Business API for our e-commerce platform. Want to send notification , receive photo video with data from the vehicle info ,record data in excel, find info using number plate finder api, and generate QR and provide delivery tracking. Also need to send invoice and Any one already worked on WhatsApp Business API and understand it at deeper level should only bid for this project.

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 am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology ...am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology company, be it a startup, medium-sized company, or a large corporation. Skills and Tools: The ideal role for me would require proficiency in Python and SQL, as well as experience with Tableau and Excel, and PowerBI. I am looking for a freelancer who is well-acquainted with the tech job market, has great networking skills, and can help me land a position that matches my skills and as...

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.

Creazione di file in excel con formule, filtri, query, analisi, tabelle e grafici sulla base delle richieste del cliente. Macro VBA all'occorrenza.

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., “...

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