Compare data sets vbacô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

vmix (video production) expert needed for a couple of online consultations in videocall. topics: titles, vmix virtual sets, audio inputs. thank you.

...dashboard will display custom data. - The dashboard should have data filters that allow users to interact with the data, specifically in the form of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user will interact with the dashboard is key. The freelancer should be able to design a user-friend...

...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 file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.

I'm seeking a skilled professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly desirable. There...

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

I have 33x sets of product data in a spreadsheet. I need each product's specifications to be created in a standardized PDF format. The level of detail should include everything detailed on the spreadsheet. The data on the spreadsheet is broken down into the following sections, which must be reflected on the product specifications. - Production Information - Packaging - Pallet Configuration - Physical Data - Chemical & Microbiological Tolerances - Storage - Labeling You will be responsible for: - Creating individual product specifications from provided data. - Ensuring all specifications are formatted consistently in PDF format and include our company logo provided. - Include all the information provided in each product specification. Ideal ski...

...-Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity of curricula offered (In UAE we have UK, US, IB, Australian, Indian, Chinese, French, Ministry of Education, German, Indian, Pakistani, Russian and Filipino). -Acquire data on the cultural and national diversity of student bodies across schools to ensure our directory caters comprehensively to all segments of society. -Collect annual marketing expenditure data from all schools in the UAE to analyze trends in marketing spends for enrollments. -Gather information on average marketing spend per school to understand budget allocations and marketing strategies in the education sector. (Examples for Outstanding, Very Good, Good, Acceptable, a...

...Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity of curricula offered (In UAE we have UK, US, IB, Australian, Indian, Chinese, French, Ministry of Education, German, Indian, Pakistani, Russian and Filipino). Acquire data on the cultural and national diversity of student bodies across schools to ensure our directory caters comprehensively to all segments of society. Collect annual marketing expenditure data from all schools in the UAE to analyze trends in marketing spends for enrollments. Gather information on average marketing spend per school to understand budget allocations and marketing strategies in the education sector. (Examples for Outstanding, Very Good, Good, Acceptable, and W...

...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 integration &...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized ...

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).

...detailed analysis of several 3D planner software platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling pro...

I'm a digital affiliate marketer who needs a comprehensive product cross-referencing and price comparison tool developed for my e-commerce website. The tool should be capable of processing data from around 30,000 products across 5-10 different stores. Key Requirements: - Cross-reference 30,000 products from 5-10 stores: The tool should be able to analyze and compare prices for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The comparison results shoul...

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(&quo...

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your b...

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.

I'm in need of a professional logo designer who can create a logo that not only reflects my brand but also sets it apart in terms of recognition. Key Requirements: - The logo should primarily focus on brand recognition and creating a unique identity. - A minimalist approach is preferred, but I'm open to other creative styles as well. Ideal Freelancer: - A seasoned logo designer with a strong portfolio of past work that demonstrates a deep understanding of brand recognition. - Experience in crafting logos that are both minimalist and distinctive. - Strong communication skills to understand and translate the brand values into a visual identity. The name of the real estate group is House Trained Realty Group We have a strong passion with helping animals (primarily dogs ...

...visualizations based on three years worth of data. The focus of this analysis will be to compare regional data against a national average. Key Responsibilities: - Conduct a descriptive data analysis on the provided datasets - Generate Excel charts and graphs that visually represent the insights from the analysis - Highlight significant differences and similarities between regional and national data The ideal candidate for this job should possess: - Strong proficiency in data analysis, particularly descriptive analysis - Proven experience with using Excel for data visualization - A keen eye for detail and accuracy in data interpretation - Ability to clearly present complex data findings in an easy-to-understand manner - Pr...

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from the data presented

...quality appointments. --- We are looking for a long-term partnership. We have demand for multiple locations in the US, Canada, and Australia. --- You need to have your own dialer and leads (We have ppl working with us using Google Maps and --- Qualification criteria --- A business with the REAL possibility of becoming our client: NOT pushing appointments, NOT people just looking to compare prices, NOT people happy with their current services. They need to provide a reason on the call why they want the appointment, for example: "I'm not satisfied with my current company." "I'm doing the cleaning in-house, but I would like to outsource." "We are moving offices or returning from home office to the office." Confirm in the call: If the per...

in need of a skilled photoshop designer who can create Facebook and Google ad sets for my med spa. The main goal of these campaigns is to generate leads. Please upload as samples for each treatment below and making sure all ads would be compliant to Facebook and google guidelines I will need 1 ad per treatment for our med spa for the following services. Once hired we will need 5 color variations for each ad. Key Treatments: - The ad sets will focus on a range of treatments, including Morpheus8, tri-Lift, Vampire Facials, and PRF Microneedling. - The ads should highlight the benefits of these treatments and why they are the perfect solution for anti-aging. Target Audience: - The target audience for these ads are individuals looking for anti-aging solutions. - They ar...

...company's profit and loss by incorporating all projects and back-office expenses. Features: • Consolidated P/L Dashboard: Aggregates data from all projects and expenses to display a real-time profit and loss statement. • Expense Tracking: Management of back-office expenses including rent, insurance, advertising, and labor costs. • Financial Reports: Generation of detailed reports like balance sheets, income statements, and cash flow statements. • Budget Management: Tools to set budgets, compare actual spending, and forecast future expenses. 3. Employee/Subcontractor Tracker Manages details and costs associated with employees and subcontractors, integrating expense data back into project costs. Features: • W2/1099 Management: Streamlin...

I'm on the lookout for experienced professionals to build a comprehensive ecommerce platform for my services. We'll have to move quickly, as I need this project completed as soon as possible. Here are some specifics: - The platform will be primarily used for selling services. - Since I opted to skip the question about service categories, I am open to any skill sets you might bring to the table with regards to diverse service offerings. - Rapid response and fast development timelines are crucial for this project. Ideal candidates for this job should have: - A strong background in ecommerce development, specifically focused on service platforms. - Proven track record of delivering projects within tight timelines. - Flexible problem-solving skills and adaptability to mee...

Hi! I am in need of a skilled Data Analyst who can transform some critical district nutrition data into easily understandable infographics and pie charts. The mission is as follows: - Perform statistical analysis on yearly district nutrition data - Generate engaging infographics and pie charts to visualize and interpret the data accurately - Provide detailed descriptive statistics Potential applicants should have a strong understanding of data preprocessing, data visualization, and statistical analysis. Experience in designing infographics and interpreting complex data sets is a must. Prior experience with nutrition or health data is strongly valued. Let's make this data speak!

...a project. Project Cost Estimation Methods Training Materials Preliminary and Detailed Estimate Accuracy of Cost Estimates bill of Quantity Description of work, quantity (volume)+units and unit price of work Productivity Estimating Estimating Productivity Resource Scheduling Work Breakdown Structure (WBS) A method of organizing a project Create Project Cash Flow Creating Project Cash Flow compare the Actual Cost and Budget Plan Bid Evaluation Bid Evaluation Computer Program Applications Related Project case studies Project Cost Estimation Methods Training Participants practitioners, planners, implementers, supervisors and maintainers as well as those involved or interested in exploring project cost estimates Project Cost Estimation Methods Training Method...

...a project. Project Cost Estimation Methods Training Materials Preliminary and Detailed Estimate Accuracy of Cost Estimates bill of Quantity Description of work, quantity (volume)+units and unit price of work Productivity Estimating Estimating Productivity Resource Scheduling Work Breakdown Structure (WBS) A method of organizing a project Create Project Cash Flow Creating Project Cash Flow compare the Actual Cost and Budget Plan Bid Evaluation Bid Evaluation Computer Program Applications Related Project case studies Project Cost Estimation Methods Training Participants practitioners, planners, implementers, supervisors and maintainers as well as those involved or interested in exploring project cost estimates Project Cost Estimation Methods Training Method...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities fo...in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large ...

I'm looking for an experienced designer to create engaging and visually appealing banners and ad sets for my Web3 project. The main aim of this project is to drive traffic to my website. Key Requirements: - The banners and ads will be used across various platforms, including social media, search engines, and partner websites. Hence, they should be tailored to suit these different platforms. - The target audience for this project is primarily between the ages of 18-44, so the designs should be attractive and relevant to this demographic. Ideal Skills and Experience: - Previous experience in creating web banners and ads, particularly for diverse platforms and audiences. - A good understanding of Web3 projects and the ability to design with the aim of driving website traffic. - ...

I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the 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 opportun...

I am in need of a creative and attractive logo for my technology-based website. I am looking for a designer who can bring my brand to life through a logo that is both meaningful and visually striking. Key Requirements: - A logo that embodies the essence of a technology focused business - A design that is unique and sets my brand apart - The logo should be visually appealing and memorable Ideal skills and experience for the job: - Proven track record in creating logos for technology companies - Experience in brand building through design - Strong portfolio of creative and meaningful logo designs - Proficient in various design software for logo creation.