Macro excel cellsроботи

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Мені потрібен макрос/скріпт/бот для гри, мені потрібно декілька раз проходити карти, однаково. Це 3д гра, я намагався сам розробити макрос але у мене з'явилась проблема на тому етапі, коли я хочу записати проходження карти Macro Recorder'ом, щоб в мене був макрос на проходження карти автоматичне, але коли я це записую, у мене не записується повороти камерою у грі. Прописувати дії у скрипт у ручну, я не намагався, бо загальне проходження біля 1 години.

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

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

Transfer news websites advertising texts...

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

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

Details in attached text file, Please read Ideal candidates should: - Have extensive experience with Python and Excel - Ability to deliver a seamless automation process.

I'm seeking assistance with data entry from spreadsheets. The work involves primarily numerical data – precision and attention to detail are paramount. Key Ta...with data entry from spreadsheets. The work involves primarily numerical data – precision and attention to detail are paramount. Key Tasks: - Data Entry: Inputting numerical data from various spreadsheets into designated fields. - Data Formatting: Ensuring the data is presented consistently and correctly according to specified formats. Ideal Skills: - Proficiency in working with spreadsheets (Excel, Google Sheets, etc.) - Excellent numerical aptitude and attention to detail. - Experience with data entry and formatting. Please note, the successful candidate will be tested for accuracy and speed before b...

...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the

...commenting thoughtfully on industry posts and participating in relevant groups. Build a strong network by connecting with AI thought leaders, business owners, and industry professionals. Use strategic hashtags to increase visibility and engagement. Save all content and engagement data in our OneDrive folder for tracking and reporting purposes. Track comments and interactions on LinkedIn posts using an Excel sheet. What We’re Looking For Proven experience managing and growing professional LinkedIn profiles or pages. Strong understanding of AI, technology trends, and personal branding. Exceptional content creation skills with a human, conversational tone. Ability to analyze and use LinkedIn insights to improve performance. Familiarity with tools like Canva and access to paid...

I am conducting an academic research project that involves handling quantitative data. I am looking for a skilled data entry professional who can assist me in organizing this data appropriately. Ideal Skills: - Proficient in data entry - Experience with handling quantitative data - Familiarity with academic research data requi...data - Familiarity with academic research data requirements Your task will primarily involve: - Entering quantitative data accurately and efficiently - Organizing the data into a format suitable for academic research Please note, the specific format of the data is yet to be determined, and may include: - Tabular format - Graphs and charts - Custom reports Data will primarily be sourced from Excel sheets and CSV files. Experience with these formats is ...

I'm seeking assistance with managing and organizing data in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, particularly in handling data entry and organization tasks - Attention to detail to ensure accuracy in data handling - Prior experience in administrative tasks or data entry roles would be an advantage

I'm experiencing issues with my Excel code that's leading to incorrect results during data processing. The main task of this code is to help me process data efficiently and accurately. Key Requirements: - Identifying and correcting errors in my current Excel code - Ensuring the code produces correct results during data processing - Potentially improving the performance of the code Ideal bidders should have extensive experience with Excel coding, a keen eye for detail to spot errors and the ability to optimize code for better performance.

I'm accountant who can filing the TDS return , GST return filing, and managing Excel sheets. below are the details that we can do. Key Requirements: - Proficient in Tally and Microsoft Excel - Experienced in TDS and GST return filing - Excellent Excel sheet management skills - EPF and ESIC - Tally ERP

I'm looking for an Excel expert to create a sophisticated form for data input and validation. Key Requirements: - The form will primarily be used for entering and validating text and numbers. - It must include dropdown menus for selecting options at various points. Ideal Skills: - Extensive experience with Excel form programming. - Ability to create user-friendly and efficient data input systems.

I have a project that involves entering text data from printed documents into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Experienced in handling and transcribing printed documents - Excellent attention to detail Experience: - Prior work involving data transcription from printed documents preferred - Proficient in Microsoft Excel

I require assistance with manual data entry. The task involves transcribing text from printed documents into a digital format. Ideal Skills: - Exceptional attention to detail - Proficient in English - Fast and accurate typing skills - Previous experience in data entry from printed documents - Familiarity with basic computer applications (Word, Excel, etc) Please note that the data to be entered is purely text-based, and it is essential that the work is carried out with a high level of accuracy.

