Vba extracting data outlookcô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,

Một email mới từ KH gửi vào Email chung công ty, rồi căn cứ vào email KH gửi hoặc Tiêu đề email hoặc tệp bên trong email để phân loại - Lưu toàn bộ file vào Sharepoint - Lưu data email thành 1 sheet và cập nhật liên tục khi có email mới - Tạo folder tự động trên SharePoint theo quy tắc nhất định, hoặc folder được chỉ định

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 need assistance creating a specialized HTML email template that is compatible with Gmail, Outlook, and Yahoo Mail. We are transferring our daily e-newsletter mailouts from MailChimp to Simply Stakeholders, which is powered by the TinyMCE WYSIWYG editor. We have existing designs that we need converted into html coded templates that will be functional and editable on the front end, including being able to swap out images. The templates need to be responsive on mobile and desktop devices. The main purpose of the email will be sharing news of the day/week to our client base. We have an in-house designer who can serve as project liaison. Deadline to have the new templates operational is May 29. Access to the back-end of Simply Stakeholders can be provided for testing. Designed template...

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'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all schools on all pages

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 am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...

I'm seeking an expert in web scraping to specifically help extract data (price, stock availability, description, review content,..) from e-commerce platforms. Your specific task will entail: - Identifying and implementing the most efficient and effective way to scrape data. - extracting all data related to a product (picture, price, description, reviews, rating,...). Your method should maintain adherence to all legal and ethical guidelines - I'll need details on this as your bid. This project will require: - Proficiency in web scraping tools and techniques. - Sound knowledge of data extraction and storing processes. - Ability to work with undisclosed e-commerce platforms. - Familiarity with review structures on e-commerce sites.

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

I am looking for an expert in web scraping who can efficiently extract business leads. While the primary purpose of the project was not specified, it is undeniable that these leads will play a pivotal role in marketing efforts, like sales lead generation, market research,...be welcomed. Lastly, the exact number of leads that I need hasn't been defined, so I am open to both small and large-scale operations. Ultimately, their quality is of more importance than mere numerical quantity. Ideal Candidate: -Proficiency in web scraping -Experience extracting from business directory or professional networking sites -Excellent attention to detail -Able to identify and collect specific lead information. -Demonstrated understanding of confidentiality requirement in dealing with professio...

...Tools for monitoring and moderating user activity, including content moderation and user support. 4. Non-Functional Requirements: 4.1 Performance: • The website should load quickly and efficiently, even during peak traffic periods. • Response times for user interactions should be minimal. 4.2 Security: • Implementation of robust security measures to protect user data and prevent unauthorised access. • Compliance with relevant data protection regulations such as GDPR. 4.3 Scalability: • The architecture should be designed to accommodate future growth and scalability requirements. • Provision for quickly adding new features and functionalities as needed. 4.4 Usability: • Intuitive user interface design to ensure ease of navigation and usab...

I'm seeking a talented researcher to conduct a comprehensive literature r...least 15 up-to-date and relevant references indexed on Google Scholar. Key Requirements: - The literature review should be a minimum of 600 words. - Each reference must be meticulously evaluated to provide a detailed critique. Ideal Skills & Qualifications: - Proven experience in academic writing, particularly in the field of additive manufacturing. - Proficient in using Google Scholar and extracting relevant information. - Strong analytical skills to critically evaluate and summarize academic texts. - Understanding of materials used in additive manufacturing, applications, and the advantages associated with the technology would be a plus. Please note that the references must be up-to-date and f...

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

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'm looking for a freelancer who can extract all the information and workouts from the Summers Method workout app. Key Responsibilities: - Extract all workout videos - Compile exercise descriptions - Collect training schedules - Provide me with all data from the application I will provide you with login credentials to access the application and you will need to deliver everything in a PDF document/ along with videos in MP4 format. Ideally, the freelancer should have experience in data extraction, be thorough and detail-oriented. They should also have a basic understanding of workout routines and fitness. Please note that I need all the information from this app, no exceptions.

I'm seeking a skilled animator to craft a fun, vibrant 2D animation for marketing and promotional purposes. The animation should engross the audience while effectively communicating our brand message. Crucial Skills and Ex...Demonstrated ability to create bright, engaging animations - Experience in creating animations for marketing and promotional campaigns Project Features: - Use a colour scheme that embodies a fun, vibrant atmosphere - Style should be corporate, yet not too formal and should be engaging to our target audience - While incorporating the vibrant colour scheme, the animation must still maintain a professional outlook suitable for a marketing tool. Ideal animator should be capable of creating dynamic, engaging 2D animations that align seamlessly with our vibra...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

I need a skilled WordPress developer to list custom posts by closest distance to the current users address, which has been added via an ACF Google Map in the user profile. The list of posts will appear on the users profile page which is set up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent project so I would

