Vba sort numberscông việc
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
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
...Freelancer có kinh nghiệm thiết kế google sheet ứng dụng trong quản lý đơn hàng công ty với nội dung yêu cầu: 1/ Tạo excel trên google sheet có thể phân tầng quyền truy cập cho các cấp bậc nhân viên khác nhau trên mẫu excel google sheet có sẵn. ( quyền xem, chỉnh sửa , sort các cột/ dòng cụ thể) 2/ Thiết lập một hệ thống trên google sheet có sẵn với yêu cầu nhiều người có thể cùng truy cập sửa đổi , update excel tùy quyền hạn đã được phân ở mục 1. ( Vì với google sheet cơ bản thì nếu một người thực hiện theo tác- chẳng hạn như sort trên sheet thì tất cả mọi người khác đều c&...
...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
I have a project for custom Listbuilder development. I'm looking for a professional who can create a custom Listbuilder for me that collects email addresses, names, and phone numbers. The Listbuilder should have the ability to be integrated into my existing website. Ideal skills and experience for this job are: - Proficient in web development - Prior experience in building Listbuilder - Familiar with data collection APIs - Strong understanding of user experience - Excellent communication and collaboration skills I need someone who is reliable and has a good understanding of data security and privacy. The project requires a creative approach and a dedication to delivering a high-quality product.
I'm looking for someone to help with data entry tasks in an Excel sheet. This is a straightforward job with simple text and numbers to be entered. After the data is entered, I'd like some basic formatting - nothing complex, just basic formatting like changing fonts and colors.
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
I need a website that can generate e-certificates for users who've completed a course, but only after they've logged in with their phone numbers. Key requirements: - Generate e-certificates: Users should be able to download e-certificates for events which they participated. - User registration: We will provide you with a database of numbers who should be allowed to download. - Users should fill up a form which should contain their name age and the event of participation.
I need an experienced data entry freelancer to transcribe a medium amount of data from different digital files, including text and numbers. Ideal Skills: - Proficient in data entry - Detail-oriented - Familiarity with spreadsheet software Experience: - Proven track record in data entry - Experience transcribing from digital sources Please let me know if you are able to take on this project and your relevant experience.
I am looking for a skilled data entry specialist with advanced proficiency in excel. The project at hand is a one-time copy typing task. The task involves: - Entering a variety of data types into an excel spreadsheet (Text, Numbers, and Dates). - Creating a custom excel template with less than 10 columns. Ideal skills and experience for the job include: - Proficiency in using Excel, especially in data entry tasks. - Strong attention to detail to ensure all data is accurately entered. - Experience in creating custom excel templates is an added advantage. Please note, I will provide the document that needs to be copied and expect the resulting spreadsheet to match the information exactly.
..."cheat" template so my website gets DNS errors very often and gets malware. I want someone to re-do the website from scratch, unless you are confident that you can fix the error. Happy to discuss both options. Link: If the website is being done from scratch - I want at least 6 months of support with it, in case I counter the same issue again, so there should be some sort of retainer. Main Sections/Pages: - The website will include Home, About Us, Services, Portfolio, and Contact pages. It's important that each page is easy to navigate and visually appealing. Ideal Skills: - Proven experience in website redesign and development - Strong UI/UX design skills - Understanding of information architecture - Proficiency in the latest web design technologies such a...
I'm seeking a web developer who can expertly design and develop a slot booking website primarily for two types of users: customers and admins. Key Features: * The website should provide customers with an easy way to book slots. While booking, they will need to provide their names and contact numbers. * There should also be an admin-friendly interface to manage bookings. User Experience: * Both interfaces have to be user-friendly and intuitive, promoting seamless interaction between the customer and the admin. Website Specifics: * The website is aimed at offering 1 to 5 types of services. Hence, it should be able to accommodate this range. Ideal Skills and Experience: * Experience in web development, particularly with booking or scheduling systems * Proficiency in user in...
...wealthiest high-end individuals and families around our area. We also get occasional out of town well known celebrity visitors. What kind of people who don't want to be in public doing these kinds of tasks, or they just stay too busy to do them on their own. Aaron's like picking up their groceries or any sort of supplies that they may need for their household, or anything else that they think they may need. Sometimes they may even need help bringing an elderly relative or a child to some sort of appointment or a class. We have been operating around the area and the state and surrounding areas since the 90s. We know how to be discreet and get every client from another client's referral. We do not advertise or speak about what we do or who we do it for. That i...
I'm in dire need of an experienced Social Media Optimization (SMO) expert who specializes in Facebook, Instagram, and Twitter. I aim to amplify my brand visibility, increase website traffic, and of course, generate leads. Essential Skills and Experience: - Profound understand...campaigns. - Ability to identify and target desired audience demographics; specifically millennials and business professionals. - Expertise in content creation suitable for social media audience engagement. - Ability to analyse campaign analytics and optimize strategies based on data. Your role will directly impact the visibility and growth of the brand, so I'm looking for someone with a knack for numbers, creativity, and understanding of social behaviors. Previous experience in executing similar...
...mechanism. - **Performance**: Develop a script that prioritizes speed and responsiveness. This includes a Fast Loading Service, Improved Caching System and a theme page builder. The theme page builder will be particularly important to allow me to customize the design according to my needs. - **Admin Capabilities**: Implement features that may help improve security or admin and improve user list sort. Ideal Skills and Experience: - Proficiency in scripting languages such as PHP, HTML and CSS. - Experience with SMM panel development. - Proven track record in integrating payment gateways and APIs. - Strong background in cybersecurity and implementing security features. - Prior experience in developing User Management Systems. - Experience in developing fast-loading services and the...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm looking to leverage Instagram to generate more sales for my saree business. I want to create a marketing campaign that showcases the quality, design and variety of our sarees, targeting women aged 18-35 and saree lovers. Ideal candidates would: - Have experience in Instagram marketing with a proven track record of increasing sales - Understand the nuances of targeting and engagin...Understand the nuances of targeting and engaging such a specific demographic - Have a knack for presenting product features in an attractive, purchase-enticing way The campaign should strive to: - Emphasize the quality of our fabric, the uniqueness of our design and pattern and the wide variety our collection offers. - Connect with women aged 18-35 and saree enthusiasts - Ultimately drive up sales ...
...Responsibilities: - The primary responsibility of the freelancer will be to search, collect, and organize relevant data about potential Instagram influencers. This will include their follower count, engagement rate, niche, and other relevant information that will help us evaluate their suitability for a partnership. - The database should be easily accessible and user-friendly, with the ability to filter and sort based on different criteria. Ideal Skill Set: - Extensive experience in social media research and data collection, with a focus on influencer marketing. - Strong understanding of the Instagram platform and its influencer community. - Proficiency in using data management tools to organize and present the collected information in a clear and structured manner. This proj...
I'm in need of an experienced app developer to craft a seamless and fully functioning IPTV OTT application. The application must cater to a broad spectrum of devices and operating systems. Key Requirements: - Compatibility: The app n...streaming devices since the second question was skipped highlighting the non-exclusivity. - Capacity: Importantly, the app should be capable of supporting more than 100 channels. Ideal Skills and Experience: - Proficient in Android and iOS app development - Previous experience in IPTV OTT application development - Knowledge of integrating apps with TV platforms like Roku, LG Chromecast - Proven numbers in high-capacity apps handling 100+ channels. The developer should prioritize creating an efficient, easy-to-use platform that prioritizes u...
...existing UltimatePOS system to create a comprehensive Point of Sale (POS) system tailored for a mobile wholesaler. The customization should include integrating new features for inventory management using IMEI numbers, serial numbers, or non-unique identifiers, and expanding the system's capabilities to include transaction processing, customer and supplier management, financial tracking, and user access control. Responsibilities: - Customize the UltimatePOS web app to include the following functionalities: - **Inventory Management:** Adapt system to handle items via IMEI, serial numbers, or without identifiers. - **Sales Management:** Enhance system to process sales using item identifiers. - **Customer and Supplier Management:** Develop capabilities to st...
I'm seeking a skilled app developer to create a mobile application for ordering cakes. The app should be primarily designed for mobile devices and should be compatible with iOS and Android. The design should be easy to navigate and visually appealing, priori...their order etc. - needs to have spots we can mark payments, deposits, etc. Given that I'm looking for a mobile app specifically, experience in app development for both iOS and Android is crucial. Experience with e-commerce and online payment integration is a plus. It's also important that the app is reliable, bug-free, and easily maintainable. Not sure what this type of work costs, so budget is sort of open to realistic offers. Feel free to reach out with any questions and provide relevant samples of your ...
I am looking for someone professional to go over...professional to go over my website in full detail with a careful eye. I am looking for advice on changing the colour scheme to suit the brand/trade that we offer. Also, I am missing out on opportunities where the bounce rate is high on certain pages, so I would want something added like pop-ups to grab the visitor's attention to make the customer make the call to us or fill in the form, maybe some sort of offer? I can provide the analytics if required. Also, I would like my logo slightly rebranded if possible. In a nutshell, I am getting a lot of hits but need the enquiry take-up to be much higher. My only prerequisite for the seller is to be based in the UK due to the time zone and be 100% conversant in British English. Best...
I need to create a small educational program for work related to PLC. OBJECTIVE: I need to do a job, where a program reads 3 numbers and sorts these 3 numbers in ascending or descending order, and checks which one has the highest value. The software to be used is OMRON's CX-Programmer. The controller would be Omron's CJ1M. This work is for educational purposes so it should be simple but well structured. The structure of the program should have some similarities with the attached images (ATTACHED IMAGES ARE AN EXAMPLE ONLY)! Please try to use simple or the more commun functions. As it is an educational program, it must be as simple as possible, but at the same time it must be well structured to presentation. Thanks IMPORTANT: The software to use is CX-Programmer ...
...spreadsheet. === Data Points to Include for Each Card: 1. Name, Position, Company, Phone (include all numbers, Fax (if available) and correct country code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * The project will not be considered delivered if there are inaccuracies, hence you need to double check all numbers and words. * Note that 99% of the cards are in English. For cards with multiple langu...
I'm looking for a web scraping expert to help me gather personal profiles, email, and phone numbers from LinkedIn. The data I need should be based on broad search queries. Key Requirements: - Extract specific data: personal profiles, email and phone numbers - Data source: LinkedIn - Search type: Broad search query - Search criteria: Job title or role, Geographic location Ideal Skills: - Proficient in web scraping - Experience extracting data from LinkedIn - Ability to create custom search queries - Prior experience in gathering personal contact information
I am in need of a solidity developer who can incorporate a feature for swapping decimal numbers into an existing token. This task calls for: - An accomplished developer, versed in solidity. - The candidate ideally will have a background in actioning similar token system alterations. - I would appreciate reading about your previous relevant experiences in your application. If you have successfully manipulated token decimal numbers in the past, I would be especially interested in hearing about it. Your task will be to seamlessly add this functionality, making sure the existing token system is not disrupted. To reiterate, experience in similar projects will be a crucial factor in my decision-making process.
I require an extensive and careful research task to be undertaken for a list of 8,000 businesses across a region of the UK. I am looking for specific data points, such as: - Names of Managing Directors - Their respective phone numbers & email addresses - Best postal addresses and phone numbers of the companies - General business email address - Number of employees the companies have - Notes to be provided if no data The chosen Freelancer should have prior experience in accurate data collation and verification and be well-versed with up-to-date UK business registries or databases which must include the businesses website and LinkedIn. A keen attention to detail is necessary, as I require accurate, reliable data. Prior knowledge of UK businesses, particularly management h...
crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
...minutes: -Daily posting in various Facebook groups -Responding to Facebook messages -Inputting data into a spreadsheet from Facebook messages Next 1 hour and 30 minutes: -Comparative analysis of local home prices to determine probable selling prices (Training provided) -Providing offers to sellers (Scripts provided) Final 1 hour: -Calling Spanish and English-speaking sellers in Texas (Phone numbers and scripts provided) Incentive Bonuses Based on Performance Your dedication and hard work will not go unnoticed! I offer bonuses based on your results, allowing you to earn additional rewards for your performance! Prior experience isn't required, but ideal candidates should exhibit enthusiasm, a desire for long-term employment, organizational skills, and technological fluency...
