Excel vba to fill formsроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
... В GET параметрах потрібно обов'язково передати наступні параметри: clientid - (обов'язкове) ідентифікатор партнера model - (обов'язкове) назва товару articul - (обов'язкове) артикул товару price - (обов'язкове) вартість одиниці (!) товару (крапка, як розділювач для копійок) quantity - (обов'язкове) кількість одиниць товару (за замовчуванням 1, якщо більше 5, то лендінг буде зменшувати до 5 шт.) img - (необов'язкове) лінк на фото товару в повному форматі, з вказанням домену і обов'язково з використанням https://, макс. розмір зображення - 130х130 пікселів. Сторінка створена як responsive, тому буде перебудовуватись залежно від розміру <iframe>, в яку її вставили. Мінімальна ширина - 320 пікселів. Шаблон адреси:
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
...бажаного результату! Лектор воркшопу - Ігор Стефурак - засновник Воркселератора. Шість років працює з потоком стартапів у акселераторі GrowthUP — керує акселераційною програмою. У 2016 запустив 4 веб-проекти, 2 з них продав. Ось детально: __________________________________ Форма для реєстрації: __________________________________ Посилання на подію у Фейсбук: З повагою, ITHouse.
...бажаного результату! Лектор воркшопу - Ігор Стефурак - засновник Воркселератора. Шість років працює з потоком стартапів у акселераторі GrowthUP — керує акселераційною програмою. У 2016 запустив 4 веб-проекти, 2 з них продав. Ось детально: __________________________________ Форма для реєстрації: __________________________________ Посилання на подію у Фейсбук: З повагою, ITHouse.
...бажаного результату! Лектор воркшопу - Ігор Стефурак - засновник Воркселератора. Шість років працює з потоком стартапів у акселераторі GrowthUP — керує акселераційною програмою. У 2016 запустив 4 веб-проекти, 2 з них продав. Ось детально: __________________________________ Форма для реєстрації: __________________________________ Посилання на подію у Фейсбук: Локація: проспект Степана Бандери 42/2 З повагою, ITHouse.
C# win forms Написати застосунок для роботи з оцінками студентів навчального закладу. Студенти коледжу оцінюються за 11 шкалою. Студенти університету – за 100 бальною шкалою. Розробити ієрархію класів (1 базовий, 2 похідних). В одному з похідних класів реалізувати оцінки коледжу, в другому – студентів. wi Атрибути сутності Оцінки студента університету ПІБ студента Група Назва дисципліни Оцінка з дисципліни (у балах від 1 до 100) Атрибути сутності Оцінки студента коледжу ПІБ студента Група Дисципліна Оцінка з дисципліни (у балах від 1 до 11) Вхідні дані зберігаються у файлі. Реалізувати функції: 1. Введення даних з файлу у колекцію 2. Реалізація запитів і перегляд результатів запитів 3. Введення і редагування оцінок у вікні форми 4. Видалення оціно...
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I need a specific excel sheet made up for me. Instructions for excel sheet: First, there should be cell A designated for company name. Cell B will be "customer cost" where the "single letter" value will be entered (see values/definitions below). Cell C will be "number of licenses" and will be a numerical value input by the user. Cell D will be the product of cell B multiplied by cell C. cell B multiplied by cell C equals cell D (p) * 10 = 100 (p) = 10 (see values/definitions below) cell A = MOCK company A cell B = (p) cell C = 10 (numerical value input by user) cell D = 100 Then, cell E will be "MSP cost" and will be the "double letter" value entered. Cell F will be the product of cell C multiplied by cell E. cell E mul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
...experienced Power Apps developer to create an application aimed at collecting and analyzing ideas from corporate employees. This app should facilitate data collection and reporting, contributing to our overall operational metrics understanding. Key Features: - Submission Forms: The app should have an intuitive form for staff to submit their ideas. - Commenting Feature: I want staff to be able to comment on submitted ideas, fostering collaborative discussion. - Dashboard or Reporting: The app should include a comprehensive dashboard or reporting functionality to visualize the data by team and by status to track trends over time. Ideal Skills and Experience: - Proficient in developing Power Apps with a focus on data collection and ...
I'm in need of an Excel expert to assist me with a data transfer task. This involves pulling information from one spreadsheet and adding it to a column in another. Key Tasks: - Transfer of text data from one spreadsheet to another - Matching of data based on an exact match in a single column - Formatting of some data during the transfer The data in the spreadsheets is a mix of both specific categories and plain text columns, and there are more than 1000 rows that need to be transferred. Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks - Ability to perform basic data formatting and transformation
Presupuesto 20 dólares de necesita en un día sobre todo enviar un vídeo de que la integración funciona Estoy buscando realizar la integración de los formularios creados con Gravity Forms con el CRM Verzia. Para ello, planeo utilizar el complemento Webhooks Add-On, que me permitirá conectar ambos sistemas a través de la API de Verzia, asegurando una comunicación eficiente y automatizada entre las plataformas.
I'm looking for a freelancer who can compile a comprehensive list of stock codes for all companies per year from the specified website - https://www.finha...ket-cap/. A spreadsheet should be created with a tab for each year. The stock codes should be obtained from Yahoo finance. For example, where the company name is Apple, I would expect the code AAPL to be returned. The specific requirements are: - The stock codes should be taken from Yahoo Finance - The data should only include the stock codes, not historical data or current status. - The final deliverable should be in an Excel file. Ideal skills and experience for the job: - Familiarity with stock exchanges and their coding systems. - Proficiency in data compilation and Excel. - Attention to detail f...
...assistance to extract data from a conference website. The task involves gathering information on all attendees and their respective companies. Key Requirements: - Extract a list of attendees and their information (Name, Title, and Company) and export it into a CSV file. - Create a secondary CSV file that lists all the companies in attendance (one column: Company). The data needs to be extracted from a publicly accessible section of the conference website. The task needs to be completed before noon EST on January 21st. I will make a decision on whom to select by 9:00pm EST on January 19th. Ideal Candidate: - Previous experience with data extraction and web scraping is preferred. - Proficient in using tools like Python, Excel, or any other data extr...
You must know Elementor very well to setup this Jetnews Wordpress website (). I have uploaded the template but have no idea how to connect the video upload to Rumble. Essentially I need to make the website work. I need users to be able to do the following. 1. Create a profile 2. Upload videos 3. Share videos 4. Comment and like videos 5. Create logins for Creators (Creators videos automatically go to top of page and their profiles. 6. X Feeds page 7. Link all social media accounts 8. I need to be able to delete, pause, or approve of videos and content. 9. News can be added by Creators (Connect to Rumble not Youtube) 10. The buttons at the should match the buttons on the side. I'm looking for an experienced Wor...
I have an Excel database consisting of 100,000 records of loan requests along with their acceptance status. I need a freelancer with strong expertise in Python, data manipulation and AI to develop an AI model that will evaluate new loan requests and predict their approval status based on the training from this dataset. Key aspects of the project: - Data Preprocessing: The data will require normalization, handling of missing values, and feature extraction. - Model Development: Using Python, you'll build an AI model to train on the database. - Prediction: The model will assess new loan requests and indicate if they should be accepted or rejected. The ideal candidate will have extensive experience with AI model development, and will be proficient in Python, and d...
Je evous contacte pour automatiser une tâche sous Excel. Celle ci n’est pas très complexe je pense ! J’ai un planning à tenir, avec des dates pour le projets initiales et je veux automatiser les dates de l’en-cours ! J’ai une date de départ, plusieurs actions a faire sur une pièce mécanique qui dure plus ou moins longtemps, de 1 jours à plusieurs semaines, avec 1 date intermédiaire qu’il me faut tout de suite définir puisque je dois réserver un équipement. Plus tôt il est réservé, mieux ça vaut. Les dates de l’en court peuvent changer régulièrement, en fonction de l’avancement réel contrairement au planning initial qui...
I'm looking for an expert in Excel to help me create a special spreadsheet that will collect and organize vital customer information. This project will involve detailed manual data entry. Key Requirements: - Collecting customer contact details (name, phone, email) and purchase history. - Organizing this data in an efficient and easy to understand manner in Excel. Ideal Skills: - Proficiency in Microsoft Excel. - Excellent attention to detail for data accuracy. - Experience with data entry and data organization. - Good understanding of customer data and purchase history. Please note, the data will need to be entered manually, so patience and diligence are essential for this task.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. call required before offering job to go over important details of the job NO EXCUSES POOR QUALITY WORK WILL NOT BE PAID ANY CRYING OR ABUSE WILL NOT BE TOLERATED ALL I AM AFTER IS FAST HIGH QUALITY WORK FROM A PROFESSIONAL. IF U CANT DO IT DONT APPLY. REMEMBER IM HIRING YOU COS I DONT HAVE THE TIME TO DO IT MYSELF. I CAN DO THESE IN MAX 3 HOURS PER SHEET. 1 SHEET ON AVERAGE SHOULD TAKE 3 HOURS. LATE WORK WILL BE PAID AT A REDUCED RATE AND ALSO ANY MISTAKES MUST BE ELEMENTARY. WORK MUST BE ALMOST PERFECT ON FIRST DRAFT AND PERFECT ON SECOND DRAFT OR PAY WILL BE REDUCED. DO NOT DEMAND PAY FOR WORK FULL OF ERRORS IF I SAY THE ...
I'm looking for a web-based application that allows users to create and manage standardized, reusable application forms. The platform should enable users to input their data once, customize sections for different purposes (e.g., job applications, college admissions), and export the completed forms in various formats such as PDF, Word Document, XML, JSON, and CSV. Key Features: - User Authentication: Simple and secure email and password login - Customizable Forms: Incorporate custom sections, pre-built templates, and a drag-and-drop interface. - Advanced Customization: Dynamic section management, section re-ordering, and conditional logic. - Multiple Export Formats: Ability to export forms to PDF, Word Document, XML, JSON, and CS...
Job Description: I need a Shopify expert to integrate Shiprocket payment gateway and auto address fill functionality on my Shopify product page. Please refer to the example site given below to understand the features I need. My budget is $5. This is a simple and straightforward task for someone experienced with Shopify and Shiprocket. Note: Only apply if you are confident in completing this task within the specified budget. Thank you! example site:
El proyecto es para entregarse en dos horas no busco persona improvisando Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.
...Follow-Up System Description: We are seeking an experienced Airtable expert to build a custom CRM and financial management platform tailored to our educational business needs. The system should integrate with Stripe and Skool, automate workflows, track student progress, and manage financial performance. Scope of Work: 1. Stripe Integration: • Set up manual Stripe payment links. • Migrate payment information to our Airtable CRM. • Automatically grant access to Skool community and unlock purchased courses based on the Stripe link/product. 2. Financial Module: • Record all transactions in Airtable, including Stripe fees and commissions. • Create a dashboard to analyze product performance. • Add recurring expenses ...
I'm looking to build a comprehensive e-commerce site, ideally using a React.js Backend with a Tailwind front end, or PHP/Laravel. The site needs to have several key features including: - Shopping functionality - UPI payment integration - WhatsApp API integration - Ability to upload products via CSV/Excel sheets - User recommendation form connected through WhatsApp API for scheduling meetings I would prefer MySQL as the database for this project. The admin panel should specifically allow me to manage product inventory. User accounts will use standard email/password, social login authentication. New freelancers are welcome to bid, but you need to demonstrate your skills or provide a detailed plan on how you intend to execute th...
I'm in need of a comprehensive database containing contact information fo...and Brokers) associated with @properties, covering all cities they operate in. The data should be structured in an Excel spreadsheet and must include: - Name - Address - City - Email (Any email addresses available) - Phone number - Company name Key Requirements: - I'm looking for as many contacts as possible, ideally in the thousands. - The email addresses do not need to be verified, but any available email is acceptable. - Prior to engaging in further conversation, I would like to see at least 10 examples of the data you've gathered. Please note that this task may be straightforward for those experienced in data scraping. A successful completion of this project could l...
...of a cross-platform (iOS & Android) mobile application designed for tracking medical treatments, capturing consent, and storing anamnesis data. The app should be tailored for use in dermatology and cosmetic surgery primarily. Key Features: - Ability to save and compare before/after pictures from various angles side by side. - Digital forms that can be filled out, signed and saved in a patient-specific directory. - Local storage for patient data, ensuring confidentiality and security. - An email function to send signed documents and pictures to clients. - A modern, user-friendly, and responsive UI suitable for all tablet sizes. - An integrated backend for administration within the main app. - Simple username and password authentication for users. Ideal ...
I'm in need of a seasoned tax professional to review my forms 5472 and 1120, and provide consultation on the same. The main areas of focus will be identifying potential errors in my existing documentation. All necessary documents are prepared and ready for your review. Ideal skills and experience include: - Extensive knowledge of IRS requirements - Proficiency in understanding form instructions and guidelines - Experience with forms 5472 and 1120 - Strong attention to detail in identifying errors - Consulting experience
...for a skilled professional to develop a modern and user-friendly website and assist with social media development and marketing efforts. The ideal candidate will have expertise in creating professional websites and executing effective social media strategies. Project Scope: 1. Website Development: Design and develop a responsive and visually appealing website. Ensure SEO optimization to improve search engine ranking. Include features like videos, images, contact forms, blogs, documents uploading/sharing features, analytics integration and others (home page, about, etc). 2. Social Media Development and Marketing: Set up and optimize social media profiles (e.g., Facebook, Instagram, LinkedIn, Twitter/X). Develop a strategy tailored to the target aud...
I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.
we have a home care website that need a developer to upgrade and we also want to build a website
...experienced web developer or development team to create a premium website for our hospital. The website should include advanced features such as online payment integration, appointment booking, and detailed information about our branches. Project Requirements 1. Website Design and Development Responsive Design: The website must be fully responsive and compatible with all devices (desktops, tablets, and mobile phones). User-Friendly Interface: The design should be intuitive and easy to navigate for all users, including patients and staff. Modern Aesthetics: The website should have a clean, professional, and modern look that aligns with our hospital's branding. 2. Key Features Online Payment Integration: Secure online payment gateway for patients to pay for serv...
I'm looking for a proficient web developer to create a user-friendly, web-based portal for project collaboration, which will replace my current cumbersome Excel sheet system. The primary goal is to streamline the process, enhance collaboration and make the project management more efficient. Key Requirements: - The portal should replicate the collaboration and comments features from my Excel sheets. This involves creating a space for team members and clients to leave feedback, ask questions and contribute to the project. - Incorporate task assignment and tracking capabilities. I want to be able to delegate tasks and monitor their progress within the portal. - Implement an admin and user role access control system. As the project ...
I need a comprehensive repo...tenants for a shopping strip mall in Mansfield, Louisiana. The priority is to fill the mall with service providers, but I'm also interested in retail segments such as home and decor, and education centers like Goodwill training. Grocery stores are also a key target. Key Requirements: - Utilize AI geographic status and national/local business information for creating the report. - Focus on statewide insights with the potential to attract national businesses. - Prioritize service providers (e.g., salons, gyms) but also include retail and grocery options. Ideal Skills and Experience: - Strong background in market research and business analysis. - Familiarity with the retail and service provider sectors. - Ability to use AI and ...
...events scheduled from 01.08.2023 to 31.01.2025. We’re using the “SimPlan” calendar to manage events, but I need help organizing and processing the data to generate actionable insights. Here’s what I’m looking to achieve: Analyze event workload based on type (automated study sessions, independent skills training, and non-study events) for specific time periods. Calculate instructor and venue utilization, including peak hours and percentage of usage. Understand student participation across different events and semesters. Compare growth in event frequency and duration between Fall 2023 and Fall 2024. Identify trends like most/least attended skill groups and time spent on events with keywords (e.g., “excursion,” “...
I'm in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriately sorted into separate columns for positive and negative amounts. Ideal Skills: - Proficiency in Excel is a must. - Previous experience with QuickBooks and CSV file formatting is highly preferred. - Attention to detail to ensure all data is accurately processed.
Call every new Facebook lead to get the essential information, explain how we work and set a zoom call consultation with them to register them to the premium program to start the auction Call and email the new lenders and the new leads coming from the research and marketing department Answer on whatsapp groups on time Check the HUD files before the client sees them Keep in touch with lenders Fill up the auction spreadsheets from the offers sent from the pricing engine team and emails teams
...who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me pro...
I'm seeking a comprehensive list of 70 rent-a-car companies in Dubai, specifically their CEO and Managing Director contact details. The final deliverable should be an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data collection and research - Experience in creating comprehensive, accurate spreadsheets - Understanding of corporate hierarchies, particularly in the transport and rental sectors Please ensure the information is current and accurate, as this will be crucial for my project. Thank you.
I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not using any filter criteria on the combobox data.
Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.
...(Optional but Beneficial) For handling complex data and simulations, some expertise in programming and computational tools is valuable. • Python or MATLAB • For analyzing star charts, light curves, and celestial simulations. • Excel or Data Visualization Tools • Useful for plotting and analyzing observational data. 5. Problem-Solving and Test-Taking Skills In addition to mastering these subjects, experts should: • Practice solving past USAAAO and international Olympiad problems. • Develop speed and accuracy in solving MCQ and computational problems. • Understand how to approximate and estimate efficiently. Recommended Course List: 1. High School/AP/IB Physics (Mechanics, E&M, Waves). 2. High School/AP Calculus AB/B...
I'm looking for a skilled web developer...graphic/photo content for my business. - Client Testimonials: I want to include some positive feedback from my clients to build credibility. - Contact Form: Essential for potential clients or collaborators to reach out to me. Skills and Experience Required: - Proficiency in web development and design principles. - Previous experience creating portfolio sites. - Ability to integrate interactive features like an image carousel, booking form and payment system for classes. - Skills in implementing user-friendly contact forms and displaying testimonials in an appealing way. - ensure it is hosted correctly with our existing hosting platform Please provide examples of similar projects you've complete...
We're a homestay booking website (like ,com/airbnb) The site is half-completed, our frontend developer has some emergencies and had to leave, looking for someone to cover him. website is built in react, tailwind, javascript, link to backend's APIs. This is what my frontend dev wrote for me to help find the new guy to cover: —Skillset Experienced in react, tailwind is a must experience in framer motion will be a bonus (if you dont know I expect you to learn quickly) -- Assist backend engineer with OAUTH set up (google, facebook, apple, alipay, text message, etc) -- work with APIs to connect frontend to backend -- add fields to forms and include zod validation -- Work with Amap API, stripe API, etc ...
I'm seeking a dedicated individual to filter and provide me a list of 2000 Instagram influencers. The goal is to identify suitable partners for a drop shipping venture who can make a promotional video of a product. Key Requirements: - Influencers should have between 1,000 followers - The primary content category of these influencers should be related to drop-shipping. An ideal candidate for this project would be someone with a keen understanding of the drop shipping industry and experience in influencer marketing and expert in filling and filtering data in Excel. Skills in social media analysis and data filtering will be highly beneficial. Please be prepared to demonstrate your ability to meet these criteria.
Proposal and Proof of Work Requirements for Dynamic Excel Sheet Development We are seeking an experienced Excel developer to create a dynamic, visually appealing, and proprietary tool for our loan officers. This tool will enable our team to present purchase and refinance scenarios to clients, offering detailed calculations, comparisons, and insights. It should reflect Cohen Mortgage branding, include precise mortgage insurance premium calculations for different loan programs, and be protected to maintain its proprietary nature. Project Scope and Features: 1. User Data Entry Inputs: - Property address - Purchase price - Down payment percentage - Loan amount (calculated automatically) - Interest rate (fixed or adjustable options) - Loan term (e.g....
