Vba project payroll programcô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
Bạn hãy xem mẫu ở file video đính kèm, hoặc truy cập đường link: Tôi cần sao chép trò chơi này sử dụng Client Cocos Creator, Server C# và Data SQL server
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
Cần tuyến 1 bản làm parttime. Hiểu về payroll bên Úc Kiểm tra, giám sát tính lương nhân viê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 muốn thuê người biết lập trình PLC. Nhiều dự án nhỏ.
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ông ty mình cần 1 bạn lập trình biết về autocad , có thể lập trình lại cad theo nhu cầu sử dụng của bên mình. Có thể đến cty làm việc hoặc làm tại nhà Ưu tiên các bạn đang sống và làm việc tại Tp hồ Chí Minh !
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
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 with...
...accounting practices and principles, with a proven track record of handling complex financial records and reports. This position requires precision and the ability to work under tight deadlines. Responsibilities: • Prepare accurate monthly, quarterly, and annual financial statements. • Manage general ledger, accounts receivable, accounts payable, and payroll processing. • Ensure compliance with all federal, state, and local corporate, payroll, and other applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. • Provide detailed analyses and explanations of all transactions. • Prepare documentation for ex...
"I am looking for an experienced programmer to develop a logistics management program with integrated travel services. Key features: Inventory Tracking: The system must efficiently monitor our inventory in real-time, updating stock levels when items are added or sold. I also need assistance with travel-related services. Specifically, I need the system to manage: Travel details: When we load the goods, divide them by type of merchandise, recipient, and number of contracts. Delivery tracking: Keep track of shipments in transit, providing real-time updates on their status. Payment tracking: Indicate whether travel services have been paid for or not, allowing us to monitor outstanding payments."
Hi i-Tech Art , I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I'm new to the Medium Partnership Program and have been creating primarily creative writing content on a monthly basis. I'm looking to significantly increase my program earnings. - Ideal Skills and Experience: - Proven results in earning through Medium Partnership Program - Familiarity with creative writing on Medium Platform - Strategically increasing posting frequency to maximize earnings The objective here is not just to create more content, but to generate higher-earning content. Thus, if you are adept at understanding Medium's algorithms and reader patterns, that's a great benefit. Proven experience in boosting Medium Partnership Program income is a must-have for this project.
User Authentication: User Interface: - Implement role-based access control to ensure that users only have access to features relevant to their roles within the company assigned by administrators and ca...are reviewed and approved by the appropriate authorities. - Include a calendar view and yearly holiday calendar to facilitate easy leave scheduling and tracking for both employees and administrators Attendance Management: - Record employee attendance through methods biometric devices and employees can view their hours worked, breaks, and overtime. Customizable Payroll Management: - Designate authorized users to manage payroll processes like uploading or deleting payslips for each employee and Allow employee access to payslips to download and view their current and past...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...Freelancer Bench Sales Recruiter who will focus on the IT bench sales for my company. Sr. Bench Sales Recruiter - Freelance (Commission Basis) Remote This is not a salaried position Need Senior/Experienced Bench Sales recruiters who can submit our candidates to Prime vendors and Direct clients. will pay commission per placement. This person can also bring in any other consultants on our payroll (Separate incentives for this) We don't need anyone who works on Job boards. Need someone with strong relationship in the market Job Types: Part-time, Freelance Ideal Skills and Experience: - Proven experience in IT Bench Sales recruitment is a must. - Strong network in the IT industry and access to potential candidates. - Proficiency in utilizing various sourcing technique...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
Project Description: I am seeking an experienced freelancer to develop an All-in-One AI-based HR Solution Platform entirely from scratch. This platform will serve as a comprehensive tool to streamline various HR processes and enhance efficiency across our clients' organizations. Requirements: The freelancer is required to develop a single platform capable of providing web and aap based services for product owner and client user interface, with the following functionalities: 1. Recruitment and Applicant Tracking: Streamline the recruitment process, from job posting to candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employees, ensuring a seamless tran...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineeri...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I'm in need of a skilled academic writer who can assist in developing a thesis (skripsi) on Education Research, particularly focusing on Curriculum Development. Requirements: - Knowledge in Education, specifically Elementary and Secondary levels - Skilled in Curriculum Development - Experience in academic writing Your main task will be to: - Create a comprehensive and well-researched thesis on the topic - Use a mixed methods research methodology - Pay attention to detail, ensuring the final product is of high quality and ready for submission. Ideal Skills and Experience: - Proven background in academic writing - Understanding of mixed methods research - Prior knowledge or experience in curriculum development - Education research expertise, especially in Elementary and Secondary ...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site country etc
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
Tiktok Fake Recharge Page / Program I am looking for a developer to create a fake recharge for TikTok coins. The project requires mimicking the actual TikTok coin recharge process as closely as possible.
I am looking for an experienced developer to build a program to provide a program that increases the number of live views for both TikTok and Bigo Live. The program should be open source and have option that i can create a password for it and give it to others for specific time. Your application should include: - Detailed account of your experience in this field - Examples of any similar projects Once hired, I would want daily updates on the progress of the project, to ensure all milestones and deliverables are being met within the designated timeline.
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualizati...a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previou...
I require a highly specialized freelancer to create a strategic marketing piece aimed to promote a 3rd party Medicare program. This marketing material is to be specifically designed to engage and encourage exploration from working professionals aged 25-65 Key responsibilities: - Developing an appealing marketing design that is aligned with the specifications and ethos of the program. - Ensuring the marketing piece resonates with our targeted audience, the working professionals (25-45). - Creating a marketing piece that not only informs but also convinces the target audience about the benefits of this Medicare program. Ideal candidate: - Proven experience in developing engaging marketing pieces. - Has a strong understanding of the target audience (working professional...
2 excel files with VBA macro as per customer requirement
...the context of developing algorithms for music programs. Key project details and requirements: - The primary goal of this project is to create an algorithm that can be integrated into a music program. - The algorithm should be able to perform beat detection and analysis, separate the voice from the music, and automatically generate lyrics as the song is played. Ideal candidate should have: - Proven experience in machine learning and AI development, with a specific focus on music-related projects. - Proficiency in developing algorithms for beat detection and analysis. - Skills in voice separation from music in real-time. - Capabilities in natural language processing for lyric generation. This is a challenging and exciting project for a skilled AI developer ...
I'm looking for a proficient developer to create an advanced HRMS module for Dolibarr v18. This module should streamline the following key aspects: * Employee Management: This should include employee profiles and record...and Attendance tracking: A robust tracking system is required. It should have a clock-in and clock-out feature, calendar integration for scheduling, and sync with biometric devices for comprehensive attendance tracking. * Payroll management: This feature is also critical. Ideal freelancers for this job should have significant experience in Dolibarr, HRMS systems, and integrations with biometric devices. Understanding of the employee lifecycle management is also beneficial. Please provide details of similar projects you've worked on, as well as your appro...
I require a comprehensive research on master's degree programs, with a specific focus on the fields of medicine and science. The main objectives of the project are: - Collecting relevant and up-to-date information on different master's degree programs in medicine and science. - Analyzing this data to highlight key features of each program. - Identifying any recent trends in this sector. The ideal freelancer for this job: - Should have experience in academic research and data analysis. - Must possess excellent organizational skills to present the information in an easily understandable format, such as graphs, charts, or clearly labeled spreadsheets. - Familiarity with the education sector or previous work experience related to medicine and science will be pref...
One excel file with macro as per the customer requirement
I'm currently in dire need of a competent C++ programmer to fix a bug in my existing code. The timeframe is extremely tight and the task must be completed ASAP. Key Requirements: - Strong command of C++ programming language - Experience in debugging and fixing errors in C++ code - Ability to work quickly and efficiently, under tight deadlines Your primary task will be to identify the issue causing the bug and rectify it promptly, ensuring the software runs smoothly. Your understanding of the codebase and the C++ language is crucial in this. Please respond only if you're confident in your ability to deliver high-quality work promptly.
