Excel vba check add installงาน
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 ที่กำหนดให้
ฉันมีข้อมูลของรถตำรวจตรวจสอบในบางเมืองของประเทศไทย ฉันต้องการใครสักคนที่จะแปลข้อมูลเป็นภาษาจีนและทำเครื่องหมายตำแหน่งบนแผนที่ google I have information of the police check car in some cities Thailand . I need someone to translate the information to Chinese and mark the location on the google map.
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการ Web Application เพื่อจัดการ GPS Fleet Management โดย มี Hardware GPS 1. กำหนดการเดินทางต่อวัน (สถานที่ ตามใน Database) 2. ระบบคำนวนค่าน้ำมัน/แก้ส ตามระยะทาง 3. ระบบบันทึกการที่รถวิ่งและตรวจสอบว่าไปถึงสถานที่นั้นจริงหรือไม่ (check point)
I'm looking to build a dynamic, modern Shopify website for my dropshipping business. This website primarily needs to cater to children and their parents, making it interactive and engaging is key. this would be my ideal site , can you copy sections etc and we get our own ali express drop shipped items Please check reference and let me know if you can do simialr in shopify and adding items from ali express . Key requirements: - The website will majorly feature toys, hence category system should be optimized for it. - The design preference is modern. The website should reflect a clean, intuitive and user-friendly interface that appeals to children and parents. - It should have all the essential features of a dropshipping business
I'm looking for an experienced professional who can rework my website's SEO and content rewriter. Skills required include: - In-depth knowledge of SEO optimization - Strong copywriting abilities for content rewriting - Understanding of user engagement metrics - do plagiarism check - sound more human not like AI This task involves not just implementing SEO, but a complete content rewrite ONLY Results-driven strategies and creative, engaging content are key to achieving the objectives of this project.
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important business de...
...brilliant idea, please don't hesitate to share it with us. Final file must be handed as .ai file, yes we check it pixel by pixel. ------------------------------- you can check our company's detail on here (Open Beta) Codibu = Coding + Bureau = A chest of drawers, often with a mirror at the top. A division of a government department or an independent administrative unit. An office for collecting or distributing news or information, coordinating work, or performing specified services; agency: Services CODIBU is a website platform with a simple mission—to provide an easy and the best environment for people who need websites. WordPress Based 600+ Live Demo & 1 click Install Hosting & Domain & 2700+ Plugins Website Buil...
I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and exper...
I'm looking for an experienced software developer to build a small online scanner to probe specific PC information and then verify its presence. The details include: - Operating System details. The exact aspects of the operating system that need to be verified are: - Identifying System Files. - Checking for Registry Entries. - Confirming the Presence of Installed Programs. You will need to check via an online scanner, the user must never download anything. There will be many sections on this project.
I have a database with 200,000 SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will be crucial in ensuring the effectiveness of this project.
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
I'm in need of a skilled graphic designer who can assist in updating my current company logo. The file is in a PNG format, and it needs to remain consistent in the artistic style and colors. Key tasks include: - Adding the text "lite" to the logo in a creative manner. - Providing 3 to 4 variations for this update. - Retaining the same color scheme as the current logo. Ideal skills for this project include proficiency in graphic design programs like Illustrator or Photoshop, strong creative ability in typography and keeping brand continuity. Experience in logo design will be highly appreciated. Please share samples of previous work in your portfolio, specifically those that demonstrate text placement on images.
International Affairs Consultant (Remote) Role: International Affairs Consultant...complex international issues clearly and concisely Additional Information: Part-time: No work hours commitment, the only commitment is to complete the report on time according to the requirements Remote: Work at home, accept applications from all over the world Kindly Note: We commit to reviewing and processing all candidate applications within a week. If you do not receive any response, please check your spam mailbox. If you are passionate about global affairs, possess the ability to provide a strategic international perspective to an organization, and meet the qualifications listed above, we invite you to apply for this exciting opportunity. We look forward to shaping the future of success toget...
I'm seeking an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharas...(Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourage you to bid. Your understanding of the project could make a real difference. Let's discuss how w...
I'm looking for a skilled developer to update an existing capacitorjs plugin to version 5 and introduce Android compatibility. I am looking for a Geofence plugin. I have a good starting point with a public plugin, but it needs updating. Here is the source repository: Please reference it, and add updates to it for capacitor version 5, update any of the swift or Objective C code that may be out of date, add corresponding support for Android. Key Requirements: - The main focus of this project is to enhance the plugin's compatibility with various platforms, particularly iOS and Android. - The plugin should be updated to Capacitorjs v5 to ensure it's leveraging the latest features and security patches.. Ideal Skills and Experience: - Proficient
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
Looking for an expert React JS developer to enhance my existing design. The job requirements include: * Adding a new feature where a user can click on a "New tab + icon" to generate a new tab. * The new tab should inherit the same default options present in the existing design, such as a default search bar, navigation menu, and homepage button. Ideal for a candidate who has experience with user interface design in React JS, programming user authentication and payment processing, as well as integrating with social media APIs.
I am currently in need of an expert who could install Baserow directly from the source code on Ubuntu. Primarily, this is necessary for: - Database creation and editing: I want to utilize Baserow to its full capabilities of managing and organizing my data through its database creation and editing feature. - User and group permission management: Not just that, but I also want to integrate its user and group permission management feature for better control over data access and collaboration. Anyone with substantial experience in Ubuntu, Baserow, database management, and system administration would be the perfect fit for this job. It's beneficial if you are accustomed to working directly from the source code. Your expertise will significantly contribute to the efficient data man...
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeeping or a...
