Vba unlock projectcô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
Xin chào! Chúng tôi đang cần tìm Dev cho dự án game thiếu nhi dạng dollhouse như: Pepi house, Toca boca, Miga town. Link youtube tham khảo: - Game sẽ có hai phiên bản tính phí và free với in app purchase , video reward, unlock room. - Dev hỗ trợ submit cho đến khi Game lên store thành công. - Giao source code khi hoàn thành game Ưu tiên ứng viên ở Tp. HCM có đội nhóm để back up cho nhau, tránh tình trạng trễ deadline
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
...confirm the shipment. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to the courier for confirmation. Technical Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel fil...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
...connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to be found. (399 USD, INCLUDED!) ➡️ Numerous attachments with client conversation pipelines, strategies, tools and much more! (199 USD, INCLUDED!) ➡️ Dive into biweekly live streams with the masters, ask anything you want, and pick up secrets they don't just share w...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
...connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to be found. (399 USD, INCLUDED!) ➡️ Numerous attachments with client conversation pipelines, strategies, tools and much more! (199 USD, INCLUDED!) ➡️ Dive into biweekly live streams with the masters, ask anything you want, and pick up secrets they don't just share w...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
...an accelerator pedal, brake pedal, ignition switch, hazard switch, and door lock button. If the control unit determines that a pre-set charge stop operation has been performed at the input unit, it determines that a charge stop request has been input to the input unit. The charge stop operation is a predetermined continuous operation to the input unit, including multiple operations of the door unlock button. Also, the input unit may be a charge stop switch operated by the user. Furthermore, the charging system includes a charging device containing a charging connector, and a vehicle designed to receive power from the charging device. The vehicle is equipped with an input unit connected to the charging connector installed on the charging device, a control unit that communicates wi...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
...connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to be found. (399 USD, INCLUDED!) ➡️ Numerous attachments with client conversation pipelines, strategies, tools and much more! (199 USD, INCLUDED!) ➡️ Dive into biweekly live streams with the masters, ask anything you want, and pick up secrets they don't just share w...
I'm urgently seeking a creative mind to design a high-impact logo for my brand and social media presence. I regretfully omitted my preferred color scheme but let's unlock your creativity to give my brand a magnetic appeal. The ideal candidate will have: - Experience in designing expressive logos - Ability to work fast, creatively, and under pressure - Sensible use of trendy color schemes in logo design Your effort will significantly contribute to strengthening my brand recognition across different platforms, an achievement I am most passionate about. Looking forward to viewing your bid. Let's give my brand an unforgettable face!
I need a professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpati...available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...platform. I need the following customizations: - Custom Functionality: The current 'unlocking' mechanism based on Followers and Subscriptions needs to be modified. This will require a deep understanding of how the current mechanism works, and the ability to make the necessary alterations whilst ensuring the overall functionality of the site is maintained. Instead of Following or Subscribing to unlock content, content will be unlocked after completion of affiliate offers. This includes backend modification to add affiliate offer links based on country of visitor, and integration with the affiliate network through API and postback scripts so affiliate statistics and earnings can be tracked from the backend. - Custom Integrations: I also require the integration of a new...
I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of inv...
I'm seeking a skilled professional to develop a Solidworks macro for spec...intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as re...
I'm looking for a skilled video editor to help me out with a project. The task involves: - Editing a video where the final video is less than 5 minutes long - Primarily cutting and trimming the video to make it suitable for YouTube Experience with creating content for social media is definitely a plus, as is a good sense of pacing and timing. Your editing should enhance the video's impact and make it more engaging. It should tell a story and why I should be hired as a mentalist and mindreader. To start the video "The man we brought... to Dan Chan (starting at 0:05 to 0:15)" from this video Then the the "Dan Chan's" from 0:03-0:07 from this video From there you can use clips from the following videos:
I have multiple Excel spreadsheets containing c...I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the project are essential. Please include your relevant experience and any strategies you would utilize to ensure an efficient and precis...
...the logo to include both a symbol and text, with the symbol being a key element. The symbol should be representative of the key themes of life coaching and holistic well-being. Overview: First Me Coaching serves as a catalyst for transformation, committed to guiding individuals on their path to self-discovery and holistic well-being. Their approach is centered around empowering individuals to unlock their true potential, gaining valuable insights into their strengths, and embracing intelligent and authentic healing methods. They offer a range of services including coaching, mentoring, education, and personalized advice on lifestyle, diet, and imbalances. Using techniques like NLP and Ayurveda, they aim to support individuals in nourishing and nurturing their body, mind, and soul...
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.
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 mod...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
...subscription and plugin selection . Every single feature and plug-in must be in control of super admin which can add/remove from any subscription plan or tenant . The platform will be built on tenanacy for laravel boilerplate () which will provide you readymade tenant creation with subdomain and superadmin laravel nova panel and others . you have to move project on with upgradation of client admin featured with - * Client"s user management . * Staff section . * Rider/shipping section . * Store/client profile management . * Theme section . * Flash sale/Offer Section . * Blog section .( Feature ) * Product Management ( catagory , brand , child catagory etc ) . * Payment Integration: ( paytm , phone pe, google pe , razor pe , paypal , pay u .( mainly
...Locking Mechanism: Trigger a locking mechanism when a user fails to make a repayment on time, restricting access to certain app features or the entire phone. Lock Screen Interface: Display a lock screen interface with instructions for resolving the outstanding payment and unlocking the phone. Communication with Users: Notify users about payment status, consequences of non-payment, and steps needed to unlock their phone. Payment Options: Provide options for users to make overdue payments directly within the app, including payment portals and contact information for customer support. Unlocking Access: Remove the lock and restore full access once the outstanding payment is resolved. Emergency Access: Include options for emergency access or contacting support in case of emergencies. ...
Are you a passionate digital marketer with a proven track record of driving sales? Do you want to make a real difference in people's lives? We're seeking a skilled freelancer to promote a life-changing book, "Anhedonia Survival Guide", designed to empower individuals struggling with anhedonia. What is Anhedonia? Anhedonia is a debilitating condition that robs people of the ability to experience pleasure. Our book, "Anhedonia Survival Guide", has already proven its value in the market with strong digital sales. We're looking to expand its reach and impact even more lives. Here's what we offer: A highly impactful product: "Anhedonia Survival Guide" is a proven resource that provides hope and practical strategies for coping with anhedoni...
...five percent (5 %) is for Ali and the (5 %) is for Omid. So, from this balance Zakir gets (12$) twill, Ali gets two($1.5), Omid gets ($1.5) two also and the ($15) fifteen is for company ➢ Each level works as above. ➢ The payment should work automatically for example if someone invite members he will get his payment. Omid Admin ➢ Admin control all the users and transactions. ➢ Admin can unlock levels for users without investment ➢ The first account in this system is from admin. ➢ Admin should see all the users and control them. ➢ Admin can contact with users through e-mail and users also can contact to the system admin trough e-mail also. ➢ If someone reach to six hundred the system should alert to admin. ➢ The system should work with trust wallet directly. ➢ The com...
...can create an engaging crossword puzzle mobile app for both Android and iOS platforms. This would be very similar to "English Crossword Puzzle Game" app in functionality. Key Features: - Design should be fun and playful, engaging users while not being overly complicated. - Game should have multiple difficulty levels catering to all type of users - beginners to experts. - Users will use coins to unlock hints, answers and explanations; these could either be purchased or earned by watching ads. - In addition to coins, the game should have an option for an ad-free version purchase. - Backend should allow a no-code method of uploading new crossword puzzles Needed Experience: - Reasonable mobile app development on both Android and iOS platforms, with in-app purchase. - Ab...