...and scripts). Ability to create integrations with other platforms using APIs or third-party tools (Zapier, ). Excellent attention to detail and ability to maintain data accuracy. Strong organizational and problem-solving skills. Ability to collaborate with team members and understand business data needs. Preferred Qualifications: Experience with other database platforms (Google Sheets, Excel, or similar). Basic understanding of scripting languages (JavaScript) for Airtable custom scripts. Familiarity with project management or CRM systems. Experience working with remote teams and cloud-based tools. Hours: This is a part-time, remote position (approximately 10-20 hours per week), with flexible working hours. Some availability for team meetings during business hours may be requir...

...our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with scheduling, booking appointments, organizing files, and preparing documents. Co...

...our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with scheduling, booking appointments, organizing files, and preparing documents. Co...

...search results: - Store name and address - Contact information - Website (if any) - Contact person's name (if available) The towns / cities names will be provided in an Excel sheet, and the freelancer will need to: Search for auto parts stores in each town via Google. Scrape the relevant data (store name, contact number, address, website). Compile and organize the scraped data into an Excel file. Requirements: Experience with web scraping and the use of tools like Selenium, BeautifulSoup, or Scrapy. Experience using Google Custom Search API or SerpApi to extract structured results from Google searches. Proficiency with Excel (to organize and output the data in a structured format). Ability to work with proxy services and Captcha solving if needed, to avoi...

As a building company, I need a comprehensive Excel spreadsheet for quoting purposes. The spreadsheet should cater to both commercial and residential buildings and should include all necessary aspects for quoting. Key Features: - Inclusive of all trades: plumbing, electrical, roofing, tiling, etc. - Incorporation of all structural purchases - Detailed breakdown of individual wages with hourly rates - Everything needed to quote on commercial and residential buildings in Australia - All Excel workings need to be in metric measurements - A single, unified template for all quotes Ideal Skills and Experience: - Proficiency in Excel - Understanding of building trades and associated costs - Familiarity with commercial and residential building processes in Australia - Expe...

Busco un profesional en Power BI para desarrollar un reporte visual e interactivo basado en un archivo Excel con varias hojas (denominadas "Lam") que ya contienen datos calculados. Requerimientos: Conectar y cargar el archivo Excel. Crear gráficos interactivos (barras, líneas, tablas) para mostrar acreditaciones, canjes, saldos y porcentajes de redención. Incluir filtros y segmentaciones para explorar datos por hoja, fechas o miembros. Diseñar un tablero visualmente atractivo y fácil de usar. Entregar el archivo Power BI (.pbix) listo para usar. Adjunto el archivo en excel y un ejemplo hecho en power bi

I need assistance converting an Excel calculator into a calculator that I can embed in a Word document, so that when the word document is turned into a PDF the calculator still works and is editable by the user. This could be done using Python to create the calculator. I can see two scenarios to achieve this:- 1 The Word document will be regularly updated , so the calculator should be embedded in the word document. 2 The calculator could be embedded in a separate pdf and the word pdf and calculator pdf merged each time the word document is updated. Requirements: - Integrate an editable calculator into the PDF that performs basic arithmetic Ideal Skills: - Python - Ability to create interactive elements within a PDF - Attention to detail and ability to follow instructions accura...

I need a professional who can create an Excel report in a dashboard format tracking the performance of our management. The report should encompass: - KPIs (Key Performance Indicators) - Financial performance - Employee productivity Ideal candidates for this project should be proficient in Excel, with experience in dashboard creation and performance reporting. Strong analytical skills and understanding of management metrics will be a plus.

Excel sheet financial expert to monitor my income, expenses and investments with proper graphical visualization.

...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...

...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...

I'm looking for a detail-oriented and resourceful individual to find high-quality products for our dropshipping store specializing in pet supplies (dog, cat, and small pets). The ideal candidate will search for trending, affordable, and reliable products on AliExpress, collect relevant product data, and organize it in an Excel spreadsheet for easy reference.

