Excel vba loop through rows until emptyроботи

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

We are looking for a detail-oriented individual to transfer data from over 2000 estimates into an Excel workbook / pricing database. The estimates and the Excel workbook are already formatted, so the main task will be to accurately input the data. This job requires strong data entry skills and attention to detail. The ideal candidate should be proficient in using Excel and have a good understanding of spreadsheets. We are looking for someone who can complete this task efficiently and accurately within 2 weeks. This will be executed in milestones to ensure the task is completed accurately and thoroughly.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm looking for an interior designer to completely transform my living room into a minimalist haven. My living room is less than 40 sq...space Ideal Skills and Experience: * Proven experience in minimalist interior design * Portfolio of designs for comparable spaces * A deep understanding of space planning and functionality * Creativity and innovative approach in using small spaces effectively Your bid should include design plan, sourcing furnishings and accessories, and implementation oversight. The room will be completely empty because the couch and other furniture will be removed. The flooring will stay the same bevande I would like to valorize it. Things that are mandatory to fit in the living room are: - smaller but a little darker couch - TV - dining table - vertic...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

...should be professional, polished, and have a high production value. Ideal skills and experience for this job include: - Proven experience in video editing, specifically with a focus on promotional material - A strong portfolio of cinematic editing work - Proficiency with video editing software and ideally experience creating text overlays - A creative eye and ability to tell a compelling story through video Looking forward to turning these clips into a powerful promotional tool - let me know if you're up to the task. Instructions for Freelancer Initial Review and Audio Improvement Enhance the audio quality throughout the video to ensure clear and consistent sound. This includes reducing background noise, balancing audio levels, and ensuring voices are easily heard and u...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...

Note : my budget not more 10$ for whole project Create AI web app on bubble io **Game Objective:** The goal is to create a web-based multiplayer game where each player receives secret tasks from an AI. These tasks must be comple...AI then assigns new tasks to other players (e.g., Players B, C, D). - The sequence of task distribution can be random or follow a specific pattern, depending on the game design. - If Player A does not complete their task, the AI modifies the scenario and generates new tasks accordingly. 5. **Endgame and Collaboration:** - The game continues with players interacting and completing tasks until the collective goal is reached. - Players must collaborate, using hints and partial information to deduce the overall scenario and how to achieve the...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

I am looking for a proficient email marketer to help me increase my sales conversions through email campaigns aimed at potential customers. Key Responsibilities: - Develop, execute, and monitor email marketing strategies to increase sales. - Create engaging sales emails that will entice potential customers. - Regularly analyze the performance of the email campaigns and adjust as necessary. Ideal Skills and Experience: - Extensive experience in email marketing, particularly in the area of sales conversion. - Proven track record of successfully increasing sales through email campaigns. - Strong understanding of potential customer behavior and how to target them effectively. - Excellent copywriting skills for creating compelling sales emails. - Proficiency in email marketing ...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...looked at a Get Ranked 1st page in 24-hour Chat GPT plan using Python, Ambitious, and Visual Studio code and was looking for someone with the skill to carry it out and do a listing for the keyword " Security Camera Installation Fort Worth. " I know it's reality, and I do it quickly with regular articles, but I see Chat GPT is the new thing and wanted to get someone who could thoroughly follow it through and get me a solid article to submit to Google for my website dfwwholesalesecurity.com. Is this something you feel you could do for what your expertise is? If rankings are front page in 1st few places I will pay additional for the quality. is what I am talking about and the tactics that will use all SEO, keyword extractor, bullet lists

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...

...style for P&IDs. Workflow: 1. Use HYSYS simulation software to verify the specifications of the pipes (double jackets) and pumps provided. 2. Upload the P&ID in DWG format as it is completed, not at the last minute. 3. We expect the P&ID and HYSYS simulation results to be completed within 5 days. 4. We will review and mark up the drawing and return it to you for revision. Continue making revisions until the final version is approved. 5. Once we approve the final version, upload the final DWG version and also create a PDF plot in at proper scale (11X17). 6. After receiving your drawing, if the drawing is not satisfactory, does not use best drafting practices, or is not up to our standards, we reserve the right to cancel this project without payment and repost. Eligi...