I need a hand in mastering the use of MS Outlook. Specific tasks I require assistance with include: - Managing and organizing my contacts - Sorting and structuring my emails - Creating folders for better email management - Effective calendar management via Nextech EMR Moreover, I am unsure if linking Outlook to Teams or iCloud might boost my productivity. Hence, I need advice on possible integrations and synchronization with other platforms. The ideal bidder is proficient in MS Outlook, with experience in Teams or iCloud, and EMR systems, especially Nextech. Your ability to provide practical, simple solutions is highly valued. ( I WOULD NOT EXPECT MY TUTOR/ASSISTANT TO KNOW NEXTECH :) ) Completion of the project should ideally be within a month.

...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...

queremos una serie de cursos, para mejorar el uso de las herramientas 365 en la empresa. algo de 1 hora, cada semana aprox. basicamente outlook, excel y teams. uso basico, y algunas series de tips y/o mejores practicas.

Require a skilled professional in computer vision. I have public video...gaze analysis, body movement analysis, speech and language processing, social interaction metrics, activity recognition, contextual information integration, and temporal dynamics analysis, all aimed at extracting comprehensive features from human video data to identify autism spectrum disorder. If you have work experience in computer vision, machine, and deep learning, specifically on video datasets, please let me know with a few of your sample works. We can discuss the task details, time, and budget in a virtual meeting. Ideal Skills: - Proficiency in computer vision, particularly in extracting features from videos - Experience with facial recognition systems - Experience with action recogni...

I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants, prices, ean/gtin, description, collections,... - Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products you need to c...

I'm in need of a capable individual to translate the core concepts of my trading book into a dynamic, interactive webinar presentation. The book is concise, under 100 pages, so the content extraction process should be relatively straightforward. The key focus here is translating textual content into engaging visual and interactive elements for the digital audience. Key Responsibilities: - Extracting and translating key concepts from a trading book into webinar content - Creating an engaging, interactive webinar presentation that resonates with the book's core messages - Ensuring the presentation is suited for digital delivery Ideal Skills: - Experience in translating textual content into engaging visuals - Proficiency in creating dynamic and interactive presentations - F...

I'm looking for a skilled designer who can create a custom email template for Outlook, aligning with our existing branding. Key Requirements: - Develop a professional, easy-to-use email template that reflects our brand identity. - Ensure the template is compatible with Outlook and maintains consistency across various devices. Ideal candidates should have: - Proven experience in designing functional and visually appealing email templates for Outlook. - Strong understanding of branding and the ability to seamlessly incorporate it into the design. If you have a creative eye and a good grasp of email template design, I'd like to hear from you.

Preciso de um profissional que saiba desenvolver processos automação RPA, que integra site e arquivos excel em processos rotineiros.

I need an expert in Python web scraping to help me extract specific data from a website. - The website I need data from will be disclosed once the project is awarded. - I have a specific list of data points I need extracted. - The frequency of updates for this data is not set yet. Ideal skills: - Proficiency in web scraping with Python - Experience in extracting data from dynamic websites - Ability to follow instructions and deliver precise data outputs - Good communication skills for potential project extensions and updates

I need an expert in Python web scraping to help me extract specific data from a website. - The website I need data from will be disclosed once the project is awarded. - I have a specific list of data points I need extracted. - The frequency of updates for this data is not set yet. Ideal skills: - Proficiency in web scraping with Python - Experience in extracting data from dynamic websites - Ability to follow instructions and deliver precise data outputs - Good communication skills for potential project extensions and updates

I'm in immediate need of a Python expert to help me scrape data from website. This is a time-sensitive project, so I'm looking for someone who can start on it right away and deliver quick results. Key Requirements: - Proficient in Python programming - Experienced in web scraping, particularly extracting text content - Able to work quickly and efficiently without compromising data accuracy - Good communication skills to keep me updated on progress - Capable of starting immediately Please share your relevant experience and how you plan to approach this task. The sooner you can deliver, the better.

I'm looking for a skilled email marketing expert to create a Vipre Email security campaign aimed at small business owners. Key Requirements: - Utilize Outlook: You should have experience working with Outlook as the platform for your email campaigns. - Awareness Goal: The primary aim of this campaign is to heighten awareness of email security among small business owners. Ideal Skills: - Proficiency in email marketing, particularly using Outlook - Understanding of security best practices - Ability to tailor messaging for a business audience - Experience in creating effective awareness campaigns Please provide examples of previous campaigns you have worked on, particularly those aimed at increasing awareness and targeting small businesses.

I'm looking for someone proficient in Python to convert a PDF file into a JSON format. 4 PDF and 2 excel. Ideal skills and expertise to complete this project include: - Proficiency in Python programming - Experience with PDF parsing - Knowledge of JSON formatting and structuring The project involves extracting and transforming data from a PDF file into a structured JSON format. If you're confident in your Python abilities and have experience working with PDFs and JSON, I'd love to hear from you.

We are seeking a skilled developer to create an automated process for extracting data from PDF files and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column