I'm in need of a dynamic excel sheet that will assist in managing the daily and weekly activities of our vehicles. This sheet should be able to track various aspects such as: - Maintenance schedules: Keep tabs on when each vehicle is due for maintenance. - Fuel usage: Monitor fuel consumption over time to identify any discrepancies or patterns. - Trip logs: Record details of each trip for future reference. The ideal freelancer for this project should be highly proficient in Excel and have experience in creating dynamic, interactive spreadsheets. They should also have an understanding of vehicle operations and be able to incorporate relevant features into the planner. Key features of this planner should include: - Automated scheduling: The sheet should be able to auto...

I require an Excel expert who can help me create complex data lookup and reference formulas. Specifically, I need assistance with VLOOKUP and HLOOKUP.

...one-off gig, but a long-term collaboration aimed at scaling the store. Key Responsibilities: - Develop fully functional niche eCommerce sites on OpenCart, alongside a comprehensive master site. - Initial upload of 100 products, inclusive of category creation and filter setup. - Quarterly addition of a minimum of 300 products, with a target of 10,000 by year-end. I will provide all product data in Excel format and URL to images. - Implement necessary APIs for automated order fulfillment. - Regular site maintenance, including yearly opencart CMS and theme upgrades. - Gradually incorporate SEO support and an affiliate marketing module, and collaborate with influencers over time. Ideal Candidate: - An individual (not an agency or company) - Proven expertise in OpenCart, with a port...

I'm looking for someone to help me merge several files, including Excel, CSV, and one HTML table, into a single unified Excel file. The files contain various investor types and their information. Key Requirements: - Combine all information from the original files into the new table. - Prioritize the organization of the table by investor names. - Categorize the unified table by investor type. Ideal Skills and Experience: - Proficient in Excel with strong data handling skills. - Experience in data consolidation from various file types. - Ability to categorize and format data in a logical manner. Please note, I want all the information from the original files to be included in the new table. The final product should be an easy-to-navigate table that is organized ...

...to store, edit, view BOM. - Functionality to filter data based on all possible fields with multi level sorting. Allow full flexibility for user to filter and sort data based on multiple fields. - Report generator to generate all types of reports. User selects multiple fields and multiple sorting options to generate reports to track consumption and show inventory levels. - Import/export data to Excel format - Backup/restore database - Page to add/view/delete suppliers - Settings page to manage various options and create look up tables for various fields. - Data display must use pagination - Access & activity logging Your responsibilities will include: - Designing and implementing the web interface - Ensuring the system is robust and able to handle a large amount of data - Ma...

I need a detail-oriented virtual assistant to help with data entry tasks. The primary responsibilities will include: - Inputting data from a specific website into spreadsheets. Ideal skills and experience: - Proficiency in using spreadsheets (Excel, Google Sheets) - Previous experience in data entry - Strong attention to detail - Ability to work independently and meet deadlines.

...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...

...who can assist me primarily with creating engaging presentations in PowerPoint. Your role will also encompass data analysis in Excel and document formatting in Word. Key Responsibilities: - Crafting compelling PowerPoint presentations, inclusive of custom graphics and charts, animations and transitions, and overall template design and layout. - Conducting thorough data analysis in Excel. - Formatting documents in Word to a professional standard. Additionally, I require assistance in boosting my Instagram followers and likes organically, without risking a ban on the platform. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (PowerPoint, Excel, Word). - Exceptional graphic design skills, particularly for creating PowerPoint presentations. - Exp...

...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...

I'm looking for a proficient software developer to create a Desktop application for managing our company's incoming and outgoing documentation. This project aims to transition our current system, which relies heavily on MS Excel and VS Code, to a more streamlined and efficient software solution. Key Requirements: - The software should be a desktop application, specifically designed for Windows operating system. - It should incorporate functionalities for automated data entry, and reporting and analytics. - Ideally, the software will transform our current manual processes into a fully automated system, significantly improving our operational efficiency. Skills and Experience: - Proficiency in desktop application development, with a strong focus on Windows systems. - Exten...

I'm seeking a skilled ASP.NET developer to create a simple one-page application for report display. The design should be modern and minimalist. Key features of this project include: - **Report Grid**: The grid should include sortable columns, pagination, and search functionality. - **Export Functionality**: The application should support exporting reports in Excel and PDF formats. - **Design**: A clean, modern and minimalist design is crucial for this project. I will handle the ADO connection string and SQL command creation. Proficiency in ASP.NET and web form development is required. Experience with creating interactive report displays will be a significant advantage.

