Excel macro autofill until blank cellcông việc
visual studio code aplicacion con fiori element, efectuando la llamada de servicios odata 4.0 o 2.0(estan creados ambos). el odata trae datos de una tabla de sap de 5 columnas , 2 de las columnas necesitan ayuda de busqueda y hay que generar 3 botones . 1 boton 1 grabar datos 2 boton 2 agregar linea 3 boton cargar excel Lo creado se debe ingresar A sap para estar disponible a usar en fiori Se debe realizar en dos dias.
I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category
...serial ID when a quotation request is submitted from our Wix website , or when it is manually captured by an admin user; - generate a PDF quote from the lead data with a 3rd-party PDF generator (customised quotation format and layout) and submit the quote to the customer; - track quotes submitted to customers; - periodically follow up on quotes submitted to customers until quotes are accepted (= deal) or cancelled; - create a deal with an automated serial ID a) automatically when a quote is accepted, or b) when captured manually by an admin user; - generate a PDF invoice from the deal data with a 3rd-party PDF generator (based on the above PDF quotation with minor changes); - generate a Property Survey form from the deal data with custom input, dropdown, upload
...involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer linear programming. - Ability to work within specified constraints. Experience: - Proven track record of using ...
I need an experienced NextJS developer to help fix incorrect styling issues in my web application. The problem occurs on both desktop and mobile, and it affects specific internal pages. Your expertise in building responsive and scalable web...help fix incorrect styling issues in my web application. The problem occurs on both desktop and mobile, and it affects specific internal pages. Your expertise in building responsive and scalable web applications using NextJS is crucial for this task. Key Requirements: - Minimum 5 years of experience with NextJS. - Proven track record of fixing styling issues. - Availability for morning check-ins until 10 AM EST. - Passion for delivering high-quality code. If you can devote time to this project and collaborate effectively, I would love to hear...
...our start-up insurance brokerage on our ClickUp account. The CRM system must have the ability to - (PHASE 1) - capture inbound quotation requests (= leads) submitted from our Wix website ; - capture inbound leads manually as received by phone or email; - track leads submitted to insurers for quoting; - track inbound leads submitted to clients; - follow up on outbound leads until a deal is closed (= insurance policy) or cancelled; - administer and track insurance policies - create a record on a 3rd-party integrated database for each list (leads, policies, claims, users, properties, insurers) (PHASE 2) - communicate with the client via pre-fabbed mails to adjust his policy according to custom data input by admin; - capture inbound insurance claims submitted by customers
I am in need of an advanced Excel developer to create a sophisticated spreadsheet for budgeting purposes. The spreadsheet should have the following features: - Revenue forecast - Budget variance analysis - Deal profitability and margin assessment - Expense tracking: Monitor and categorize all expenses with ease. - Break-even analysis: Calculate the break-even point for budgeting purposes. The spreadsheet will primarily handle manual data entry. The ideal freelancer for this project should have extensive experience in developing complex Excel spreadsheets, particularly for budgeting. They should also be adept at creating user-friendly interfaces for manual data input. Knowledge of financial modeling and data analysis will be a plus.
...Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. - Hands-on experience with building projects. This is an urgent task, and I would appreciate swift responses. Thank you. The final deliverables should be provided in an Excel spreadsheet. Please provide written explanations of both the steps and final results in a supporting document. The supporting document should contain an in-depth explanation of step...
Hallo, ich suche einen fähigen Excelprogramier mit kenntnissen in der Lohnsteuer. Als Anlage habe ich den akutellen Ablaufplan zur berechnung der Lohnsteuer beigefügt. Mein bisheriger Nettogehaltsrechner muss auf den neuen Ablaufplan angepasst werden. Dieser Rechner wird dann Bestandteil eines Rechners für die betriebliche Altersvorsorge. Viele Grüße Holger Konermann
...ability to handle various data tasks efficiently. Key Responsibilities: - Inputting inventory data into spreadsheets and databases. - Identifying and rectifying any errors in the data. - Organizing and updating records on a daily basis. - Ensuring all information is handled with the utmost confidentiality. Skills Needed: - Proficient typing speed and accuracy. - Basic understanding of Microsoft Excel and Google Sheets. - Exceptional attention to detail. - Self-sufficient and able to work independently. Qualifications: - A high school diploma or equivalent is required. - Previous experience in data entry is not necessary, but it will be advantageous. Ideal candidates will be reliable, trustworthy, and able to maintain privacy of sensitive information. The work will involve da...
I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail
...of customers, orders, and inquiries, enabling quick management. Manage Product Catalogue/Categories: Allows the admin to add, edit, delete, search, and filter product categories. Manage Product Items: Enables the admin to manage all products, including adding, editing, deleting, searching, and filtering. Manage Customers: Provides tools to add, edit, delete, import/export customer details (Excel format), view related orders/payments, search and filter customers, and view all chats. Coupon Code Management: Allows the admin to create and manage coupon codes. Account Settings/Logout: Admin account settings for notifications, password changes, and logout. B. Order and Shipping Management: Manage Shipping: Provides tools to view related orders/payments, search and filter,...
I have an Excel with 5 soccer leagues and I would like the games and the position in the classification of each team to be updated every day. It would be to associate Excel with the Internet and refresh the sheet with a button. My budget is 15 euros.
I need assistance with data entry, specifically handling numerical data sourced from online databases. The specific format for the entered data will be confirmed later but it is likely to be an Excel spreadsheet or a CSV file. Ideal Skills: - Proficiency in data entry - Experience with numerical data - Familiarity with online databases - Attention to detail - Ability to work efficiently and accurately
...and detail-oriented freelancer skilled in MS Excel for manual data input and preliminary data cleaning. Key Responsibilities: - Manual data input: Accurately transcribing data into Excel spreadsheets. - Data Cleaning: Primarily focused on removing duplicates from the dataset. Ideal Skills: - Proficiency in MS Excel - Strong attention to detail - Experience with data entry and data cleaning tasks The dataset is expected to have up to 1,000 rows. The project should be completed within a week. Please ensure data formatting to meet specified standards. Please follow common data formatting practices for clarity and consistency. No additional data cleaning tasks are required other than removing duplicates. The final output should be provided in an Excel workboo...
I'm looking for an expert who can integrate AI logic into Excel to automate complex calculations and enhance my Excel sheet's capabilities. The project primarily revolves around automating tasks with the help of AI. Key Requirements: - Expertise in Excel and AI - Proficiency in automating complex calculations - Experience in integrating AI logic into Excel - Experience in integrating machine learning models into Excel - Experience in creating custom functions in Excel - Familiarity with optimization algorithms and their implementation in Excel - Proficiency in scripting or programming languages such as Python or VBA In addition to the automation, I would also like the AI to assist in optimizing certain functions or formulas, sp...
I'm in need of a spreadsheet that can effectively track employee tasks. The spreadsheet should include the following details for each task: - Assigned...details for each task: - Assigned Employee: It should be clear who is responsible for each task. - Name of Task: A column for the name of the task. - Notes: A space for any relevant notes about the task. - Ongoing: A column to indicate whether the task is ongoing. - Link to SharePoint: A space for a link to the relevant SharePoint page. The ideal freelancer for this project should be proficient in Excel and have experience creating spreadsheets for task tracking. They should also be able to create a user-friendly, intuitive layout. The spreadsheet should also be repeated for 2026 etc at the bottom so we can track matters tha...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm looking for someone to help with a data entry task. The data will need to be entered into an Excel spreadsheet.
I need an expert in MySQL for data analysis. The primary focus is descriptive analysis using data from CSV/Excel files. Key Responsibilities: - Analyze data from provided CSV/Excel files using MySQL. - Conduct descriptive and predictive data analysis to extract insights. Ideal Skills: - Proficiency in SQL. - Strong background in data analysis, particularly descriptive analysis. - Experience working with data from CSV/Excel files.
I'm looking for a skilled designer who can convert an existing Excel line graph into a more visually appealing format using a specific colour template. Additionally, I need another graph, which is currently an image, to be redrawn and converted into the same colour scheme. Both graphs need to be delivered as new images compatible for inclusion in a Canva document, with a transparent background mask Key Requirements: - Convert an Excel line graph and an existing image of a graph into a format (note I have roughly done this so just needs to be redrawn properly using consistent line weights etc) - Implement a specific colour template using multiple Hex codes that will be provided - Make both graphs the same width/height (ie: same size) - Deliver final images in JPEG form...
I'm looking for an Excel Power Query expert who can assist me loop functionality needed asap . - Proficient in Excel and Power Query - Experienced in data transformation tasks - Ability to create calculated columns Please include your relevant experience in your bid.
I'm looking for an expert in AWS and data processing to create an automated system for generating and sending extensive Excel reports based on credit card transactions data stored in an S3 datalake. Key Requirements: - Extract and process data using AWS Lambda - Generate 40 comprehensive reports on a weekly basis - Implement extensive data transformations and aggregations into the reports Ideal Skills: - Proficiency in AWS, particularly S3 and Lambda - Strong experience in data processing and transformation - Excellent skills in Excel - Prior experience in generating automated reports
...(solicita depois de muitas execuções no mesmo ip). 5️⃣ Considerações Finais Gerenciamento de Sessão: Se possível, armazenar cookies da sessão para evitar logins repetitivos. Seria interessante fazer todo o processo via api, se for viável. Dando certo, no futuro gostaria de adaptar o projeto para outros bancos digitais via api. Vídeos dos 2 procedimentos, já uso macros minhas que resolvem, mas macro é lento e muitas vezes buga… Vídeo 1 - Cadastro - Vídeo 2 - Exclusão - ? Preciso que me entregue: ✔ Código-fonte limpo e bem comentado ✔ Arquivo de configuração () para ajustar credenciais e parâmetros ✔ Guia rápido de instalação ...
I'm looking for a skilled VBA expert to assist with Excel automation. Key Responsibilities: - Automate data entry processes - Implement custom data validation rules Ideal Candidate: - Proficient in Excel and VBA - Experienced with creating and implementing custom validation rules - Able to deliver efficient, streamlined automation solutions
Doing a database search for the selected databases and sending an excel sheet containing the search results
I am seeking a treasurer to join the trustee board of my charity, The Soup Kitchen. The role ...attend Board meetings, which are held twice a year, and additional meetings as required. The role may also involve liaising with staff, volunteers, and external stakeholders on financial matters. Application Process: Interested candidates are invited to submit their CV and a cover letter outlining their suitability for the role to the Director. Applications will be reviewed on a rolling basis until the position is filled. By volunteering as the Treasurer of The Soup Kitchen, you will have the opportunity to make a significant impact on our efforts to combat food poverty in Hounslow. Your expertise will help ensure that we continue to provide essential support to those in need in our ...
Need freelancer/VA to promote my affiliate link for a domain registration website. Sharing the affiliate link, you need to find interested users willing to buy a domain and guide them to purchase the required new domain for 4.95 USD for the year. Focus on targeting tech enthusiasts, small business owners who are likely to be interested in domain registration. Use the following social...for 4.95 USD for the year. Focus on targeting tech enthusiasts, small business owners who are likely to be interested in domain registration. Use the following social media to spread the word NO ads, only organic traffic needed. No email marketing as well. Your target for a day is 5 paying customers. The target customers can be from any region. Pay- 2 USD per paying customer Long term project- Until...
...should be compatible with both Android and Windows, and the primary purpose of this service is for backup and restoration of my files. Key Requirements: - Cloud Storage: The main function of the software will be to backup and restore my files securely. - Automatic Backups: The software should come with a feature that allows for automatic backups at set intervals. - Data Management: I have an Excel sheet filled with data that I want to manage through this app or software. The data should be converted and organized into a database that I can easily navigate and manipulate. Ideal Skills and Experience: - Proficiency in software development for both Android and Windows. - Experience with creating cloud storage solutions. - Ability to design user-friendly interfaces for data manage...
...- Assist in preparing consulting reports and presentations for healthcare clients. - Analyze data to identify business growth opportunities. - Support client projects with detailed research and strategic recommendations. **Requirements:** - Pursuing/completed a degree in Healthcare Management, Business, or Analytics. - Strong analytical and problem-solving skills. - Proficiency in Excel, PowerPoint, and data visualization tools. **What You’ll Gain:** - First-hand experience in healthcare consulting with AI integration. - Training on business scaling strategies using data-driven insights. - Internship certificate and performance-based reference letters. --- ### **Whiz Tech Internship Policy (Key Highlights)** 1. **Unpaid Internship:** All roles a...
...intake with calories , exercise, weight etc 2) Booking tickets and cancellation 3) Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get the information. For Body weight tracking - We will share photos of...
We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then be merged back into a word ...
I'm seeking a dedicated C# programmer to join our game development team. We're experienced with Unity and game design, and we're eager to share our knowledge and learn together. This collaboration is unpaid until the project's release, at which point compensation will be provided. Key Responsibilities: - Collaborate with our team in programming a 2D game - Share and gain knowledge about game development Ideal Skills: - Proficient in C#, with a strong understanding of its application in game development - Previous experience with Unity - Passion for 2D game development Note: This is a great opportunity for someone looking to build their portfolio in game development.
...personal assistant/accountant for my engineering company. This role involves a blend of administrative and financial responsibilities. Key Responsibilities: - Managing schedules and appointments - Handling financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with 1-2 hours a day of on-goin...
I'm in need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Proficient ...a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately entering this data into a database The expected volume of data to be pro...
I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.
We are looking for someone who will do the following. You will get an excelliste There you will find entries from 21435 rows Only columns A and B are relevant for you There you have to copy out the so-called HSN and TSN of the vehicle and enter them in a portal to identify the engine code of the vehicle. The engine code must then be entered in colum...integrity of the data. It must be 100% ensured that no errors are made. We will pay in milestones everytime 2000 entrys are provided and verified by a second freelancer validying the data which has been entered by you. So the offer you make will be divided by 11 (we´ll calculate from 22.000 entries) and everytime you deliver a bunch of 2.000 entries the agreed price divided by 2.000 will be paid until the porject has been fin...
...methodical approach ensures that all data is correctly inputted and organized. - Data Cleansing: I can enhance the quality of your data by identifying and correcting errors, ensuring consistency and reliability in your datasets. 2. Excel Proficiency - Advanced Excel Skills: I possess extensive knowledge of Microsoft Excel, including advanced functions, pivot tables, and data visualization techniques. This allows me to not only input data but also analyze and present it effectively. - Macros and Automation: I can streamline data processes through automated solutions using Excel macros, saving you time and reducing manual errors. 3. Attention to Detail - Thorough Review Process: I am meticulous in my work and perform multiple checks to ensure completeness an...
I'm in need of a professional who can assist me in collecting customer information. The data collection will be primarily through online forms, and the collected data should be organized in an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data collection and management - Experienced in using online forms for data collection - Skilled in organizing data in Excel - Attention to detail to ensure data accuracy
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I'm seeking a skilled mobile app developer to create an iOS application to manage my loan business. The app should handle various loan parameters and client data,...automate calculations and notifications. Key Features: - Client data management - Loan amount tracking - Interest calculation - Timeframe for repayments - Notification system for due payments - Investor tracking for each loan - Capital totals for investors - Monthly interest calculations for each investor - Active/settled loan status toggle - Automatic Excel database updates Ideal Skills: - iOS App development - Database management - Excel integration - Notification system implementation - Financial software development experience The app should support manual data entry. Please note that I want this ap...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project include: - Proficiency in Ex...
I need an Excel data dump sheet designed to mimic the look and feel of my personal expense dashboard. This includes using the same colors as the dashboard. It should be tailored to incorporate specific safety categories, with the data arranged to display correctly on the graph. The ideal freelancer for this project should have - Extensive experience working with Microsoft Excel - Strong design skills to match the dashboard aesthetics - Understanding of safety data categories - Proficiency in creating Pivot Tables
...rules and systems, seeking to understand how they work and if they can be improved or used differently. Thinks outside the box, finding solutions that others don't see. Constantly learns, exploring new technologies, languages, algorithms, or strategies. Automates and optimizes processes, seeking efficiency and new ways to solve problems. Experiments without fear, testing, failing, and adjusting until finding the best solution. Hacker culture has been present since the early days of computing and is not limited to cybersecurity. In fact, the hacker spirit has driven many technological innovations, from the development of open-source software to advances in artificial intelligence and automation. It is a way of thinking that transcends technology and can be applied in any fiel...
I'm looking for a clean and sleek design for a Facebook ad giveaway picture. The main objective of this design is to increase our brand awareness through the giveaway. This February, we’re keeping things extra cool! Place an order of $50,000 or more, and you’ll receive a FREE Engel MT-V45F Fridge—the perfect companion for adventures, road trips, and keeping your essentials chilled! ? Offer valid until February 29th—don’t miss out on this cool opportunity! ? Order now and claim your FREE Engel MT-V45F Fridge today! Key Elements Required: - Product Image: The design must include the photograph supplied - Engel fridge - Brand Logo: Our logo (Phoenix Sheds) should be prominently featured in the design, this can be ripped from our webpage if require...
...9 Total Risk Score 15.8 (Moderate Risk) Step 6: Mitigation Strategies For high or critical risks, outline corrective actions such as: Regular audits & compliance checks Enhanced training for caseworkers Improved fraud detection tools Automated eligibility verification This structured scoring method ensures an objective, data-driven risk assessment for LIHEAP. Could you like a customizable Excel template for this?...
Need freelancer/VA to promote my affiliate link for a domain registration website. Sharing the affiliate link, you need to find interested users willing to buy a domain and guide them to purchase the required new domain for 4.95 USD for the year. Focus on targeting tech enthusiasts, small business owners who are likely to be interested in domain registration. Use the following social...for 4.95 USD for the year. Focus on targeting tech enthusiasts, small business owners who are likely to be interested in domain registration. Use the following social media to spread the word NO ads, only organic traffic needed. No email marketing as well. Your target for a day is 5 paying customers. The target customers can be from any region. Pay- 2 USD per paying customer Long term project- Until...
I'm looking for a dropshipping professional with proven experience and a record of successfully sourcing products from Amazon to eBay. Your primary task will be product sourcing, specifically focusing on profitable products. What I need from you: - A track record of dropshipping experience, partic...past successes in dropshipping - Skills in identifying profitable, trending products for dropshipping What I will provide: - Access to my autods account for product listing - Customer service will be handled by my team Your ultimate goal will be to increase my eBay store's inventory of quality products and drive sales through effective product sourcing. We need a maximum of 50 product to start until you can prove your items are in demand we will the increase the amount of p...
I'm looking for a comprehensive spreadsheet that will help me manage a speaker management system for an event series. Excel Specification: Speaker Management System Workbook Structure Sheet 1: Dashboard Quick overview of upcoming events Key metrics (number of confirmed speakers, pending approvals, etc.) Deadlines tracker Budget utilisation summary Monthly Event Sheets (Jan-Dec) Each month that has events will have its own sheet containing: Section 1: Event Details (Frozen Top Section) Event Title Date Range (usually 1-4 days for each event but 2 speaker days) Venue Location Target Audience Total Budget Budget Remaining (formula-calculated) Event Website URL Section 2: Speaker Management Grid Columns: Speaker Name Justification/Value Propositio...
I have a portrait photo with uneven lighting that needs to be corrected. The areas that need the most attention are behind the hair and around the head. I would like the ligh...like the lighting to be adjusted in a way that enhances the natural look of the photo, rather than creating dramatic effects. Ideal skills for this project include: - Proficiency in photo editing software like Adobe Photoshop or Lightroom - Experience in portrait photo editing - Ability to enhance natural lighting Freelancers with a keen eye for detail and a knack for subtle adjustments will excel in this project. Please provide samples of previous photo editing work, particularly portrait photos, in your bid. The final edited photo should be provided in JPEG format. The original photo is high resolution ...