Vba sort column ascendingcô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
...Freelancer có kinh nghiệm thiết kế google sheet ứng dụng trong quản lý đơn hàng công ty với nội dung yêu cầu: 1/ Tạo excel trên google sheet có thể phân tầng quyền truy cập cho các cấp bậc nhân viên khác nhau trên mẫu excel google sheet có sẵn. ( quyền xem, chỉnh sửa , sort các cột/ dòng cụ thể) 2/ Thiết lập một hệ thống trên google sheet có sẵn với yêu cầu nhiều người có thể cùng truy cập sửa đổi , update excel tùy quyền hạn đã được phân ở mục 1. ( Vì với google sheet cơ bản thì nếu một người thực hiện theo tác- chẳng hạn như sort trên sheet thì tất cả mọi người khác đều c&...
I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skills in data output formatting...
I'm looking for a talented logo designer to help me rebrand my existing logo. I have an exisiting EyeVantage Logo. Need one for MedVantage. Prefer to have some pills on the end. Would like to see what sort of concept people can come up with. Please follow the same concept as the EyeVantage logo. Key Points: - Logo Revamp: The main reason for this redesign is rebranding, I need the logo to reflect my new brand identity and messaging. - Modern & Minimalist Style: The new logo should be "Modern & Minimalist", so I'm keen on a design that is sleek, clean and contemporary. - Specific Colors: I do have specific colors in mind for my new logo, which I will provide during our discussions. Ideal Experience: - Proven experience in logo design, with a strong por...
I am searching for an experienced copyeditor to refine a Science Fiction/Fantasy novel of mine. The manuscript is of moderate length, ranging between 50,000 and 100,000 words. Task Details: - Proofread and correct all grammatical, spelling, and punctuation errors. Ideal Candidate: - Must be proficient in English language and grammar. - Has deep knowledge and interest in ...grammar. - Has deep knowledge and interest in the Science Fiction/Fantasy genre, thereby understanding its tropes and norms. - Preferable experience in copyediting novels, especially within the aforementioned genre. - Work must be done by a human Please note, this project primarily focuses on fixing errors in language mechanics and does not require extensive alterations in sentence structure or any sort of ...
I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainabilit...and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment call as to whether a given text is about it. Use your best judgment. -If you are very unsure about whether the tweet is about sustainability, or if the tweet it not in English, enter your be...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating 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, nor... 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 Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...
I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web applications
Project is basically about reading data from file and then using algorithms and data structures sort those data as its needed and then write short documentation...I will also need you to explain me everything you made, how it works etc...Project consists of 4 chapters...1 chapter will be pinned
...data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there are lines that are not present or do not have a value, you must report them in the VAT control output file report (attached). 4- Sta...
I need a tool that extracts specific content (text and images) from PDF files and adds this data into a CSV file under designated headers. Key Requirements: - The tool should be designed specifically for Windows OS. PDF Data Extraction: - Need the tool to extract both text and images from the PDFs. CSV Insertion: - The extracted data should be sorted correctly under their respective column headers in a CSV file. Consistent PDF Structure: - It is important that the tool can handle data extraction from PDFs with a consistent structure. Ideal Skills and Experience: - Proficiency in developing Windows-based tools. - Experience with PDF data extraction. - Familiarity with CSV file manipulation in Python or related languages.
...it should be moving. I have made a rough logo, please refer Attachment with this project, that's important INSTRUCTIONS-: I want this logo to be in Bluish and Orange colour theme Colour of "Resume" icon should remain the same. Icon should animate. Name should wave left to right ...or any other special effects also will do. Tagline to remain still Entire complete logo should appear in some sort of 3D block Background of 3D block of ur choice, as of now its dark grey There should be a small blue colour variation between word Galaxy and word "Resume" mentioned in ICON (above head). The second word "Resumes" (near Galaxy) should be of orangish colour Tagline can be of white or grey colour in italics You can download the icon from this link wh...
...Description: I need a web application developed to manage and organize short audio recordings. Users should be able to upload audio files (3 seconds max) and categorize them with basic labels. Key Features: User accounts and login system Ability to upload audio files (3 seconds max) - MP3 format preferred Option to add simple labels (e.g., "Meeting Notes," "Quote") to each audio file Ability to sort and filter audio files by upload date or label Basic interface for browsing and listening to uploaded audio files Secure storage of user data (audio files and labels) Target Audience: This app caters to users who want a simple way to organize and access short audio snippets for personal use. Think of it as a basic audio version of a text-based note-taking app. ...
More details: Is this project for business or personal use? For starting a new small business Which industry does your new enterprise fall into? Events / Wedding Florist What is the desired style for your business logo/branding? Elegant and classy but bright and whimsical at the same time? (Think Bridgerton and romantic English country...time? (Think Bridgerton and romantic English countryside) needs to have an impact though! Have attached a picture of my favourite dress and I love the colours! Do not have a colour scheme in mind but I have a love for English cottage gardens so something maybe along those lines. Would like a few to choose from! Have attached ideas for the logo (I’m definetly in my Bridgerton era) so maybe a sort of head silhouette somehow incorporating f...
More details: Is this project for business or personal use? For starting a new small business Which industry does your new enterprise fall into? Events / Wedding Florist What is the desired style for your business logo/branding? Elegant and classy but bright and whimsical at the same time? (Think Bridgerton and romantic English country...time? (Think Bridgerton and romantic English countryside) needs to have an impact though! Have attached a picture of my favourite dress and I love the colours! Do not have a colour scheme in mind but I have a love for English cottage gardens so something maybe along those lines. Would like a few to choose from! Have attached ideas for the logo (I’m definetly in my Bridgerton era) so maybe a sort of head silhouette somehow incorporating f...
...mechanism. - **Performance**: Develop a script that prioritizes speed and responsiveness. This includes a Fast Loading Service, Improved Caching System and a theme page builder. The theme page builder will be particularly important to allow me to customize the design according to my needs. - **Admin Capabilities**: Implement features that may help improve security or admin and improve user list sort. Ideal Skills and Experience: - Proficiency in scripting languages such as PHP, HTML and CSS. - Experience with SMM panel development. - Proven track record in integrating payment gateways and APIs. - Strong background in cybersecurity and implementing security features. - Prior experience in developing User Management Systems. - Experience in developing fast-loading services and the...
...Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row blank. have to b...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. - **Adva...
...both sentiment analysis and classification tasks. Key Tasks: - Sentiment Analysis: I want to understand the overall sentiment of the email data. You will be required to identify and extract the prevailing sentiment from the emails. - Email Classification: The project includes categorizing the emails into predefined categories. This will involve analyzing the content and context of the emails to sort them into different classes. Requirements: - Proficient in Python: As Python is my preferred language for this, you should have a strong grasp of Python and its libraries for carrying out sentiment analysis and text classification. - Email Analysis Experience: Experience in analyzing text data from email sources is highly desirable. - Understanding of Sentiment Analysis & Emai...
I need a fu...the ability to block users from specific regions. - **Captcha:** Incorporating a reliable Captcha system to prevent spam and bots. - **Disclaimer Agreement:** Implementing a mechanism where users have to agree to certain terms before accessing the site. - **linkage to twitter & telegram. While there will not be a contract address in two of the boxes, we would like there to be a "test" of some sort to copy the info. I currently have a figma design made. We are currently working out kinks for future projects and this is a test for future work. I'm open to discussing design elements. Your expertise in these areas will be highly appreciated.
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 – 300 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 knowled...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
I require an advanced database to streamline church operations. It must include: - Member management: This involves recording personal details of each member, tracking attendance, and allocating to the right departments. Each member's record should also include household and family details, with specific fields for spouse and children. - Functionalities: Capacity to sort data based on each individual (organize by member). It should also capture other input fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database systems, with a keen understanding of how ...
I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...
I'm currently in need of a skilled engineer with experience in structural analysis, particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actionable design suggestions based on analysis - Strong anal...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designing and impleme...
...**Duration**: The intro and outro should be between 5-10 seconds long. **Ideal candidates** will have: - Proven experience in creating engaging YouTube intros and outros. - Strong video editing and animation skills. - Ability to craft custom music or sound effects. - A good eye for design and composition. - Excellent communication skills to understand and implement my vision. **Intro Concepts**: 1. **Ascending Steps (Preferred)**: Show a silhouette climbing a staircase or my logo walking and animated in a creative way, with each step representing aspects of spiritual growth so the words would need to be placed per step like (salvation, faith, awakening, power of the Holy Spirit, eternal life). At the top, the silhouette reaches a radiant light or my logo/name. 2. **Silhouette A...
...Oversold: Identify stocks with RSI readings below a certain threshold (e.g., 30), indicating potential oversold conditions. Volume Spikes: Identify significant increases in trading volume coupled with price increases. Breakouts: Detect when a stock breaks out above a prior resistance level or consolidation range. Bullish Chart Patterns: Recognize classic bullish chart patterns (e.g., cup-and-handle, ascending triangle, inverse head-and-shoulders) using pattern recognition algorithms. Fundamental Analysis (optional): Integrate additional data sources to consider fundamental factors, such as earnings surprises, new product launches, or acquisitions. Implement sentiment analysis on news articles or social media data related to the stocks. Scoring and Ranking: Assign scores o...
I'm looking for a talented artist to create a minimalistic cartoon character based on a paperclip with arms, eyes and legs for my project. The character will convey a focused emotion and will be illustrated in two different scenarios. There will be more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up litter. The character should e...suitable. - Climbing out of a cardboard box. - Picking up litter. The character should exhibit a unique blend of simplicity. This project is perfect for freelancers with experience in character design and a knack for minimalism. Particle knowledge of conveying emotions through characters would be desirable but not mandatory. Feel free to reach out if you have any queries. See the picture for the sort of thing I...
I'm seeking an experienced developer to create an Android app for my e-commerce business. The app should possess a minimalist design, aiming for simplicity yet effectiveness in terms of user experience. Key Features: - Product Search and Filtering: To help users find and sort products with ease. Ideal Skills: - Expertise in Android App Development, specifically in building e-commerce applications. - Strong understanding and experience in creating minimalist designed apps. - Skills in implementing useful product search and filtering features. The end product should deliver an easy-to-use platform for shoppers with a clean and minimalistic aesthetic. Experience in e-commerce app development with a focus on product search and filtering will be highly appreciated.