...an experienced MS Excel and Word instructor for live one-on-one sessions. Here’s a curriculum to teach the basics of Microsoft Excel and Word, structured over four weeks. Each week focuses on progressively building skills. This plan assumes 1–2 hours of daily study. after 4 weeks training , there has to be another 1 month of hand holding. Week 1: Introduction to Excel and Word** ### **Day 1: Getting Started with Microsoft Office** - Overview of Microsoft Excel and Word. - Installing/setting up Microsoft Office on your computer. - Familiarize yourself with the Ribbon, Toolbar, and Navigation. ### **Day 2: Basic Navigation and Layout** #### Excel: - Opening, saving, and closing Excel files. - Understanding rows, columns, and ce...

I am looking for an experienced Quantity Surveyor for a commercial construction project. The role will require a commitment of at least two months and will involve: - Cost Estimation: Accurately est...construction project. The role will require a commitment of at least two months and will involve: - Cost Estimation: Accurately estimating costs for various project components. - Contract Management: Overseeing contracts to ensure compliance and manage any necessary amendments. - Material Quantity Take-Off: Determining the required quantities of materials for the project. Proficiency in Microsoft Excel is a must, as this will be the primary tool for cost analysis and projections. Experience in commercial construction is essential, while familiarity with AutoCAD or Procore would be adv...

I'm looking for a comprehensive list of church emails across the United States. The list should be segmented by size of congregation, denomination, and state. Ideal Skills and Experience: - Proficient in data collection and organization - Familiar with Google Sheets and Excel - Prior experience in generating email lists - Ability to send emails on my behalf This project involves: - Providing a segmented list of church emails - Sending an email to all contacts Please note that the source of email collection was not specified. However, the following sources are encouraged: - Church websites - Public directories - Social media profiles

...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the

I'm in need of an Excel expert who can create a mathematical function for me. Key Requirements: - The function should focus on financial calculations, specifically for budgeting and forecasting. - I need it to assist me in planning and managing my finances effectively. Ideal Skills: - Proficiency in Excel, particularly in creating complex functions. - Strong background in financial mathematics. - Experience in budgeting and forecasting. Please include examples of similar projects you've completed in your proposal.

I'm looking for an experienced freelancer who can create a tutorial video for Microsoft Excel using screen recording techniques. Key Requirements: - Proficiency in Microsoft Excel is a must. - Experience in creating screen recording tutorial videos. - Ability to convey complex information simply and clearly. The final deliverable should be a comprehensive, easy-to-follow, and engaging tutorial video that covers various aspects of Microsoft Excel.

I have a spreadsheet with 1489 rows that contains Company Name and Director's First and Last Name. I need you to find email and LinkedIn for each person. I am prepared to pay $0.03 per row (email + Linked), so that's $45 in total if you find all ...person. I am prepared to pay $0.03 per row (email + Linked), so that's $45 in total if you find all of them. Details: - All of these contacts are UK-based and are director's in homecare agencies and care homes, so don't put anyone from other countries or other industries... - We will check each entry for the correct contact and for the correct email / LinkedIn. I will only pay for the completed cells. - Please check all emails for bouncebacks (with tools such as MillionVerifier) - Needs to be done in under 3 days...

I'm in need of a detailed construction estimate in Excel for a residential/commercial new build. The estimate should encompass all aspects of the project costs, including: - Material costs - Labor costs - Permit fees - Subcontractors - Suppliers - Payments The ideal freelancer for this project should have extensive experience in construction estimating and Excel, with a keen understanding of both residential and commercial construction costs. Please provide samples of similar work you've done.

I've converted my inventory book into an Excel spreadsheet. I'm looking for a freelancer who can upgrade this into a more sophisticated, user-friendly inventory system, with specific features and improvements. Key Features: - Automated stock updates: This will assist in keeping track of the inventory in real-time, without needing manual input. - Real-time analytics: I want to have insights and statistics about my inventory at my fingertips. - User access controls: I need to manage who can see and interact with different parts of the inventory. Interface Preference: - The upgraded system should have a spreadsheet-like interface. I am comfortable with Excel, and a familiar interface would make it easier for me to adapt to the new system. Areas for Improvement: - Th...