Lost vba project cognoscô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
Cần tìm bạn viết Pinescript trên Trading View để bắn alert tính hiệu buy, sell dựa vào một số indication như RSI, SRC. Đồng thời tự động đặt lện trên Exness, có đặt stop lost , DCA hoặc take profit một phần hoặc toàn phần.
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ôi muốn thiết kế lại Logo. Thay Laday's Beauty center bằng LEO ngay chính giữa. Thêm nữa là Đổi Spa clinic & Academy bằng Beauty & Academy. Mà mất hẳn logo mở ẩn dưới hình. ________________________________________________________________ I want to redesign the Logo. Replace Laday's Beauty center with LEO right in the middle. Another is Changing Spa clinic & Academy with Beauty & Academy. That lost the open logo hidden under the picture.
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
I'm in need of someone proficient in embedding Google Analytics tracking code on my website. I'm using both a self-hosted WordPress and Siteground, and I have direct access to the theme files. - *Task:* Correctly embed the Google Analytics tracking code in the header of my WordPress website. - *Required Skills:* WordPress, Google Ana...WordPress, Google Analytics, HTML - *Experience:* Previous experience in similar roles will be highly valued. - *Considerations:* The code should be embedded correctly and should not affect the overall functionality and performance of the website. Knowing your way around both Siteground and WordPress is a must. This might be a straightforward task for a seasoned developer, but for me, I'm simply lost and urgently need it done. Pleas...
I am in need to restore my website from a backup file located on Cpanel. The site crashed and I have lost some data, but I have a backup that is 1 to 6 months old.
As a conten...core function of the website is to allow users to pay their utility bills. Hence, it has to be efficient, user-friendly and secure. - The selected candidate must be proficient in integrating the Payu payment gateway into the website. This will allow us to streamline all transactions. - The website needs a robust user management system. Users should be able to register accounts, log in, retrieve lost passwords, and have their own personal dashboard. - The ideal candidate should have a good grasp of web development languages particularly related with e-commerce websites. They should have hands-on experience integrating payment gateways and designing user management systems. Anticipate your informed bids and looking forward to a professional who can execute this task ef...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...
We have lost the original file We are sharing our branding and logo, we want it to be in white, transparent and black background "AskLego" Tag line "we empower your future"
...the product have been lost. This situation is further complicated as I have no record of sales or customer interactions related to this product. Shopify live chat support has been unable to assist. Given this situation, I need: - A professional who is highly skilled in data recovery and Shopify platform. - Experience in recovering lost data within Shopify is paramount. - Ability to work through the steps carefully and efficiently, to retrieve and repost my shop's product. If you have extensive experience in similar recovery or digital forensic projects your skills will be highly regarded. Please quote the reference "ShopifyProduct" and answer the following questions below: 1. Can you complete this task? 2. How long will it take? 3. What do you need to s...
I'm on the hunt for a talented screenwriter who can help turn my real-life story into an engaging screenplay. This project involves taking the pinnacle moments of my life, much like the twists and turns of a "Forrest Gump" type narrative, and translate it into a captivating script. The script should encompass the following key stages of my life: - Childhood - Professional career - Personal milestones The ideal candidate will have the following skills and experiences: - Exceptional storytelling that engages audiences - Experience in creating "based-on-real-life" narratives - Proficient in various genres, ranging from Action, Comedy to Romance Take part in this intriguing journey and help portray an authentic life story on the big screen. My father'...
I need an expert with in-depth experience in ZFS pool management on a Linux operating system. The data lost from the corrupted pool wasn't critical to our operations, but we primarily stored databases, and the loss was still a hassle. Your main responsibilities would be to: - Investigate the root cause of the pool corruption and provide a detailed report on your findings. - Suggest and potentially implement steps to prevent such incidents from happening again. Ideal skills and qualifications: - Extensive experience with ZFS and Linux systems. - A history of troubleshooting and resolving data corruption issues. - Prior experience with database storage and recovery. - Strong problem-solving capabilities. - Excellent communication skills to explain complex technical concepts in...
We are in need of a skilled software designer who understands the game of baseball and can create a fairly basic but somewhat complicated baseball data software. This software will work on both Microsoft and Apple platforms, focusing on tracking and recording baseball data for users of our baseball board (non-computer) game. After our game is played the user will enter in which team won and lost. Then the user will enter the name of each player by team and what he did during the game. For example, Babe Ruth came to bat 5 times, struck out once, walked once, hit 2 homers and 1 single. He had 3 RBIs. Statistics will be retained that will show cumulative data of an ongoing season so once a player is entered into the data base he can then be pulled up for additional record entry for ...
I'm seeking an experienced Shopify developer FLUENT IN ENGLISH who can proficiently set up an e-commerce store for selling physical products. Unfortunately, a Freelancer could not finish the work due to illness so someone with strong Shopify development tools will need to step in to finish the project. I have included two pages of feedback on where the site currently stand. Here's what I need: Most important, I truly need someone FLUENT in English. I have lost so much time on this project because I tried to be patient with people who misrepresented their language and development proficiency. FUNCTIONALITIES: 1. Complete the design and deliver a fully functional site that is "mobile first" in functionality AND 2. Has a functioning si...
I've forgotten my Gmail password and have never set up any recovery options. Unfortunately, I've also lost access to the recovery email associated with the account, so the usual recovery methods are unavailable to me. I need someone experienced in account recovery to help me regain access to my Gmail account. If you have a solution for recovering a Gmail account without using the normal recovery options, I'd love to hear about it. Ideal skills and experience for this job may include: - Expertise in account recovery - Advanced knowledge of Gmail's security features - Proven track record in similar account recovery scenarios
...manufacturer workshop, you'll need to develop a comprehensive solution that encompasses the entire workflow. Here's a breakdown of how you could approach each step: 1. **Job Order Management:** - Allow users to create job orders with reference numbers for each project. - Capture project details such as customer information, project specifications, deadlines, etc. 2. **Requisition to Store:** - Enable users to create requisitions for materials needed for a specific project. - Include details such as quantity, description, project reference, etc. 3. **Store Confirmation:** - Once the store receives the requisition, confirm the availability of requested items. - Update inventory levels accordingly. 4. **Stock Management:** ...
...necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de Excel que se está creando, incluyendo las funciones específicas que se espera que realice y los datos...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...
I am in need of a skilled individual who can meticulously extract table data from approximately 7500 pages of PDF files and transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in th...Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high volume of pages and can ensure that no data is lost or incorrectly transcribed in the transition f...
As a consultant, my email signature is my calling card. It's currently too big and I need someone with experience to carefully duplicate and slim it down to 400px(width) x 150px(height). Here are the key...Here are the key aspects I need you to achieve: - The majority of outlook users will see the email signature correctly as per the new slimmed size. - The design should be identical to the existing one. Skill & experience: - Proficiency in graphic design and HTML - Extensive experience crafting email signatures specifically for Outlook - Exceptional attention to detail to ensure no aspects are lost in the resizing process. Please note, no new design or creativity is required. The task is essentially to replicate the existing design in a much slimmer format, while ret...
As the client, I am looking for a reliable professional to build a customized Excel plugin that will ...to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. - All source code must be posted with c...
I'm in need of a skilled English translator who can provide a formal translation of a personal letter for me. Key Requirements: - Translate a personal letter from English to English in a formal tone. - Maintain the original context and sentiments of the letter while ensuring a professional and refined language. - Display exceptional language proficiency and cultural un...sentiments of the letter while ensuring a professional and refined language. - Display exceptional language proficiency and cultural understanding to cater to the nuances present in the original text. Ideal Skills: - Proven experience in translating personal documents, particularly letters. - Proficiency in English with a strong and formal tone. - Attention to detail to ensure no nuances or emotions are lost ...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any proje...
I have lost my old server I want to build a new one - setup WHM cPanel & migrate 2 website on it the website are on Python & laravel my Bud Get is 6 0 A u D
...I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis a...
I'm in need of a skilled professional who can convert an images into a DXF file optimized / symmetrical for CNC cutting. Key Requirements: - Expertise in DXF conversion: I specifically need the conversion to be high-detail, including all fine features of the original image, to ensure the CNC...specifically need the conversion to be high-detail, including all fine features of the original image, to ensure the CNC cutting is accurate and precise. Ideal Skills and Experience: - Proficiency in CAD software: You should be adept at using CAD software and have a keen eye for detail to ensure nothing is lost in translation from the image. - Prior experience with CNC and laser cutting: An understanding of how these machines operate and the requirements for their files is essential fo...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next...
...Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excellent communication skills, as the explanation of each step will be vital for the success of this project. ...
...should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered correctly. Ideally, the freelancer will have experience working with customer data and creating data rooms that are easy to use and analyze. Kno...
...was leading a group on a commercial caving expedition in Cueva Angeles. The group encountered a sudden rise in water levels within the cave's stream passage. Elba Vasquez Gonzales, one of the clients, was unable to escape to safety and got trapped by the floodwaters. Reyes heroically attempted to rescue her and managed to save her life, but tragically, he was carried away by the strong current and lost his life. This event was covered by several news outlets, with one article titled ‘Era un experto en las Cuevas’ by Julio Ghigliotty, published in El Nuevo Día on June 1st, 1999. However, I have not been successful in locating this article or any others from Puerto Rican sources. Possible sources that may have covered the event include the San Juan Star, E...
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
