Vba sum multiple criteriacông việc
Software to automatically render video lyrics: - Get a list of songs from Spotify Playlist (user enters the playlist link containing the song to be rendered) - Download audio from Spotify/ or use compatible audio from the database - Get SRT files for songs - Combine audio and SRT - Create videos, which can be combined with multiple audios if the user requests
Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.
Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .
Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng
Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,
Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Your task is to plan, how would you implement IoT-management and monitoring system. The overall architecture and used technologies. Just main ideas, not detailed architecture or implementation details. System needs to run on azure. IoT-devices communicate using Azure IoT Hub. IoT-sensors are configured thro...implement IoT-management and monitoring system. The overall architecture and used technologies. Just main ideas, not detailed architecture or implementation details. System needs to run on azure. IoT-devices communicate using Azure IoT Hub. IoT-sensors are configured through Device Twins. Data is sent from IoT-sensors as standards IoT Hub telemetry messages once every 20s. Same system will be used by multiple end-customers, so the access needs to be limited to data of their own...
Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel
Thiết kế cover của lịch block (không cần thiết kế cuốn block) Lên thiết kế cho 4 concepts sau (1 tk/concept): 1. Có chữ Lộc, đi chung với hình ảnh trái quít. Background đỏ theo kiểu chinese 2. Có chữ phước/phúc => theo chủ đề Gia đình thịnh, phúc sinh phú quý. Background đỏ theo kiểu chinese 3. Đàn én đi cùng với hình ảnh gia đình sum vầy. Background xanh lá theo kiểu hiện đại chút 4. Theo phong cách hoa lá mùa xuân, kiểu hiện đại Sau đó, khách hàng sẽ quyết định 1 concept và tiếp tục phát triển / chỉnh sửa trên concept đó. Số lần chỉnh sửa: 5-8 lần
Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi
Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất
Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty
Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu
Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v
Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel
- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
...Trial Key To Test Premium Version Of Facebook Social Toolkit Get Free Facebook Followers How To Download Facebook Videos Invite Your Friends To Like Your Page Join Multiple Groups Using Group IDs Leave All Facebook Groups At Once Like All Facebook Posts And Comments Message All Facebook Friends At Once Post On All Facebook Pages That You Administer Post On All Pages Liked By Facebook User Post On Multiple Groups At Once Premium Extraction Tools Premium Facebook Tools Privacy Policy Reject All Friend Requests At Once Remove Facebook Page Likes Send Birthday Wishes To Your Friends In A Single Click Send Multiple Friend Requests At Once Suggest Your Friends To Add Another Friend Terms Of Use Unfollow All Facebook Friends At Once Unfollow All Facebo...
...Trial Key To Test Premium Version Of Facebook Social Toolkit Get Free Facebook Followers How To Download Facebook Videos Invite Your Friends To Like Your Page Join Multiple Groups Using Group IDs Leave All Facebook Groups At Once Like All Facebook Posts And Comments Message All Facebook Friends At Once Post On All Facebook Pages That You Administer Post On All Pages Liked By Facebook User Post On Multiple Groups At Once Premium Extraction Tools Premium Facebook Tools Privacy Policy Reject All Friend Requests At Once Remove Facebook Page Likes Send Birthday Wishes To Your Friends In A Single Click Send Multiple Friend Requests At Once Suggest Your Friends To Add Another Friend Terms Of Use Unfollow All Facebook Friends At Once Unfollow All Facebo...
...Trial Key To Test Premium Version Of Facebook Social Toolkit Get Free Facebook Followers How To Download Facebook Videos Invite Your Friends To Like Your Page Join Multiple Groups Using Group IDs Leave All Facebook Groups At Once Like All Facebook Posts And Comments Message All Facebook Friends At Once Post On All Facebook Pages That You Administer Post On All Pages Liked By Facebook User Post On Multiple Groups At Once Premium Extraction Tools Premium Facebook Tools Privacy Policy Reject All Friend Requests At Once Remove Facebook Page Likes Send Birthday Wishes To Your Friends In A Single Click Send Multiple Friend Requests At Once Suggest Your Friends To Add Another Friend Terms Of Use Unfollow All Facebook Friends At Once Unfollow All Facebo...
...list in the National Skills Competition module. Key Areas: - Sales and Invoicing - Inventory Management - CRM One must possess robust experience in these areas and be prepared to handle multiple tasks efficiently. I'd appreciate if applicants could showcase their proficiency in Odoo development, preferably through examples of past work. Any relevant certifications or endorsements are a considerable plus. Ideal Skills: - Experience in Odoo development - Ability to handle multi-faceted tasks - Proficiency in Sales, Inventory Management, and CRM modules of Odoo. If you believe you fulfill these criteria, I'd love to hear from you....
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on: Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird D2101) systems...
Our client seeks a skilled contractor to manage a network of 40 WordPress blogs. This is a... firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administration expertise Strong security background with experience in infection cleanup. Proven ability to manage multiple websites simultaneously. Knowledge of SEO best practices. Excellent problem-solving and communication skills. Important: Our client's VPS experiences persistent infections despite current security measures. This role requires strong troubleshooting skills to identify and resolve t...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm in need of a professional who can develop a desktop application that can generate add...token. Some key details about the project include: - The token will be built on the Solana blockchain, so experience with this platform is essential. - The desktop application needs to support multiple operating systems – Windows, macOS, and Linux. - The address generation feature should be seamless and reliable. I'm looking for a skilled developer who has experience in creating cryptocurrency-related applications, particularly on the Solana blockchain. The ideal candidate should have a good understanding of blockchain technology and be proficient in developing desktop applications for multiple operating systems. Please provide your portfolio demonstrating your ex...
...Project Description: The tool will allow end users to upload tickets, logs, configs, and other pertinent files. It will parse, extract, and vectorize content to understand issues. An explainable ML model like LIME will then diagnose the problem and provide steps, code samples, etc to resolve it. The LLM will be RAG augmented based on a vector protocol of a list of sites to augment the LLM. Key Criteria for Success: Robust technical execution that meets core requirements Modular, extensible architecture for flexibility over time Quality, well-tested code delivered on time Clear, prompt communication throughout project Key Components: Text/file ingestion and vectorization Semantic similarity search in Milvus/SPTAG Local post-hoc model explanations Production-ready Flask/FastAPI U...
...**Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advant...
...**Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advanta...
I am looking for a skilled graphic designer for a logo redesign project. The goal is to deliver a fresh, modern design that represents our brand identity. I need changes in color scheme, typography, and iconography. I will provide ...color scheme, typography, and iconography. I will provide the correct HEX code (#33a1da) for the new primary color. The deadline for this project is one month. Skills needed include graphic design, logo design, typography, and color theory. A successful freelancer will be able to refresh and modernize our logo while staying true to our brand image. The designer will be responsible for creating multiple logo prototypes and presenting them for our consideration. If you have a portfolio showcasing your logo design skills, please include it in your ap...
I screwed up on the backend of my website. The site is I must have clicked something that removed all the links to...all the links to the socials on the sign up page. I need for someone to do the following: 1. Put the logos back up (it should just be a click of a button. I just don't know which one) 2. I'd like to add two more social link to the list. (patreon & buy me a coffee) 3. I'd like for each person who signs up to get an email thanking them for joining. 4. I'd like to make it so people can't sign up multiple times with the same email address. 5. On wordpress there are numbers for each person who signs up. If I delete a person the numbers don't change order. It would be nice if they did. This isn't a major thing if hard to do th...
I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly t...
I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits t...
We require an Excel list comprising 500,000 LinkedIn accounts, each including the login email ID (not contact email), name, and company name. The contacts must meet the following criteria: Title: Owner Location: United States Search Keywords: Restaurant, Automotive Repair, Towing, Tire, Jewelry, Pawn, Automotive, Pools, Boutique, Tile, Heavy Equipment, Chiropractic, Boats, Furniture, Lumber, Granite, Stereo, Trailers Project Deadline: Saturday 7:30 PM ( Indian time zone) To confirm your readiness to commence the project, provide me a minimum of 2000 completed rows that meet the specified requirements.
We're looking for a graphic designer to create a fresh, modern logo for a website rebrand. Current site is which will be rebranded as StudentTravel.pro. The ideal candidate will hav...logos. Key Requirements: - Use of Blue, Purple and Green colors from the current site (or complimentary) in the design - Logo must embody a Modern style - Target audience is educators, primarily female over 40 years of age - Incorporation of the full site name, '', in the design - No use of globes, airplanes or other tired travel graphics - Will need high and low rez versions in multiple formats, also a greyscale/bw version upon completion of the project Please reach out with any additional questions. Looking forward to seeing some great designs! Good luck...
...following tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data collecting: You will ...
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without dis...
...create an engaging metaverse with a cartoonish art style. The metaverse should be interactive with customizable avatars and support real-time multiplayer gameplay. Features needed: - Interactive Environments: Users should be able to interact with the world and objects within it. - Customizable Avatars: Users should be able to customize their online persona in multiple ways. -Real-time Multiplayer: The metaverse needs to support multiple users interacting in real-time. Interaction: The primary mode of interaction should be through keyboard and mouse controls. A detailed understanding of user controls in a 3D environment is important. Skills and Experience: - Expertise in 3js for creating 3D environments - Experience with creating customizable characters - Understanding ...
I'm in need of an experienced architect or interior designer who can create a detailed renovation plan for my old waterfront home in Annapolis, Maryland. The property has gotten into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, w...Excellent communication skills and ability to work collaboratively The selected freelancer will be expected to provide a comprehensive renovation plan that includes cost estimates, timeline, and material recommendations. A keen eye for detail and a passion for creative problem-solving will be highly valued. The winner will also be considered for receiving a contract to produce full plans for a lump su...
...helping businesses thrive in the digital landscape. As a forward-thinking agency, we specialize in providing comprehensive digital marketing solutions tailored to our clients' unique needs. From SEO and social media marketing to email marketing and e-commerce strategies, we leverage cutting-edge techniques to drive results and exceed expectations. Position Available: We are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about storytelling and creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth an...
I'm looking for a skilled trading view indicator developer to create an indicator based on fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert system that can be triggered by specific conditions. These...
I need a skilled PHP developer for a project that requires merging multiple images into a single template. The primary task is to overlay images on top of a template, creating a final image that is a combination of all the images. Key requirements include: - Merging multiple images: This project involves overlaying several images on top of each other to create a final composite image. - Positioning and Size: The ability to adjust the positioning and size of the images being overlaid is essential. While I prefer a simple drag and drop tool to adjust these parameters, the output should be precise. - Output Formats: The final image should be available in both JPEG and PNG formats. Ideal skills and experience for this job include: - Strong proficiency in PHP: Since this project...
I'm in search of skilled songwriters who can write engaging, catchy, and relevant lyrics fo...have over 40 reference tracks that I'll need you to work with. - Purpose: The tracks you'll be writing lyrics for are intended for promotional and maybe commercial use down the line. Ideal candidates will have: - A strong understanding and appreciation for rap, trap, and R&B music. - Proven experience in writing lyrics for a wide range of genres. - Ability to creatively adapt and work with multiple reference tracks Of me melodizing and flowing. - A portfolio or examples of previous work that demonstrate your songwriting skills. -$25 a song if they start growing after release the raise goes with the business so need to be comfortable hustling at first with commissions ...
***MUST HOLD PE LICENSE IN WISCONSIN, USA*** In this project, I'm looking for a Professional Engineer based in Wisconsin to perform a field evaluation of several luminaires for installation in a home remodel. Key Responsibilities: - Identify changes necessary to make luminaires comply with safety requirements. - Evaluate final version, write a report explaining th...explaining that they comply with safety requirements, write up any installation instructions for mounting, and apply PE stamp. Necessary Skills and Experience: - Certified Professional Engineer status in Wisconsin. - Understanding of electrical safety standards relating to luminaires. In summary, your task is to assist me in ensuring that the luminaires in question meet the necessary safety criteria in the WI e...
I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with acco...
I am looking for a highly experienced developer specifically skilled in Backtrader and Interactive Brokers integration to create an intricate trading strategy. Key components of this strategy include: - Incorporation of risk management tools to safeguard investments - Multiple time frame analysis for comprehensive market overview - Utilization of Exponential Moving Average (EMA) in decision making I require the strategy's entry and exit criteria to be based on: - Moving average crossovers to identify potential market opportunities - Identification of support and resistance levels to pinpoint price boundaries - Breakout strategy implementation to exploit significant price moves I am open to discussing other elements that you think might be beneficial to the strateg...
