Excel vba loop through rows in rangeроботи

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

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

Transfer news websites advertising texts...

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

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

I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of...

...data in Excel. The job involves using SUM and AVERAGE, VLOOKUP or HLOOKUP, PivotTables Excel functions and formulas for accurate and up-to-date data representation and analysis. Key Points: - Daily sales data update: The job will involve ensuring that the sales data for products, customers, and regions are updated daily. - Excel functions and formulas: The successful candidate should be well-versed in using Excel functions such as SUM and AVERAGE, VLOOKUP or HLOOKUP, and PivotTables to handle large sets of data accurately and efficiently. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of formulas and functions. - Experience in data analysis and handling large sets of sales data. - Attention...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm in need of a skilled Social Media Manager with a knack for e-commerce SEO and driving traffic. Key Responsibilities: - Managing and growing our presence on Facebook, Instagram, Etsy, and other platforms. - Implementing SEO strategies that are geared towards e-commerce. - Increasing brand awareness and boosting engagement with our target audience. - Driving quality traffic to our website. Your skills and experience in these areas will be crucial to the success of this project. In particular, you should have a solid understanding of the following: - Social media management and growth strategies, especially on Facebook and Instagram. - E-commerce SEO and its unique challenges. - Experience in increasing brand awareness and boosting engagement. - Proven ...

I'm seeking a talented designer to create a logo, color palette, typography, and brand guidelines ...a talented designer to create a logo, color palette, typography, and brand guidelines that convey trust and reliability for my business, GoldenEggs Distribution in Lagos. My target audience includes both businesses and consumers, so the design should appeal to a wide range of individuals. The main focus of this project is the creation of a logo. Ultimately, I would like to have a logo that can represent my business in a reliable and trustworthy way to our customers and partners. Ideal Skills and Experience: - Proven experience in designing brand identities, particularly logos - Proficient in conveying trust and reliability through design - U...

I'm seeking an experienced cyber security consultant to handle sales for a comprehensive range of services aimed specifically at small businesses. Key Responsibilities: - Perform END TO END sales for the cyber security solution and service and Hr staffing sales The ideal candidate should have: - Proven sales experience in the cyber security industry, particularly with small businesses or large Business - Strong understanding of the cyber security landscape and the ability to communicate complex security concepts in a clear and concise manner. - Excellent interpersonal and communication skills, with the ability to build and maintain strong client relationships. - Prior experience with vulnerability assessments, managed security services and cyber security HR...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am searching for a skilled video editor to create engaging content for my YouTube channel. The ideal candidate will have experience in a variety of editing styles, including documentary, podcast, cinematic, tutorials, vlogs, and montages. Requirements: - Strong command of advanced editing techniques - Ability to incorporate a range of styles seamlessly - Proficiency in color grading and audio enhancement - Experience with YouTube content creation Please provide examples of your previous work that demonstrate your proficiency in these areas. Your creativity and ability to engage audiences will be key in this project.

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I need to scrape data from a websi...website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in and if it is...

...proficient copywriter with a proven track record in creating persuasive, conversion-focused content. The primary goal of this project is to increase sales, particularly targeting young adults in the 18-34 age range. The key deliverable will be website content. - Proven Experience: An ideal candidate should have experience in copywriting, particularly for e-commerce or service-based websites. - Understanding of Young Adult Audience: Deep understanding of the preferences, pain points, and communication style of young adults is essential. - Sales-Oriented Approach: The content created should not just be engaging, but should be explicitly designed to drive sales. The success of this project will be measured by an increase in site conversions, so a backgr...

I'm seeking a professional to help me with a personal E-commerce data analysis project. I have access to a range of data sources including E-commerce platform data, sales data, and payment data. The primary goal is to create a comprehensive report that delves into the sales and payment analysis of my E-commerce business. Key objectives for this project: - Identify sales trends: I'm looking to understand the various sales trends that have emerged from the data over the period of time it covers. - Analyze payment methods: I want to categorically understand how my customers are paying for their purchases, and if the payment methods are changing over time. - Discover customer preferences: The project also aims to uncover key customer preferences and behaviors. Your role will...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this d...

I am seeking a skilled writer to help me with a report writing project. Although I haven't specified the exact topic or purpose, I can assure you that the task will be challenging and interesting. The leng...with a report writing project. Although I haven't specified the exact topic or purpose, I can assure you that the task will be challenging and interesting. The length of the report is not fixed yet, but it will be of considerable length. Ideal Skills and Experience: - Proven track record in report writing - Ability to work with minimal direction - Strong research and analysis skills - Creativity and adaptability to tackle a broad range of topics Please note that I am looking for quality and originality in this report. I am open to discussing the topic a...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due ...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issu...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...tracking through Google Analytics and Google Tag Manager on my Clickfunnels website. - I've already set up Google Analytics on my Clickfunnels website, so the main focus is on the conversion tracking aspect. - The specific event I'd like to track is Calendly bookings on my funnel. It's crucial for me to monitor the number of Calendly bookings generated through my Google Ads campaigns. Your expertise in the following areas is essential for this project: - Proficiency in Google Ads and Google Analytics - Experience with Clickfunnels and its integration with Google Tag Manager - Knowledge of setting up conversion tracking and tracking specific events on websites - Attention to detail to ensure accurate tracking of Calendly bookings. Please pro...

I am in need of an experienced developer to create an online medical appointment platform for me. The platform should be accessible through a web browser and will be utilized by a range of healthcare professionals, including general practitioners, specialists, and dentists. Key features that need to be integrated into the platform are: - Patient registration: A seamless process for patients to create an account and provide necessary details. - Doctor search and selection: Functionality for patients to find and choose a healthcare provider based on their specialty and availability. - Appointment scheduling: A user-friendly interface that allows patients to book appointments with their selected doctors. Ideal candidates for this project should have experience in...

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will in...

Project Overview We are creating an upbeat and engaging promotional video for Cookie Brand to be used in Facebook advertising. The goal is to showcase our wide range of cookie flavours, highlight the quality and freshness of our products, and entice viewers to visit our website and make a purchase. The video should reflect the fun, cheeky, and funky personality of our brand, utilizing still images creatively. Target Audience Women aged 25-54 Cookie lovers and those looking for delicious, premium treats Key Sales Points Over 30 funky cookie flavours Made with premium ingredients Rave reviews from satisfied customers Freshly baked to order Video Specifications Length: 30 seconds Tone: Upbeat, fun, and playful Music: Energetic and cheerful Visual Style: Bright, colorful, and ...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting...

...drive of this project is to effectively generate leads. As such, I am looking for a social media savvy freelancer with experience in crafting compelling and engaging content suited for LinkedIn. Key tasks would include: - Developing fresh content appropriate for the platform - Strategically positioning and promoting the content to engage industry professionals and drive them towards our online portfolio - Tracking, analyzing and reporting on campaign progress, adjusting strategies as necessary based on these insights Ideal skills and experience: - Proven LinkedIn marketing experience, with success in lead generation - Strong content creation skills, encompassing a range of content forms - Excellent ability to target and engage industry professionals - Solid unders...

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.

Develop macro-enabled Excel file to handle CSV

I'm in need of an experienced software developer to create a custom application for soil testing. The software should be capable of handling comprehensive soil analysis and generating relevant reports. Key Requirements: - A software that can analyze a wide range of soil testing parameters, including but not limited to pH levels, nutrient composition, and soil moisture content. - The primary focus of the software should be on advancing agricultural soil quality and providing actionable recommendations for soil improvement. Ideal Skills: - Proficiency in software development, with a focus on applications related to scientific analysis and data processing. - Familiarity with soil science or agriculture would be a plus. - Past experience in developing similar...

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to ...

I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file...

...the work at hand. The specifics of the project were not disclosed, therefore adaptability and flexibility are key. Key responsibilities: * Editing unspecified types of video content, which could range from weddings and corporate events to music videos. * Being prepared to work with different video lengths. The duration of each project could potentially involve videos that are less than 5 minutes long or exceed 10 minutes. * Adapting to different videography styles and moods, including but not limited to: romantic, professional, and energetic. Skills & Experience: * Broad video editing experience in various contexts. * Ability to work efficiently across different video lengths. * Ability to adapt to different videography styles and moods. * Excellent communication to ...

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

I'm in need of a skilled freelancer to help me purchase a range of electronics components. Ideal Candidate: - Experience in purchasing electronics components. - Knowledge of common suppliers and market trends. - Good negotiation skills to secure the best deals. - Understanding of quality standards and counterfeit prevention. Additional Details: - The components needed are varied, including resistors, capacitors, diodes, and more. - My primary use for these components is in consumer electronics, so familiarity with this sector is a plus. - Please provide your past experiences in purchasing electronics components in your application.

I'm in need of a professional logo for my company. This logo should be creative and artistic in nature. Key Requirements: - A logo which aptly reflects the nature of the business, which I will reveal to the contracted freelancer. - A creative and artistic design is essential, as this will help to set my company apart from competitors. - The logo must be professional in appearance and suitable for use across a range of mediums. Ideal Skills/Experience: - Proven experience in logo design, with a portfolio that showcases a diverse range of creative and artistic designs. - An understanding of brand identity and the ability to create a logo that effectively communicates the brand's message. - Strong communication skills and the ability to ...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. AND a 10 pages Product Brochure/booklet from a sample hardcopy Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO

I have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search engine friendly

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...

...Battery * A Single Drop In CanLiFe Lithium Battery Replaces An Entire Set Of Conventional Lead Acid Batteries & Can Operate A Stock Golfcart In Any Terrain. * Assembled In Canada * Backed By A 6 Year Limited Warranty * Estimated Range And Capacity To Be Displayed Prominently * Bluetooth Enabled - Monitor State Of Charge From Your Phone Total of 12 Labels to be created: Front Plaques: CanLiFe Lithium Golf Cart Batteries 36 Volt 56 Amp Hour (2.07 Kilowatt) Capacity 25-30 Kilometer Range 48 Volt 36 Amp Hour (1.86 Kilowatt) Capacity 25 - 30 Kilometer Range 48 Volt 56 Amp Hour (2.90 Kilowatt) Capacity 45 - 50 Kilometer Range 48 Volt 112 Amp Hour (5.8 Kilowatt) Capacity 95-100 Kilometer Range 48 Volt 150 Amp Hour (7.77 K...

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

...creative book editor who can assist with editing a range of professional textbooks across various subjects including finance, taxation, and costing. Key Qualifications and Experience: - Experience in editing textbooks is a must. - A Creative approach to editing is highly valued. The project is on a tight schedule, and ideally, I'd like the editing work to be completed in less than a month. The level of editing required is Substantive or structural editing, along with Rewriting to enhance clarity and style. Your task will be to: - Edit and enhance the text of professional textbooks. - Ensure the content is engaging and clear for the reader. - Implement changes that will help to improve the overall quality of the textbooks. To be successful in this ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I need an employee time tracking system on G...for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with employee attendance tracking - Ability to create a user-friendly interface that can...

...targeted towards prospective students, and will serve as an essential tool to showcase the college to potential new entrants. Key Information to Include: - Academic Programs: Highlight the range and quality of programs we offer, showcasing our academic strengths and diversity. - Campus Life: Illustrate the vibrant life on campus, including facilities, extracurricular activities, and student services. - Admission Process: Clearly explain our admission process, requirements, and deadlines in a straightforward and engaging manner. Ideal Skills and Experience: - Proven experience in graphic design, particularly in print collateral creation. - Understanding of the college recruitment and marketing process. - Ability to create visually appealing and engaging cont...

I am in need of a competent translator who can accurately translate a set of vaccination cards from Kurdish to English (US). Precision and a strong grasp of relevant terminology in both languages is essential. The total word count of the documents falls in the range of 600 to 1200 words. Key Requirements: - Fluent in English and Kurdish - Proven experience in professional translation - Familiarity with relevant language and terminology - Attention to detail and commitment to quality - Ability to meet deadlines Ideal Candidates: - Kurdish native speakers with a rich translation background - Professionals with experience in personal document translation - Individuals who can demonstrate their expertise in translating similar content ...

I'm ... Requirements: - Proficient in Python: As Python is my preferred language for this, you should have a strong grasp of Python and its libraries for carrying out sentiment analysis and text classification. - Email Analysis Experience: Experience in analyzing text data from email sources is highly desirable. - Understanding of Sentiment Analysis & Email Classification: A solid understanding of sentiment analysis and text classification and how it can be applied to email data. The emails that need to be analyzed cover a range of topics from customer feedback, internal communications, to marketing emails. Your analysis will be crucial in helping me understand the overall tone and content of these email categories. Please provide samples of your p...