Advanced vbacô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ựng 3D model Ghế Ăn theo hình ảnh có sẵn. Yêu cầu cơ bản: 1. Modeling ở cả 2 trạng thái "mở ra" và "gập lại" của chiếc ghế ăn (tương đương 2 models). 2. Không cần quá advanced về vật liệu hoàn thiện của model. 3. Thông số kích thước (product parameters) như trong hình.

I’m looking for anyone who is mastered/ advanced in Blender to help me creat a mascot for my small business, the deadline is really close so I don’t need it to be too complex. Dm me if you’re interested and we’ll discuss together.

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

Mình cần 1 plugin fake review có lable " verified owners " + hook thêm 1 tính năng. là hiện liên kết từ Plugin Advanced Custom Fields vào shop_order. Ngôn ngữ: English

- 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

Chào anh Tu.... + Ionic, AngularJS, React(JS & Native), NodeJS, ... + PHP & MYSQL, HTML5, CSS3, JavaScript, jQuery, XML, JSON. + eCommerce, WordPress, Open Cart, Shopify, ... + Framework PHP CakePHP, Codeigniter, Laravel, Yii, Symfony 2,3, ... + Git. + Linux Server. - Advanced and best CMS Wordpress: + Install and config the project. + Plugin: Customize and create new plugin. + Template: Create, adjust the template (include design graphics or not) + Migrate & Upgrade: sustainable development and long-term. + Advanced SEO (search engine optimization). Team em đang làm website ở thị trường Việt Nam và cả Outsoucing cho nước ngoài. Đây là website của em: Hy vọng sẽ được hợp tác với anh. Tr&ac...

Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA

