Vba combination numberscông việc
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
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
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
...package name, download size, Android version, device dpi, apk md5, apk advanced features, apk upload time) import full content from Play Store. * Full Play Store Post details supported (links, text, images, videos, sounds, full content) * Automatically generate post categories or tags from Play Store posts * Atomatically generate a featured image for the post * Using Play Store API in combination with Google Knowledge Graph API * Smart Download Timing: This smart feature prevents any other web using our download link on their blog, because the download link keeps changing AUTOMATICALLY in every 24 hours * Tải ảnh về máy chủ tự động. * Tự động phát hiện và xuất bản bài viết khi có games/apps mới được xuất bản trên Googl...
...Exposing TOR Users On Using Chrome Extension Extract Emails Of Your Facebook Friends Extract Facebook Group Emails To Post On Them Extract Facebook Group Member Emails Extract Facebook Group Member IDs Extract Facebook Page Fans Extract Facebook User Likes Extract Group IDs of Facebook Groups Joined By Facebook User Extract IDs Of Your Facebook Friends Extract Public Phone Numbers Of Facebook Friends Facebook Account Manager Facebook Group Admin Transfer Facebook Group Member Tagger Facebook Group Transfer Tool Facebook ID Extraction Tool Free Facebook Tools Free Removal Tools Get A 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 Group...
...Exposing TOR Users On Using Chrome Extension Extract Emails Of Your Facebook Friends Extract Facebook Group Emails To Post On Them Extract Facebook Group Member Emails Extract Facebook Group Member IDs Extract Facebook Page Fans Extract Facebook User Likes Extract Group IDs of Facebook Groups Joined By Facebook User Extract IDs Of Your Facebook Friends Extract Public Phone Numbers Of Facebook Friends Facebook Account Manager Facebook Group Admin Transfer Facebook Group Member Tagger Facebook Group Transfer Tool Facebook ID Extraction Tool Free Facebook Tools Free Removal Tools Get A 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 Group...
...Exposing TOR Users On Using Chrome Extension Extract Emails Of Your Facebook Friends Extract Facebook Group Emails To Post On Them Extract Facebook Group Member Emails Extract Facebook Group Member IDs Extract Facebook Page Fans Extract Facebook User Likes Extract Group IDs of Facebook Groups Joined By Facebook User Extract IDs Of Your Facebook Friends Extract Public Phone Numbers Of Facebook Friends Facebook Account Manager Facebook Group Admin Transfer Facebook Group Member Tagger Facebook Group Transfer Tool Facebook ID Extraction Tool Free Facebook Tools Free Removal Tools Get A 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 Group...
Hello, We are looking for serious and accurate person for simple data entry job. You should copy some data from website that we will provide you (24 numbers per page). On the end of every working day you need to send us that data, that we can work on it. We will / can release milestone on every that day. Pls write PM with your bid or question and include in it this two word "Simple Entry". We will provide detailed instructions of the required task we need.. Work has to be exact with no mistakes. So patience and accuracy required!! Don't bid if you can't do that. We just need accurate person who want to do data entry job. After this task, we have two similar task, so if you are good we won't to change you. Serious newbies are welcome
In need of an expert logo designer for the creation of a unique, eye-catching logo for my Food & Beverage business. I'm interested in a combination of text and icon style logo, that will not only define my brand's image but communicate effectively to my target audience. Desired Skillset: - Proficient in various design software like Adobe Illustrator or CorelDraw - Have a creative flair for logo designing and art - Proven experience in creating logos in the Food & Beverage industry is highly regarded Please note: This project requires prompt execution; therefore, proposals indicating quick delivery times will be considered favorably. Thank you.
...English with impeccable grammar and attention to detail * Strong research skills and ability to quickly understand our business and funding needs * Excellent project management skills and ability to meet tight deadlines * Proficiency with common grant application formats and systems * Able to work and communicate effectively remotely Compensation: Freelance contract position compensated through a combination of a base fee per project/application and a success fee equal to a % of grant funds awarded. Exact terms to be specified in contract. To Apply: Please submit a cover letter , and 2-3 writing samples demonstrating your grant writing abilities to [insert email address]. In your cover letter, please describe your experience with grant writing and why you would be a strong fit ...
I need a market research-oriented individual with an expertise in data mining and web scraping. The project entails extracting data from the website harborfreight.com. Specifically detailing: - Product names - Product price - Product type (IE power tools) - Their associated number of custo...(IE power tools) - Their associated number of customer ratings These details should provided in a CSV file then be categorized by product type. A strong understanding of categorization and proficiency in scraping complex websites will be beneficial. With this data, I intend to carry out detailed market research. Do not worry about descriptions, focus solely on the product names, price, rating numbers, and categorization. I'm looking forward to seeing your proposals if your skills align wi...
I need assistance in creating a Python script that can dial a number through a VoIP service using the VCDial setup I have. The code should also play a pre-recorded message when the call is connected. The operating system I am using is Windows. Key Requirements: - Develop a Python script that can interact with the VCDial setup for dialing numbers. - Integrate the functionality to play a pre-recorded message once the call connects. - Ensure the script can run smoothly on a Windows environment. Ideal Freelancer: - Proficient in Python programming, with experience in telephony and VoIP setups. - Familiar with VCDial or similar systems. - Able to work effectively on Windows OS. - Prior experience in creating automated call systems or call centers would be a plus. My budget is not mor...
I screwed up on the backend of my website. The site is I must have clicked something that removed 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 (i...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 t...
I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to suggestions and recommendations.
...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 disrupting existing functionalities. Key Featu...
I'm in need of a striking, modern, and high-quality logo for my exterior company. The logo should be a combination of text and icon, aiming to convey a soft sunset orange hue. Key Points: - The logo should encapsulate the essence of our work which includes roofing, siding, gutters, and other exterior projects - We're looking for a modern style, which should not only reflect the durability of our work but also the beauty, hence the slogan "Beauty and Strength" - The use of a subtle aesthetic with a sunset over a roof in the icon would be ideal The ideal candidate for this job should have: - Proven experience in logo design, specifically in the construction or exterior industry - A modern design sense with a strong portfolio - The ability to balance both text an...
We need a full-featured mobile application on both iOS and Android platforms for comprehensive high school management, including a parental monitoring system. Here's what we're looking for specifically: - Parent-Teacher Communication: The app should allow easy in-app messaging, push notificatio...applying should have: - Experience in creating mobile applications for both iOS and Android. - Ability to implement communication features like in-app messaging and push notifications. - Skills in integrating document accessibility and scheduling functionalities. - Familiarity with creation of educational or parental monitoring applications will be a significant advantage. We're seeking a combination of superb technical skillset and deep understanding of educational mec...
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 will b...
...not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 middle shifts, i want a report table showing me this for all the employees. i also want to be able to edit the fields and tables ...
I'm in need of a modern and minimalistic logo that incorporates both text and symbolic elements into a single design. The ideal color scheme for the logo would be cool tones, primarily blues. I like logo in attachment.
...different products, our client requires you to design 1 or more (e.g., maybe 2 or 3) graphics that suggest a "cable" or "connector". We will provide the original artwork for the 3D boxes to the successful coder. The "cable(s)" or "connector(s)" should be designed in such a way, with a transparent background if necessary, that they can be "dropped into" a new marketing design project, alongside any combination of 3D boxes. *** All of the specific details and requirements of this project are carefully documented in the attached .PDF file. *** There is a keyword buried in the attachment that we mention clearly. Your bid proposal needs to include this keyword to demonstrate that you have taken the time to read the attached docume...
I urgently require a web scraper proficient in extracting data from xing.de. I will provide a file of specific company names, for which I want to obtain the number of employees. Your task will involve: - Gathering accurate and up-to-date data on the number of employees for each company on the list - Formatting the information suitably for my usability. You need to have proven experie...accurate and up-to-date data on the number of employees for each company on the list - Formatting the information suitably for my usability. You need to have proven experience in web scraping, particularly on professional platforms such as Xing. Familiarity with German language platforms is beneficial. The deliverable is a neatly formatted file containing company names and their respective employee nu...
I am looking for a skilled designer to create a 2-page A3-size dossier for a hotel project. This dossier will be presented to potential investors a...incorporate maps and photos to help potential investors visualize the location and the building itself. - Investment Opportunities: Your task will include gathering and organizing information about the investment opportunities this hotel project presents. This information will be presented in a suitable format for inclusion in the dossier. The ideal candidate for this project should have a combination of design and content creation skills. Attention to detail and the ability to distill complex information into a clear and visually appealing format is crucial. A strong understanding of the tourism and hospitality industry would be adv...
I'm seeking a skilled logo designer who can adeptly adjust typography on my existing logo to make it communicate our brand better. The logo is a combination type, incorporating both text and symbols. Key Requirements: • Proficient in working with combination logos • Exceptional typography skills • Ability to understand the brand and reflect it in logo modifications The successful freelancer will have a strong portfolio demonstrating their ability in logo design and font manipulation. An appreciation for brand identity would be particularly valuable for successful completion of this job.
...The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send the smaller Excel sheets to the WhatsApp numbers of school coordinators. Each coordinator's WhatsApp number is provided in the Excel sheet. Error Handling: The script should include error handling mechanisms to manage any potential...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique identifiers. - Be detail-...
I need a system that automates some feature on my website, focusing on identifying specific numbers and responding accordingly. Main Features for Automation: - Identify 1-digit numbers from the website - Track 10 consecutive numbers less than 2 - Upon detection, the system should: - Fill amount and apply for bet. Ideal Skills and Experience: - Proficient in web automation - Experience with identifying and tracking specific data on websites - Ability to integrate a betting mechanism in the automation process Please note that this project is not for developing a betting site. It's focused on automating a few select features on an existing website.
We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the pr...
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have a contract that needs formatting and aligned with headings and numbers. Is a bit all over the place. Approx 16 pages. Content is all there. Just needs to be presented well. Need ASAP so please only bid if available to complete now.
STRICLY NO A.I (there is always spelling mistakes) I'm in need of a professional logo designer for my company, Precision Pipe Repair. The logo will be an abbreviated version, featuring the initials 'PPR' along with a combination of text and symbol. Logo : PPR Company Motto : Second To None Key Requirements: - Initials (PPR) should be the central focus of the logo - A combination of text and symbol should be included - The design should exude an aura of prestige and look perfect on a trucker's hat, polo shirt, etc. - The theme colours of the logo are Green and Black, in line with our existing logo Font Style: - The font should be bold and modern, but also reflect strength, futurism, technology, and professionalism. A robotic style is desired. Shape o...
I'm in need of a PowerApp expert to assist with the data input and validation aspects of my project. The data I'm working with is fairly simple, mainly consisting of text and numbers. ( required only technical support online) Key Responsibilities: - Implementing advanced data validation: This includes cross-field validation, custom business rules, pattern matching and range validation. Ideal Skills: - Strong PowerApps development experience. - Proficient understanding of data validation principles. - Ability to craft custom validation rules. - Ability to think creatively and solve problems effectively. This is a challenging project and I need someone with a high level of expertise in PowerApps to ensure the implementation of precise and effective data validation.
I'm seeking a talented developer to construct a standalone Google Sheets module, specifically designed for the intuitive verification of GSTIN numbers. Key Responsibilities: - Crafting a module capable of validating GSTIN numbers to ensure they're correct. - Enabling lookup functionality to fetch respective company details using provided GSTIN numbers. - Designing formulae for automatic GST amounts calculation according to the obtained details. What I'm Looking for in the Proposals: - A comprehensive and detailed project approach indicating complete understanding of the module requirements and successful execution plan. Ideal Freelancer: - Proficient in Google Sheets, with substantial experience in building custom modules. - Basic understanding of GS...
I'm in need of a talented 3D designer that can create realistic renders of melamine furniture pieces. - The furniture type is melamine, and it will consist of a combination of kitchens, wardrobes and tables. - The finish for this furniture is a custom color, which will be provided by me. - I'll need the designer to work on standard dimensions for the pieces, as I don't have specific measurements. Ideal Skills: - Proficiency in 3D design software - Experience in rendering furniture with decorations - Ability to work with custom colors - Understanding of standard furniture dimensions - Attention to detail and a keen eye for realism Please provide samples of previous work in a similar vein.
I'm seeking an expert research...school has one, if a chair can not be found clerk of Governors acceptable. Site to help The budget is $100 no more - please send a sample of 10 to 20 Governors Key requirements include: - The list should be organized alphabetically by county/area - I need contact details to include email addresses and phone numbers. Your experience with web research, data mining and data entry will be crucial to successfully carry out this task. Knowledge of educational institutions and contact compilation is key. Please ensure that the details gathered adhere strictly to public schools only. I expect high levels of accuracy, so skills in precision and attention to detail are crucial.
