Vba separate data rows columnscông việc

mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm

Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.

Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .

Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng

Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)

Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục

Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,

Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel

Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục

Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel

Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi

Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất

Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty

Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu

Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v

Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel

- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại

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

VBA code help

I am looking for a native female Vietnamese voice to record the following 3 sentences in separate files in mp3 format: 1) Cuộc gọi của bạn không thể được hoàn thành là đã gọi. Vui lòng kiểm tra số và quay lại. 2) Người bạn đang gọi hiện không thể nghe máy. Vui lòng để lại tin nhắn sau tiếng bíp. Cúp máy khi bạn ghi âm xong. 3) Ghi âm kết thúc.

We are looking for native Vietnamese speaker to record the following 3 sentences: 1) Cuộc gọi của bạn không thể được hoàn thành là đã gọi. Vui lòng kiểm tra số và quay lại. 2) Người bạn đang gọi hiện không thể nghe máy. Vui lòng để lại tin nhắn sau tiếng bíp. Cúp máy khi bạn ghi âm xong. 3) Ghi âm kết thúc. Please save them in 3 separate files in mp3 format. Thanks!

I am creating an xls file for an initial database load. I have several source xls files that need to be transferred into a primary xls based on the correct columns. I will provide the source files with the correct data to transpose. More details can be given once the job is accepted.

...skilled developer to create a high-quality Android casino app. Key Features: - User Registration and Login: Users should be able to create accounts and log in to play. - Casino Games: A variety of casino games will be integrated into the app to keep users engaged. - Payment Integration: The app should have secure payment gateways for in-app purchases and withdrawals. - Admin Control: I need a separate admin login with the capability to: - Adjust game rules: The admin should have the power to tweak rules to improve user experience. - Change game outcomes: Admin should be able to modify game outcomes to keep the experience fair and engaging. - Manage user accounts: The ability to oversee and moderate user accounts is crucial. Design Preferences: - The user interface m...

...the submitted designs are entirely original. Submissions that utilize pre-existing templates or closely mimic designs from platforms like ThemeForest will be outright rejected and may receive a negative review. The design must adhere to the features specified in our project outline while showcasing a distinct and fresh aesthetic. Design Requirements 1. User Management -User Registration/Login: Separate workflows for candidates and companies. Each form should gather specific information as per the provided documentation. Design should clearly differentiate between these two processes. -Email Verification & Secure Password Management: Interfaces for email verification links and secure password reset options. -Role-Based Access Control (RBAC): Interfaces that reflect differen...

I have two clips that I need to be edited into a single, captivating video. The purpose of this video is purely promotional. I'm aiming for a cinematic style of editing, as I believe this will best capture the attention of my target audience. Key requirements of this project include: - Merging two separate video clips into one seamless and engaging video - Employing a cinematic style of editing, to create an emotional and compelling narrative - Incorporating text overlays to deliver key information effectively I need the final product to be dynamic and unique, in order to stand out in the crowded promotional landscape. It should be professional, polished, and have a high production value. Ideal skills and experience for this job include: - Proven experience in video editing...

...functional living space. Key requirements include: - Designing the villa specifically in a Modern style - Crafting a layout that blends open plan living with separate rooms for privacy. This means ensuring there's a balance between communal areas and private spaces. - Incorporating key features such as a private garden or terrace, multiple balconies and rooftop access. These features are essential and should be integrated seamlessly into the design. Ideal candidates for this project should: - Have a strong portfolio of modern architectural designs - Possess experience in designing triplex villas and with a mix of open plan and separate rooms - Demonstrate creativity and innovation in the use of space - Be able to understand and incorporate essential features like p...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

I have a 120MB JSON file with nested objects, and I am in need of a skilled ...a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structure...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even if missing phot...

An Ecommerce Store requires a cartoo...poses ( VERY IMPORTANT !!!) - Standing - Sitting - Training with dumbells/ any sort of training Pose - Lying on on sided and saying hi - Motivated pose/ pose after an achievement - Any added poses are most welcome , along with the above poses. * Each panda pose should made in separate page with HD quality pixels. * STRICTLY NO PLAGARISM IS ALLOWED, WILL BE THOROUGHLY CHECKED. * No AI images allowed. How to send ? A PDF file can be sent. By combing all pages. Each panda pose should be in separate pages. SUPRISE ! If the Artwork is really amazing and is very satisfactory . An additional INR.500 will be Given to the Winner along with the Winning Prize. ALL THE VERY BEST ! SURPASS YOUR LIMITS ! FLOW LIKE A RIVER? ...

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm looking for a WooCommerce developer who can help me customize the checkout process of the plugin by duplicating the checkout fields based on the order quantity i.e. if order quantity selected for a product is two, then two separate details should be collected at checkout for that order e.t.c. The ideal candidate should have: - Strong experience with WooCommerce development - Proficiency in customizing checkout processes - Prior experience in integrating custom fields If you can help me achieve this, please reach out.

...primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and calculations in various countries. - UX/UI design skills are an added advantage to ensure the calculator is user-friendly. I&#...

((( We don't have much time, we only have one day now. and my budget is 25 LAST)))I won't respond to any bids unnecessarily. Second, you will only bid when you have applied my complete requirements to your localhost and have the project ready. Complete the work and then bid. Writing that I did i...1) At the end, for the finishing touches, any minor changes that are needed IN page , you will have to do them. 2) I need an identical product page with the same functionality and responsiveness as the website. Everything in my description is part of my job, and you will need to complete it. 3) an you complete the website for me, then at the end, give me the header file and the sections in separate files? After that, help me a bit to run it on my host. Once it runs, I will co...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree ...

...form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calcul...

...agencies to sign up for by showcasing its comprehensive toolset. Video Specifications: Length: Approx. 2 minutes Format: High-definition quality, suitable for both web & social media platforms and mobile viewing. Style: Modern, professional, with a direct focus on walkthroughs and screen captures of the platform in use. The color scheme for the video and logos will be attached as a separate document. Audio: Background music should be uplifting but not overpowering. Music should be royalty-free or licensed. Budget: To be negotiated based on freelancer’s rate and estimated hours. Additional Notes: Be prepared to make revisions based on feedback to ensure the video meets all specified requirements. A thumbnail image for the video....

...form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface

I'm in search of a talented individual who can create a series of GIPHY designs catering to two separate businesses. The ultimate goal is to offer a range of animated logos, product animations, and custom illustrations. Business one- body composition and metabolic testing business. showcase the brand and products etc Business 2- breathwork, mindset Key Points: - You'll be working on GIPHY designs for two distinct businesses - The designs should encompass a mix of animated logos, product animations, and custom illustrations - The animated logos should carry elements of modernity, playfulness, and professionalism Ideal Skills and Experience: - Proficiency in GIPHY design and animation - A strong portfolio showcasing a diverse range of design styles - An understandin...

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and cha...need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additiona...

I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessa...

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the differ...

...potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Too...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.