MAIN FEATURE * Tự động lấy lấy link download APK và upload lên máy chủ (Get full APK characteristics: version, 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ự...

VBA code help

I am in need of an experienced PMP tutor. - **Experience Level:** Advanced level of understanding in PMP is a must to ensure the quality and efficacy of the tutoring sessions. - **Learning Materials:** To make the tutoring program comprehensive, I'd like it to include: - Video Tutorials - Practice Quizzes - Interactive Exercises - **Tutoring Frequency:** I require tutoring three times a week to keep my learning pace consistent and on track. Ideal candidates for this project should have a deep knowledge of PMP concepts and have a seasoned track record of tutoring. You should be able to tailor the learning materials to an advanced level and provide structured, engaging tutoring sessions.

...English, my vocabulary for business English is lacking and this is the main area I want to work on. Ideal Skills and Experience: - ESL Teaching - English Linguistics - Business English Tutoring Understanding of the right technical, industrial and commercial terminologies is a must. Anyone who can offer specifically tailored instructions to help me bridge the gap between intermediate and advanced business English is welcome to apply. These are the things I expect from our engagement: - Interactive vocabulary building session focused on business English jargon and idioms - Provide reading materials, exercises, and homework with feedback - Conduct tests to measure my progress Fluency in English and experience in teaching business English to intermediate learners will be ...

...securities training. I will mainly be posting tutorial videos about stock market basics, investment strategies, and risk management techniques. Here's what I'm looking for: YouTube channel monetization of - **Video Editing:** I need a professional who can help with the full spectrum of video editing, including basic cuts and transitions and advanced effects and animations. - **Channel Monetization:** Since I want to generate revenue through my channel, I need someone with experience in optimizing videos for the YouTube algorithm and increasing monetization opportunities. Ideal skills and experience for this job include: - Proven experience in creating and editing YouTube content, preferably in the finance or training niche. - Strong knowledge

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

I'm after a talented freelancer with advanced skills in clothing design, specifically using CLO 3D Design software. Our project focuses on creating casual style tops. Key Project Details: - Primary Focus: Design tops - Design Style: Casual Experience Required: - Proficiency in CLO 3D Design Software - A solid background in creating casual style clothing Please note: No specific color preferences were indicated, so you'll have the creative liberty to experiment. Your portfolio in clothing design will have a significant impact on the selection process. Excited to see the creativity and innovation you can bring to our project.

I'm in need of a skilled developer to craft an AI-based firewall in a SaaS format. Features must include: - Real-time threat detection - Automated incident response - A user-friendly dashboard. The finished product will need to be hosted on a direct server. For security, it must meet these criteria: - Basic security measures - Advanced threat detection and prevention - Customizable security rules - DDOS attack prevention. Applicants with a strong background in AI, SaaS development, and cloud computing are desired, particularly those with experience in high-security IT projects.

Seeking a highly skilled .Net Developer to upgrade the existing system's back-end, ensuring it's user-friendly and solid. Key requirements: - Enhance system navigation and ease of use. - Optimize system performance for heightened stability. - Bolster security features for increased protection. The revamped system should be able to integrate with current mobile applications seamlessly. While specific app functionalities have not been defined, the developer should have prior experience with real-time data synchronization, push notifications, and user authentication. In terms of project timeline, the expectation is for this to be completed within a month. Ideal Skills: - Extensive experience with .Net Development - Prior experience with system optimization and security enhancem...

I'm looking for a skilled mobile app developer to create a versatile and user-friendly invitation app that can be used across multiple occasions including weddings, birthdays, and more. Primary Functions: - Sending digital invitations - Managing RSVPs Key Features: - Compatibility with both iOS and Android - Advanced level of customization for the invitations (custom designs and layout) Ideal Skills: - Proficiency in mobile app development for both iOS and Android platforms - Experience in developing apps with complex user interfaces for high customization - Knowledge of managing user data and RSVP systems - UI/UX design experience to ensure a seamless user experience - A keen eye for detail and the ability to achieve a polished final product If you have the required skill...

Hello! I'm looking for an experienced Person who can build the mobile device management (MDM) Server for iPhone device. Specifically, I need someone with expertise who can create a custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionality I need is for iPhone device enrollment and management. I do not have an existing solution that needs to be integrated, so will require a new solution to be built from scratch. Before showing interest on this job, Please read the below link and then you can bid for this job FYI: The ideal candidate has extensive experience developing mobile device management

I am searching for an experienced programmer with skills in vb.net or LabVIEW, or Labwindows. Your task will comprise the d...IXXAT USB-CAN Converter. It run on windows 2000 operating system Key Responsibilities: - Develop a program using VB.Net/LabVIEW/Labwindows, capable of implementing the CanOpen protocol - Program must be able to read and write data to the IXXAT USB to CAN converter - The software should control devices using the CanOpen protocol Ideal Skills: - Proficiency in VB.Net, LabVIEW, and Labwindows - Advanced understanding of CanOpen protocol - Experience with IXXAT Converters It's essential that the chosen candidate guide me through the installation and testing process until we have a successful operation. The program must be compatible with Windows 2000 Op...

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.

Project Background: We envision an innovative platform designed to transform how organizations, including startups, nonprofits, researchers, and small businesses, search for and apply for grants and funding. By leveraging advanced AI technologies and a user-friendly interface, aims to simplify and enhance the funding acquisition process. Objective: The primary objective of this project is to develop the Minimum Viable Product (MVP) for using the Bubble platform, incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project

I want a software, the device I use to print the output of the project I prepared as WebView, Image, and PDF is TSC, for this, it is necessary to use the connection method 'socket' with the IP and port 9100. Additionally, the '' library inside should be utilized for the application to run. The resources available are as follows, along with an example APK.

I'm in need of a pair programming expert who can help me enhance our React-based UI library's unit testing coverage. Currently, we're at 59%, but the goal is to reach 70%. Key Requirements: - React and Jest: I'm looking for an Advanced level React developer with strong experience in Jest for unit testing. You should have a solid understanding of React components and structure. - Pair Programming: The ideal candidate should have experience with pair programming, and be comfortable with real-time code collaboration and screen sharing.

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilit...substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alle...

Project Description: We are seeking a highly skilled High-Performance Computing (HPC) Engineer with expertise in shell scripting and workflow automation to assist in the evaluation and enhancement of the Parallel Works platform. The successful candidate will need to execute various tasks involving cloud cluster management, running pre-installed workflows, and handling both basic and advanced system integrations. Experience with MPI (Message Passing Interface), Singularity containers, and batch scripting is crucial.

I am seeking a skilled patternmaker to design an advanced level trench coat pattern for men. This design will have a 3D element of extension. Please find reference image. Key Requirements: - Detailed understanding of patternmaking for men's outerwear - Specific experience in creating complex coat patterns - Knowledge and understanding of French style design - Practical knowledge of standard men's sizes Ideal Skill Set: - Advanced patternmaking skills - Experience in men's outerwear designs - Familiarity with French fashion - Attention to detail

I am seeking a skilled patternmaker to design an advanced level trench coat pattern for men. This design will have a 3D element of extension. Please find reference image. Key Requirements: - Detailed understanding of patternmaking for men's outerwear - Specific experience in creating complex coat patterns - Knowledge and understanding of French style design - Practical knowledge of standard men's sizes Ideal Skill Set: - Advanced patternmaking skills - Experience in men's outerwear designs - Familiarity with French fashion - Attention to detail

I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. The developer should ideally have extensive experience in HR dashboard creation and a strong understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly co...

I need a proficient video editor who can deliver professional editing. This includes aspects of storytelling, advanced color grading, and sound design. The result I'm aiming for is a personal use video in a vlog style. Required expertise: - Advanced video editing skills - Familiar with vlog style editing - Proficient in storytelling, color grading, and sound design Ideally, you'll have a portfolio of vlogs or similar style videos that you've edited in the past. I'm looking forward to seeing how you can turn my footage into a coherent and engaging personal video.

...reverse proxy, and bash scripts for a personal project. This personal project is focused on web scraping. The successful candidate will be tasked with scraping product information, news articles, and social media data. Exemplary knowledge of proxifying requests through nginx and formatting bash scripts that interact with Nodejs applications is a requisite. Mandatory Skills and Experience: - Advanced proficiency in Nodejs - Extensive experience with nginx reverse proxy - Expertise in formatting bash scripts - Proven experience in web scraping, with emphasis on scraping product info, news articles, and social media data The ideal candidate must be able to present a portfolio demonstrating their competence in web scraping using techniques mentioned above. This project starts i...

...executed in real time after trade has completed. - Risk management tools: It should help manage potential losses and enhance profit chances. - Stop-loss orders and take-profit mechanisms: Essential features to control and protect my investment and keep overall drawdown below 5% - Advanced Algorithmic Trading: The bot should trade using complex algorithms and machine learning trading techniques The bot should be specifically designed to work with the trading platform. The innovative trading bot should possess advanced capabilities to identify new coins and snipe within milliseconds and utilize unique trading algorithms and strategies to ensure multiple profitable entry and exit points and take advantage of the trading environment. - Quantitative complex algorithms: The ...

Hello, I am seeking an experienced and independent full-stack web developer who can build an advanced Django application with a professional webdesign. I hope that we can build the trust to continue this collaboration for a very long time, as I hope to grow this business rapidly. Freelancer.ph forces me to provide information about the fee, but note that fees are negotiable. Also note that this is a fairly big project, meaning that you will be able to spend many hours on this project. The application enables website visitors to submit a quotation request to this platform, after which the platform allows registered service providers to reply to this request by uploading a quotation. The application supports numerous “topics”, such as fiscal services, legal services, ac...

I'm looking for an expert in Google Ad Manager who can help me improve my ad targeting for display ads. Key Requirements: - Improve my current ad targeting strategy and ensure the ads are reaching the right audience - Implement advanced targeting techniques in Google Ad Manager to increase the effectiveness of the ads - Provide insights and suggestions on how to optimize the ad targeting for better performance Ideal Skills and Experience: - In-depth knowledge and experience with Google Ad Manager - Proven track record of improving ad targeting for display ads - Strong understanding of audience segmentation and targeting strategies - Excellent analytical and problem-solving skills with the ability to interpret data and provide actionable recommendations If you have experienc...

...executed in real time after trade has completed. - Risk management tools: It should help manage potential losses and enhance profit chances. - Stop-loss orders and take-profit mechanisms: Essential features to control and protect my investment and keep overall drawdown below 5% - Advanced Algorithmic Trading: The bot should trade using complex algorithms and machine learning trading techniques The bot should be specifically designed to work with the trading platform. The innovative trading bot should possess advanced capabilities to identify new coins and snipe within milliseconds and utilize unique trading algorithms and strategies to ensure multiple profitable entry and exit points and take advantage of the trading environment. - Quantitative complex algorithms: The ...