I'm seeking a skilled developer to create a form for my WordPress site that allows users to add a variety of colors. This form will need to be designed to match the provi...and types of colors selected. - Layout and Design: It is crucial that the form matches the design of the provided image. Ideal applicants should have: - Extensive experience developing custom forms for WordPress - Proficiency in CSS and HTML, with an eye for design to create a visually pleasing experience. - Strong communication skills as you will be required to provide updates and keep me in the loop. - A proven track record of delivering projects swiftly and accurately. I am eager to get this project completed urgently, so please only apply if you are confident you can deliver high-quality work within a ...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

As a personal trainer, I'm in the process of setting up contracts and liability waivers to protect my company's interests. These documents are primarily aimed at minimizing legal risks, especially in customer interactions. Key Requirements: - Develop legally sound contracts and liability waivers: My primary goal is to ensure that these documents are comprehensive, clear, and legally enforceable. - Tailored for Customers: The primary users of these documents will be my customers. Therefore, it's crucial that the terms and conditions are easily understood by a non-legal audience. - Digital Distribution: The preferred method for distributing these documents is digitally, either via email or on our website. Ideal Freelancer: - Legal Expertise: I'm looking for a professi...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I'm looking to hire a skilled web designer for a position in my agency. The ideal candidate should be proficient in Front-end developmen...both independently and as part of a team - Detail-oriented with a strong eye for design aesthetics - Comfortable with both full-time and part-time work All who sign up and have previous work on display will be given a chance to work with a client. If a client wants to have the service as a monthly recurring subscription to my agency then the same freelancer/contractor will be working with them until/if the client feels they no longer need the service. This is a great opportunity for someone who wants to grow their web design career and work in a dynamic, creative environment. If you meet the criteria and are ready to contribute to our team...

I'm looking for a skilled social media manager to handle our business's social media platforms. Job and responsibilities: 1. Instagram: 1.1 Perform Engagement activities 6 days a week. increase likes and comments until we reach 300 likes a day and 150 comments a day on 100 different accounts. target accounts are followers and people who liked my ads. 1.2 Upload 3 stories a day, using my material from Google Drive. 2. Write captions and hashtags for posts on about 50 posts a month (just write the caption and hashtags once a month) I can pay weekly , bi weekly tr month after the job is done, I can pay some of it in advance.

...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...

I would like to have an urgent abap help over a live call. This is very important we have to sit and program together until we finish. its a long call

I'm looking for a legal profession...of all concerned parties, to maintain clarity and avoid any potential disputes in our business relationship. - Including key terms in the agreement like a termination clause, an exclusivity clause, and a liability clause in order to secure our company's interests and limit potential risks. - Providing an open-ended duration without any specific term limit, allowing for indefinite continuation until either party chooses to terminate. This is a vital document for our business, so accuracy, attention to detail, and knowledge of contractual law are essential. Past experience drafting similar agreements would be a significant advantage. We're expecting a comprehensive, legally sound document that can guide our wholesale distributio...

...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You...timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is throu...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission and convert the data into a multidimensional array. - Da...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic...

...GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). - Knowledge of data handling and Excel automation. - Strong communication skill...

My business, , is in need of a talented SEO expert to help us achieve our primary objective of attracting new clients from the EU. Key Focus: - The main area of improvement required is technical SEO and website performance. This includes on-page elements, site speed, mobile optimization, and overall website health. Primary Content: - Our website primarily features content related to marketing services. This will help you better understand the tone and nature of the business, and how it appeals to potential clients. Skills and Experience: - Proven track record of successful SEO campaigns, specifically in attracting clients on a regional level. - Proficiency in technical SEO techniques and tools, with experience improving website performance. - Understanding of marketing services and t...