Excel vba insert formula in cellроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
...20 pages in length, will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business context - Experience creating financial presentations, especially for institutional investors - Ability to highlight key aspects of a business in a com...
Need to analysis current select columns using ChatGPT API
I need a freelancer who can assist me with data entry. The project involves extracting text from PDFs and inputting it into an Excel spreadsheet. Requirements: - Extract text from PDFs - Input text into an Excel spreadsheet - Format text with headings and subheadings, bullet points and tables as per the original PDF Ideal Skills: - Proficient in Excel - Detail-oriented - Good understanding of formatting - Experience in data entry
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
...an optional numpad (configurable via a parameter, e.g., ShowNumpad=true). - Ensure keys are touch-friendly (minimum button size: 48x48px for desktop touch screens). - Do not disable physical keyboard input (both OSK and physical keyboard have to work simultaneously)! Integration with MudTextField: - Automatically open the OSK when a MudTextField is focused. - Pressing a key should insert the corresponding character into the active MudTextField. Close the OSK when: - The user clicks the "Close" button. - The user clicks outside the OSK component. (The OSK should not close if the user clicks inside it or on another MudTextField that also uses the OSK.) 3. Service Class Requirements - Implement the service using dependency injection (re...
I'm seeking a fresher freelancer to assist with text data entry from digital text files into Microsoft Excel. Ideal candidates should have: - Basic proficiency in Microsoft Excel - A keen eye for detail - Ability to follow instructions accurately - Good understanding of text data - Commitment to maintaining confidentiality and data security This is a great opportunity for a beginner freelancer to gain experience.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
I'm looking for a dedicated freelancer who can assist with data processing tasks. The primary source files will be Excel sheets that could contain a variety of data types, including but not limited to financial data, product inventory, and customer information. Key Requirements: - Proficient in Excel with strong attention to detail - Able to handle a variety of data types - Experience in data processing tasks - Reliable and able to meet deadlines Ideal Skills: - Data entry - Data processing - Excel expertise Please note, the data could be of any type, so flexibility and adaptability are crucial.
I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all availab...not limited to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, ...
...content on various platforms like medium substack vocal media ✅ Handle call-to-action campaigns, SEO, and social media promotions. ✅ Research and implement growth strategies to expand online reach. ✅ Assist in executing new ideas, business strategies, and brand promotions. 2️⃣ Marketing Personnel (Part-time) ✅ Flood the web with the company's banners, posters, and videos. ✅ Handle mass content distribution across multiple platforms. ✅ Assist in basic marketing tasks & repetitive work. ? Flexible work schedule, long-term opportunity for the right person. ? Apply with your experience in digital marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking for candidates with mid-level exper...
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.
I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would be a sig...
I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.
...how to change and transform their lives. As an international teacher, I have taught in Australia, New Zealand, Peru, and Mexico and have assisted hundreds of people to find inner peace through yoga, meditation, & counselling. As a Coach and Therapist, I have pioneered a wholistic approach that assists people to transform their lives, using Yoga Therapy and Somatic Psychotherapy. This work has been recognised for assisting and affecting positive change in hundreds of people particularly those who suffer from anxiety and depression disorders. As am Empath & Intuitive I also communicate with animals and nature and teach people how to connect with the magic of life in this you want to create profound change in your life, I look forward to guiding yo...
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm in need of an experienced freelancer who can efficiently scrape sales leads from LinkedIn and Crunchbase. I want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline for pr...
I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.
...data untuk kebutuhan sales pipeline, segmentasi pasar, serta enrichment data ICP dan buying committee. 3. Membantu penyusunan laporan metrik kampanye, revenue, serta administrasi program awareness dan demand generation. 4. Kerja 4 Jam Sehari, Mulai dari jam 13.00-17.00 WIB secara online, wajib responsive Yang Saya cari: 1. Pengalaman dalam riset data, analisis, dan tools seperti Google Sheets/Excel. Familiar dengan teknologi CRM (LinkedIn, Salesforce, HubSpot, dll) jadi nilai plus. 2. Familiar dalam menggunakan tools dan teknologi seperti ChatGPT, Google Advance Search, Metabase, dan AI lainnya. 3. Detail-oriented, bisa kerja mandiri, dan mampu memenuhi tenggat waktu. 4. Kemampuan komunikasi baik, terutama dalam menyajikan data secara jelas dan terstruktur. Email to (Removed b...
I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner
I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.
...up for membership. Filter users based on membership type, registration date, etc. View each user’s details, including form data (e.g., name, contact information). Approve or disapprove membership requests if necessary. Download or export user data to CSV/Excel for reporting purposes. See statistics about user sign-ups, including total users, active/inactive members, etc. 5. Data Security: All user data must be securely stored (preferably using encryption for sensitive data such as passwords). User passwords should be hashed and not stored in plaintext. Admin should have access to manage user data but should only view sensitive information when necessary. 6. Design & UX: Responsive Design: The website should be responsive and work well on both desktop and mobile d...
I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.
I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus
I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.
I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .
Je recherche un professionnel ayant de solides compétences en Excel et en design pour améliorer la présentation visuelle d’un document Excel utilisé pour des présentations clients et la génération de rapports PDF. Domaines clés à améliorer : Mise en page générale Graphiques et diagrammes Schémas et illustrations Le candidat idéal devra : Avoir un œil attentif pour un design moderne et élégant Être capable de rendre les présentations clients plus attrayantes Améliorer l’esthétique générale du document Excel sans compromettre sa fonctionnalité Vous devez être capable de comprendre le fra...
I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.
I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.
I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel....
...requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The video must be of high quality. If there is no audio narration, a text narration in English must be provided. 2. The video must clearly show: 2.1 The creation of the file by you as a programmer...
...professional product insert designed and written for an electronics item. The insert should include usage instructions and customer service contacts. Ideal Skills: - Graphic Design - Copywriting - Knowledge of Electronics - Customer Service Representation - Print Design Experience: Expertise in designing materials for print, ensuring high-quality and user-friendly layouts. - Customer Feedback Analysis: Ability to analyze customer feedback to improve the clarity and usefulness of the insert. Tone: The content should be written in a formal and professional tone. Please follow our specific branding guidelines for the design and content. The primary goal of the product insert is to educate customers about the product item. The product insert...
I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.
I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.
Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant capacity (or ...
I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. -...
I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.
Renders de 5 productos ( primeros 4 del excel + muestra) con sus dos variaciones de cada uno
