Program extract data excel fileงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
ทำเวบขายของ มีระบบ affiliate กับ ตัวแทนจำหน่าย เขียนโดยใช้ JOOMLA อยากได้ระบบแบบ ขอให้มานำเสนองานที่บริษัทครับ แบบหน้าบ้านหลังบ้าน เรื่องงบเดี๋ยวคุยกันอีกทีครับ
...for a freelancer who can assist in gathering the details of company directors from a list of data centres. The project involves finding information for 100 plus data centres. Key Requirements: - Full Name, Title, Email Address, and Phone Number of the directors are required. - Experience with data gathering and research is crucial. - Prior experience in sourcing business contacts is a plus. - Directors' LinkedIn Profiles are required for validation. - Please include the directors’ specific company roles in your search. Your bid should reflect your ability to provide this information accurately and efficiently. Looking forward to your proposals. The gathered information should be organized in an Excel spreadsheet format. Please include the direct...
...the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for ...
I'm in need of an Excel worksheet It is already in a wook book split into 3 parts with a total of 32 questions. The questions are designed for a beginner level course, so they're not overly complex. Key Requirements: you are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. Your goal is to set up a dashboard to display the needed information. Ideal Skills: - Proficiency in Excel - Experience in creating educational materials - Competence in trend analysis - Ability to work with financial data Heres the Project: You are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data...
...a proficient Excel developer to create an interactive dashboard that will help visualize work accomplished from different Excel sheets. Each sheet has slightly different data points but shares common elements like quantities completed on specific days and the number of additions per day. The dashboard should also incorporate some aging aspects of the efforts on each sheet. Key Requirements: - Proficient in Excel with experience creating dashboards - Skills in data visualization using line charts, bar charts, and pie charts - Ability to perform and display calculations including sum of quantities, count of entries, and difference between start and end values The dashboard must include: - Data visualization through number fields (count, sum, dif...
Looking to create the views in mariadb required for a calculation system to process sales data and automatically determines commissions based on various metrics. Category-based calculations Flexible rule implementation Experience with Excel/MariaDB Strong analytical skills Experience with business calculation systems Ability to implement complex business logic Looking for clean, maintainable code with proper documentation.
I need a professional who will help me automate the inputting of Purchase Orders (POs) into SAP. We handle approximately 100 POs daily, and these come in va...inputting of Purchase Orders (POs) into SAP. We handle approximately 100 POs daily, and these come in various formats, primarily as PDFs. Key Project Requirements: - Process around 100 Purchase Orders daily - Input data from mixed consistency PDF formats into SAP - Extract and input various details including: - Supplier details - Item details - Total amount - Special instructions - Delivery address - Unit Cost Ideal Skills: - Proficiency in SAP and MS 365 automation tools - Experience in processing various document formats - Strong attention to detail for data extraction - Ability to handle mixed...
I need someone to transfer data from an Excel spreadsheet to a Word file, following a provided template, and then save it as a PDF. Ideal Skills and Experience: - Proficiency in Microsoft Excel and Word - Attention to detail (this is a must) - Ability to follow instructions accurately - Experience with data entry and document formatting Data Types: - The data consists of a mix of both text and numbers. Task Specifics: - A template will be provided for the Word file, which will require simple formatting (e.g., bold, italics, headings). - Instructions will be provided on how to organize the data in the Word file.
I'm seeking a freelancer who can create a cartoonish, bright and vibrant caricature logo for our "lifetime warranty program." The goal is to visually represent our target of achieving 3000 registrations by 2030 without using any text. The logo should be designed in a way that, at a glance, visitors can understand our ambitious goal. Ideal skills and experience for the job include: - Proficiency in graphic design and logo creation - Experience with creating cartoonish and vibrant designs - Ability to convey complex ideas visually, without the use of text - Strong understanding of caricature style - Creativity and innovative thinking in design Please review the original logo file here of our Lifetime Warranty: The
I am looking for a professional developer to create an e...Pending, Delivered, Rejected, In Warehouse ✅ Smart Scanning: Drivers can scan packages using a camera or scanner ✅ Warehouse Management: Accept and process incoming shipments ✅ API Integration: Connect with other courier companies in Albania and North Macedonia ✅ Reports & Analytics: Generate reports for orders, drivers, and sellers ✅ Order Printing: Print orders in A4 format and label prints ✅ Excel Import: Bulk order registration for higher efficiency Preferred Technologies: ✅ Laravel / Node.js for Backend ✅ React / Vue.js for Frontend ✅ MySQL / PostgreSQL for Database ✅ Mobile App (Optional) ? If you have experience in logistics platform development and can build a stable, fully functional system, contact me!
...around 50 real Followers. For 50$ it seems reasonable. If more followers would come in the first days I can increase the price (or paid separately some freelancer) depend what you ask in the chat. The project description and links are in the PDF. You can rewrite it (We don't see everything in the video). If you convince me, I might open a 50$ contest after this one where you could show me an Extract (5 second not more) of what a "Cinematic" Trailer (so with your own asset), matching this great project, should look like. And a sample of a kickstarter presentation (Currently it's raw). Obviously for both contest there might be a way better offer after. But not before I'm sure you know what you are doing. At this stage it's no the problem of what...
...Medical Inventory Mapping to EMDN & UNSPSC Codes ? Project Overview We are looking for a data analyst with expertise in medical device classification to help map our hospital’s inventory of disposable medical supplies and device parts to two global classification systems: 1. EMDN (European Medical Device Nomenclature) – Required for EU MDR/IVDR compliance. 2. UNSPSC (United Nations Standard Products and Services Code) – Used for procurement and supply chain management. This task requires accuracy, attention to detail, and experience with medical product categorization. ? Project Scope & Deliverables You will be working with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical...
...Medical Inventory Mapping to EMDN & UNSPSC Codes ? Project Overview We are looking for a data analyst with expertise in medical device classification to help map our hospital’s inventory of disposable medical supplies and device parts to two global classification systems: 1. EMDN (European Medical Device Nomenclature) – Required for EU MDR/IVDR compliance. 2. UNSPSC (United Nations Standard Products and Services Code) – Used for procurement and supply chain management. This task requires accuracy, attention to detail, and experience with medical product categorization. ? Project Scope & Deliverables You will be working with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical...
I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.
I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.
Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...
...connections. Target Audience: Businesses in Mississauga and the GTA, including but not limited to: ✅ Plumbing companies ✅ Electrical contractors ✅ HVAC companies ✅ Landscaping services ✅ Roofing companies ✅ Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & a...
...gestionar invitados. Permitir que los invitados confirmen su asistencia en línea. Funcionalidades adicionales: Envío automático de correos electrónicos con las invitaciones y confirmaciones. Posibilidad de agregar comentarios o notas adicionales al confirmar asistencia. Diseño visual y funcional atractivo y amigable para los usuarios. Posibilidad de exportar las listas de invitados a formatos como Excel o PDF. Referencias: Nos gustaría implementar algo similar a los sistemas que se encuentran en: Bliss & Bone The Knot
I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.
I need a web scraping tool that can extract contact details such as first name, last name, phone number, and email from websites of service-based businesses like plumbers and electricians. Key Requirements: User-Friendly – I have zero experience with coding or similar tools, so the tool must be easy to use. Fully Independent – The tool must not require ongoing support or maintenance after delivery. I must be able to run it myself without additional assistance. Data Export – The extracted data must be automatically saved and exported directly into an Excel spreadsheet. Target Directories – The tool must be able to scrape from the following online directories:
I'm in need of a data entry professional with a background in public services. This project involves entering data on newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newc...
I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.
El objetivo es crear un *dashboard automático en Excel* para el gimnasio, que permita consolidar los datos diarios de nuevos afiliados, renovaciones, ventas de cafetería y suplementos, y el cuadre de caja. El dashboard debe ser fácil de usar para las recepcionistas, con gráficos dinámicos y filtros para ver información por día, semana o mes. Además, debe actualizarse automáticamente cada vez que se ingresen nuevos datos sin dañar el archivo y debe ser claro y sencillo para evitar errores en su uso.
I'm seeking an experienced software developer to create a Windows compatible program for me. This program should allow full customization of the caller ID number displayed during telemarketing calls, with absolutely no restrictions. Key Requirements: - Development of a full GUI: The software should be user-friendly with a complete graphical user interface. - Customization: The key feature of the program is the ability to manually input any desired caller ID number, without limitations. Ideal Skills: - Proficiency in Windows software development - Extensive experience with creating full GUIs - Previous work in telemarketing software development is a plus Do not include any additional security or verification features. The software should be designed for a sing...
I have an AI file for a poster that is partially created. The content (pictures and text) are in it, but I need help making it aesthetically pleasing. I am open to creativity in terms of style, so designers with a unique perspective are encouraged to apply. - It needs to be designed in a way that it captures attention and effectively communicates the intended messages. Ideal Skills: - Proficiency in Adobe Illustrator and other graphic design software. - Strong understanding of typography and layout. - Ability to create visually appealing designs and blend multiple components together. - Experience in designing posters or similar materials.
I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.
I'm seeking a native professional translator to translate an English text into Arabic (KSA). The text contains a list of 870 words linked to DIY tools, with a 27 % repetition rate. The lists are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools...
I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy
