Excel vba import multiple file worksheetงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I'm in urgent need of a developer who can create a feature-rich video call app for iOS and Android with the following capabilities: - Group Video Calls: I want users to have the option to engage in video calls with multiple participants, similar to Zoom or Microsoft Teams. - Screen Sharing: I would like to provide the option for users to share their screens during video calls, a feature that's particularly useful for presentations and remote assistance. - Chat Functionality: A text chat feature will also be necessary for users to communicate in various ways. I'm looking to have this project completed ASAP. The ideal candidate for this project should have experience in developing multi-platform applications and be familiar with video call applications. Experience in ...
I need an expert Unity developer to build a single-player game that will be deployed across iOS, Android, and Web. Key Requirements: - Familiarity with multiple platforms' development and deployment requirements - Proven experience in creating engaging single-player games - Ability to design intuitive controls and user interfaces - Attention to detail and a high standard for quality assurance Ideal skills and experience: - Extensive Unity game development - Cross-platform development in iOS, Android, and Web - Single-player game design - UI/UX design skills - QA testing experience
I'm ...functionality. Key Responsibilities: - Implement PNR creation: This involves setting up a system that can generate Passenger Name Records upon booking - Integrate pricing and availability feature: The API should be able to provide real-time information on pricing and availability of flights - Develop multi-city search functionality: This feature should allow users to search and book flights involving multiple cities in a streamlined process. The current system is built in JavaScript and uses a Flight API. Skills required include solid experience with JavaScript, API integration and the ability to work on existing systems. It's crucial that the developer has previous experience in similar projects, ideally within the travel industry, and can provide a structured,...
...completing programming using languages and software products; designing and conducting tests. Research, Development, Team Development: Recommend system solutions by comparing advantages and disadvantages of custom development and purchase alternatives. Coordinate requirements, schedules, and activities, contribute to team meetings, and troubleshoot development and production problems across multiple environments and operating platforms. Provide support to colleagues and staff in the appropriate use of the solutions delivered. Conduct root cause analysis on customer issues and determine the best way to resolve them. Assess new architectures and technologies and determine which to implement to achieve the best business result. Support users by developing documentation and assis...
I am in need of a professional who can develop a comprehensive Visa Application System to support appointments and applications for different types of visas, mostly for employment purposes. Key Requirements: - The system must be able to process 2-5 different types of visa applications. - It should support multiple European languages. - The system should handle appointment scheduling for Visa Application Centers (VFS). Ideal Skills/Experience: - Proficiency in developing web-based systems, especially appointment and application systems. - Experience in multilingual system development, especially European languages. - Knowledge of the Visa Application process and system requirements is a plus.
Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...
...capital expenditures and financing activities. - Dynamic Model: - Create a dynamic model in Excel, ensuring that changes in assumptions automatically update all related financial statements. - Assumptions Tab: - Develop a separate tab to document key assumptions, ( also can use screenshots with source link) including revenue growth rates, cost inflation, capital expenditure plans etc. 3. DCF Analysis: - Free Cash Flow (FCF) Calculation: Calculate FCF - Discount Rate:Determine the Weighted Average Cost of Capital (WACC) using Marico’s cost of equity and debt. ( in separate tab) - Terminal Value:Estimate the terminal value using the perpetuity growth method or exit multiple - Present Value Calculation:Discount the projected FCFs and terminal ...
I did convert my existing old website (built 2004) to a responsive html5 website. As a first step I did convert the Homepage () and the into a responsive page without changing the design (look and feel). But the Homepage had only two (horizontal) Navigations. Other pages have an additional vertical navigation on the left side of the page - that needs to be integrated into the responsive navigation. Additional Notes: * Please don´t bid if you don´t have (and can show me) experience with this kind of work; I would like to see working examples beforeward; * To show that you've read and understand the project requirements, please include the phrase "hello pk" in your bid. Failure to include this will eliminate you from consideration. * Payment via escr...
...UI/UX best practices. o Ability to translate designs into functional WordPress themes. • WordPress Wizard: o Extensive experience with WordPress core functionalities, themes, and plugins. o Proficient in PHP, HTML, CSS, and JavaScript. o Experience with custom plugin development a plus. • Team Player: o Excellent communication and collaboration skills. o Ability to work independently and manage multiple projects. o A passion for learning and staying up-to-date with the latest WordPress trends. Bonus Points: • Experience with WooCommerce or other eCommerce plugins. • Familiarity with SEO best practices. • A portfolio showcasing your design and development skills. Ready to Join Our Team? We can't wait to hear from you! Please submit your resume and por...
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
Hi, We need a creative scriptwriter with a great sense of humor and knowledge of jokes and meme trends. I need many scripts related to the animal niche. I will ask for a 100 -150 word sample on the topic given by me. It's a long term task we need 8 scripts of 2000 words per week. We will hire multiple writers for this task. Have you had experience writing for a YouTube channel before? If so, we would love to see the links to your work. Additionally, please share some sample scripts that you have written. Payment will be via escrow. Interested candidate please bid. Regards, B
I'm in need of an expert software developer to create Trinamic motor control software. The software needs to be compatible with Trinamic motor control boards, specifically the TMCM-1260. The language required is Trinamic motor control command set. Key details include: - Op...set. Key details include: - Operating System compatibility: Windows, Linux, and MacOS. - Required Programming Language: Trinamic Motor Control Command Set. - Timeline: Expected completion of the project is ASAP. Ideal Candidate: Would have experience and skill in dealing with motor control boards, TMCM-1260 in particular, as well as the Trinamic command set. A comprehensive understanding of multiple operating systems will be beneficial too. Those who can work within a tight timeframe would be best suited...
...create a form and results page that is compatible with mobile, tablet, and desktop. The form will have less than 5 fields, but will require special features such as validation checks and file upload capabilities. Key Points: - Design a form with less than 5 fields - Ensure the design is responsive and compatible with mobile, tablet, and desktop platforms - Implement validation checks to ensure accurate data submission - Integrate a file upload capability for user convenience Ideal Skills: - Proficiency in UI/UX design - Experience in designing responsive web applications - Knowledge of form validation and file handling - Strong communication and problem-solving skills Please provide examples of previous projects you've worked on that demonstrate your ability...
Búsqueda/Recopilación de Datos: Búsqueda de Correos Electrónicos para Empresas Tecnológicas - Estoy buscando un freelancer que pueda ayudarme a recopilar direcciones de correo electrónico de una lista de empresas. - El propósito de este proyecto es recolectar datos para fines de investigación. - El freelancer ideal debería tener experiencia en recopilación de datos y ser competente a la hora de realizar investigaciones en línea. - El proyecto requiere recopilar un número sustancial de direcciones de correo electrónico de una muestra de aproximadamente 4800 empresas. - La atención al detalle y la precisión son cruciales en este proyecto para garantizar la validez de las direcciones de co...
I need a skilled PHP developer who can create a script that fetches information from a specific website when a user inputs a serial ID. Example serial : 2X0BHSB6AUXW5QAX (use this serial to tes...cn/en/logon where the info need to retrive from to scrape information from to site A. Sorry for the bad image, But it is an illustration. Budget is $50 USD for this. If you cant meet this budget, dont bid on this work. Key Requirements: - Develop a PHP script to scrape information from Website B when a user inputs a serial ID on website A. - Ensure the script is efficient and able to handle multiple requests without performance degradation. Ideal Skills and Experience: - Proficient in PHP and web scraping techniques. - Familiarity with handling user input and displaying output in a web ...
We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks
I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.
I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.
One of our main server has been infected with malware across multiple sites. We are seeking an expert to clean it.
...live support needed via teams. The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big pl...
I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...
I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will be highly beneficial.
...reliability, and a commitment to the environment It should be memorable, visually appealing, and easily recognizable The design should be versatile, and adaptable to various sizes and formats (e.g., print, digital) Additional Notes: The name "Collect Me" (إجمعني) was chosen to emphasize the company's innovative service, where bins communicate their fullness and request collection. Feel free to present multiple design concepts for consideration Prioritize originality and avoid clichés in the design Seek inspiration from successful environmental or waste management brands Deliverables: High-resolution files of the final logo design in various formats (e.g., PNG, JPEG, SVG) for both Arabic (إجمعني) and English (Collect Me) versions A style guide outlining the...
I am in need of a developer who can create a custom e-commerce website on WordPress, with various unique features. Key requirements: - The site should have custom product filters, enhancing user experience and making it e...integrated with advanced analytics tools. Furthermore, I'd like the payment gateways PayPal, Stripe, UPI, and credit card to be seamlessly integrated on this website. The ideal candidate should have: - Proficient experience in WordPress e-commerce development. - Experience in integrating membership subscriptions, custom product filters, and advanced analytics tools. - Strong knowledge of integrating multiple payment gateways including PayPal, Stripe, UPI, and credit cards. Please provide examples of your previous work and detail your experience with si...
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
I'm searching for a proficient freelancer who can assist me in adding multiple employees to my company's LinkedIn page. Key tasks: - Add multiple employees to my company's LinkedIn page in a professional, error-free manner. - Ensure accurate representation of each employee's profile on the company page. - Facilitate a seamless integration process without any glitches. Required Skills: - Proficient in LinkedIn Company Page Management. - Strong attention to detail and accuracy. - Familiarity with managing multiple employee profiles on LinkedIn. - Excellent communication skills. - Proven experience in similar tasks would be a huge plus. If you have the expertise and bandwidth to get this task done seamlessly, please reach out.
I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...
I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.
