Data validation in excel using vba macroроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Мені потрібен макрос/скріпт/бот для гри, мені потрібно декілька раз проходити карти, однаково. Це 3д гра, я намагався сам розробити макрос але у мене з'явилась проблема на тому етапі, коли я хочу записати проходження карти Macro Recorder'ом, щоб в мене був макрос на проходження карти автоматичне, але коли я це записую, у мене не записується повороти камерою у грі. Прописувати дії у скрипт у ручну, я не намагався, бо загальне проходження біля 1 години.
Необхідно розробити веб-застосунок та описати його роботу. Опис має бути в форматі одного розділу бакалаврської дипломної роботи. Більш детальний опис наведений в закріплених файлах.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Looking for a web application development project based on an existing inventory and request management system. Key requirements: Fast Performance Rapid page loading Smooth real-time updates Optimized data fetching # Inventory and Request Management System (IRMS) ## Project Overview The Inventory and Request Management System (IRMS) is a comprehensive web application designed to streamline inventory management, request processing, and user role management. Currently implemented as a mobile app, the project needs to be converted and enhanced into a web application using Flutter Web or a suitable web development framework. ## Core Features ### 1. User Management - Multi-role user system (Admin, Manager, Gate Man, User) - Authentication and authorization - User profile man...
I have a set of printed documents that need their text transcribed into a Word document. Ideal Skills: - Proficiency in English for accurate transcription - Attention to detail for data validation - Familiarity with Microsoft Word Experience: - Previous data entry experience, particularly with text from printed documents - Proven track record of maintaining confidentiality and handling sensitive information with discretion.
# House Rental Management System - Developer Requirements ## Project Overview Development of a comprehensive house rental management system with cross-platform support (Web, Android, iOS) using Flutter and Firebase. The system will handle property management, tenant management, financial tracking, and reporting. ## Required Technical Skills ### Primary Technologies - Flutter (Latest stable version) - Flutter Web - Firebase - Dart (Latest stable version) ### Required Firebase Services Knowledge 1. Firebase Authentication - Email/Password authentication - Phone number verification - Custom claims for role-based access - Security rules implementation 2. Cloud Firestore - Database design and structuring - Query optimization - Indexing - Security rules - B...
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep...
I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.
...Delta Exchange using Tradetrone. Below are the specific requirements: Buy Entry Conditions: - A green candle is detected; execute Buy trade at market price after candle close. - Check difference: Close Price minus Low Price <= 3 points. - Stop Loss: Set at 3 points. - Trailing Stop Loss: Based on the lowest price of the previous candle. Sell Entry Conditions: - A red candle is detected; execute Sell trade at market price after candle close. - Check difference: Close Price minus High Price <= 3 points. - Stop Loss: Set at 3 points. - Trailing Stop Loss: Based on the highest price of the previous candle. Additional Conditions: - If a Buy position is active, do not execute Sell trades, and vice versa. Ideal Candidate: - Expertise in Python programming and strategy a...
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to ...
Job Title: Develop a Workflow for Scraping Global Mosque & Muslim-Based NGO Data with Detailed Documentation ________________________________________ Job Description: I am looking for a skilled automation expert to build a workflow that scrapes Google for global contact details of mosques and Muslim-based NGOs. The workflow must allow for targeted searches by category (e.g., society, charity, non-profit) and be optimized for credit efficiency in Make.com. The final system should produce structured data outputs and include clear, beginner-friendly documentation. ________________________________________ Scope of Work: 1. Automation Workflow: 1) Build a workflow to scrape Google for the following details: a. Organization Information: i. Organization Name ii. Organi...
I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.
Functional Analysis for the Project "Smart Company Management System" The "Smart Company Management System" is an internet-based system that helps organizations manage all internal processes in an organized and efficient way. The system allows managers and employees to automatically track projects, tasks, reports, and progress, improving work processes and optimally allocating resources. To perform a full analysis of the system, we will review each step of the project, including a detailed description of Use Cases and system actions. In this guide, we will conduct a functional analysis for each of the processes in the Use Case for the "Smart Company Management System," describing the actions that a user will perform and the actions the s...
...integrating mobile and email OTP functionalities, and efficiently managing data using MongoDB. Key Responsibilities: Implement AES 256-bit encryption for securing sensitive data. Set up and manage mobile and email OTP (One-Time Password) systems. Integrate third-party APIs like Twilio, SendGrid, or similar. Design, develop, and maintain RESTful APIs using Node.js and Express.js. Efficiently handle database operations with MongoDB. Write clean, maintainable, and well-documented code. Debug, test, and optimize the application for performance and scalability. Requirements: Proficiency in Node.js and Express.js. Strong understanding and hands-on experience with AES 256-bit encryption. Knowledge of OTP generation, validation, and integration with ...
Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,
# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf using my resume on various platforms, like Linkedin, Workday and Indeed. Your task will involve searching for relevant job postings that match my qualifications, and submitting my resume for each opportunity. # Responsibilities: - Search for job postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding o...
I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 p...
Necesito un macro para uber para que me muestre cuanto gano por km recorrido en total para saber si me sale a cuenta o no el viaje
I'm looking for an expert in Dynamo to create a custom tool panel for tagging ductwork in Revit. Ideal Skills and Experience: - Proficiency in Dynamo scripting - Advanced knowledge in Revit MEP - Experience in creating custom tool palettes - Attention to detail to ensure all necessary tags are included - Specific experience in the Plumbing discipline - Previous work with automating tasks in Revit MEP - Strong problem-solving skills for potential model validation and analysis tasks
...professional, and easy-to-use website for our legal firm. We specialize in digital asset and fintech regulations, and the site will serve as both a resource hub and a showcase of our expertise. What We’re Looking For: Professional Design: A clean, polished, and user-friendly design that reflects our credibility and expertise. Service Pages: Clear and detailed sections to highlight our Web3 and fintech legal services, tailored for businesses, startups, and individuals. Jurisdictional Guides: Interactive, easy-to-navigate guides on digital asset regulations across different regions, helping visitors quickly find what they need. Macro Legal Compliance: A dedicated section that explains broader global compliance requirements in simple, digestible terms. Insig...
I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.
I'm looking for someone to create several spreadsheets that d...should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financial aspects of my shipments better. Please, only apply if you have a ...
...that allows customers to schedule their removal services via a step-by-step form - Think Uber for Removalists - Real-time tracking functionality for monitoring removalists during the job. - A secure and efficient payment processing system. Ideal Skills & Experience: - Proven track record in mobile app development, preferably with experience in creating service-based applications. - Strong understanding of user interface design, ensuring the app is easy to navigate for both customers and staff. - Expertise in implementing secure payment systems and real-time tracking features. Easy Mover App Development Brief Vision & Mission The Easy Mover app aims to streamline the moving process for both customers and subcontractors through an intuitive and comprehensiv...
I'm seeking a professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass network, application, and database vulnerabilities. - The final report should be delivered in Excel format. - The dashboard should visualize: - Vulnerability trends over time - Severity of vulnerabilities - Overview of affected systems Ideal Candidates: - Proven experience in cybersecurity. - Proficient in data analysis and Excel. - Previous work with creating security dashboards is a plus.
I'm seeking a professional team to execute a stunning drone ligh...seeking a professional team to execute a stunning drone light show for a public event or festival. The show will take place in an open field, and its main purpose is to entertain the attendees. Key Responsibilities: - Plan and choreograph an impressive light display using drones. - Ensure the show is suitable for a public event. - Manage all logistics related to the drone light show. Ideal Skills and Experience: - Proven history of executing drone light shows. - Highly creative with a knack for designing entertaining sequences. - Excellent logistical and organizational skills. - Strong commitment to safety and compliance with aviation regulations. Must have experience in skybrush studio and ha...
I am seeking an experienced Microsoft SQL Server developer to create stored procedures that will handle input data validation for my database. The validation needs to cover: - Format validation: Ensuring data is in the correct format before entry. - Range validation: Verifying that data falls within acceptable limits. - Uniqueness validation: Checking that input data is unique where required. Ideal candidates for this project should have a strong background in SQL Server and data validation processes. Previous experience with writing stored procedures is a must. Please provide examples of similar projects you have completed in the past.
...navigation behavior for each device. 4. Security Framework Bypass: • Analyze and restrict access to security frameworks (e.g., Samsung Knox) by using tampered firmware. • Remove tamper flags on rooted devices to bypass basic security protections. 5. Cryptographic Environment Emulation: • Preload generic cryptographic responses for Secure Enclave validation to avoid app crashes. • Use proxy servers to intercept app calls for security checks and provide acceptable responses. Good to have: •Proven experience in hardware and software emulation, including the use of hardware description languages (HDLs) such as VHDL and Verilog. • Strong proficiency in low-level systems programming languages, including C, C++, and Assembly. ...
I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.
I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.
I'm seeking a professional photographer who specializes in macro/detail shots to capture my handmade bags. The primary purpose of these photos will be for my social media platforms. The ideal candidate will have: - A portfolio demonstrating experience with product photography, particularly with fashion items. - An eye for detail and ability to capture the intricate features of the bags. - Understanding of how to create engaging, high-quality images suitable for social media. Please include examples of your previous work with similar products in your proposal.
I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Looking forward to your bids.
We are looking for an experienced Android developer to create an APK similar, with features like real-time audio communication, text messaging, and a user-friendly interface. The project involves using NIO (Non-blocking I/O) and WebRTC libraries for high-performance, low-latency communication.
I need help finding high-quality, freel...downloadable dataset/links on consumer behaviour related to ready-to-eat or cooked food. Also, I need assistance in creating related questions on which the dataset is based. The datasets/questions should be in Excel format. Key Aspects of Consumer Behaviour to Explore: - Purchase frequency - Brand preference - Consumption patterns - Additional parameters for in-depth analysis Other Considerations: - Demographic information - Spending habits - Product satisfaction - Sustainability considerations - Customer satisfaction The freelancer will also be required to assist in formulating relevant questions based on the dataset. Ideal skills for this project include: - Data analysis - Market research - Excel...
I'm in urgent need of an experienced professional who can assist in gathering mortgage foreclosure excess proceeds data. This is a flexible, ongoing position with cash bonuses for honesty and accuracy. Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in...
...seeking a skilled Accessibility Designer/Operator with expertise in both Adobe products (InDesign, Acrobat, etc.) and Microsoft Office (Word, PowerPoint, etc.). Your role will be to ensure that documents meet WCAG 2.1 standards, providing accessibility for all. Key Responsibilities: Format and remediate PDF documents to meet WCAG 2.1 standards. Ensure accessibility compliance for Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and M...
I am looking for a data expert who can take data from multiple sources and consolidate it into a data source - preferably Microsoft Azure - for real-time PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. At this point, to start, I'm just looking for customer data - income, expenses, status, and a few other fields both numberical and descriptive Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis....
...Freelancer have to work in our physical office . It's not a remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new featu...
I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports
I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.
I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly tota...
I'm looking for a Python-based email validation checker that can efficiently check millions of email addresses against the Kucoin sign-up page. This tool needs to: - Utilize proxies: It should be able to run with proxies and handle the load of millions of checks with a budget of $200 worth of proxies. - Store results: The checker should store the results of the email validation in a file. The output format for the results file should be TXT. Ideal candidates for this project would be those with extensive experience in Python, web scraping, and proxy handling. A deep understanding of email validation and experience working with cryptocurrency exchange websites would be a significant plus.
We are seeking a skilled map creator to develop a detailed 50 X 30 grid map for a fantasy world. The map should be based on an existing image and crafted using the Inkarnate map maker. Attention to detail, creativity, and an understanding of fantasy themes are essential. The final output should be visually appealing and aligned with the provided reference image. If you have experience in map making and a passion for fantasy worlds, we would love to see your portfolio. Please apply with your previous work examples and your approach to this project. Please answer this question other I will reject your proposal.... 1) Do you have experience with the Inkarnate map maker software?
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic resea...
