Excel vba check if date is weekend or holidayงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 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 for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling ...names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...
...Java developer with a deep understanding of e-commerce application development. The goal of this project is to build a module that calculates the estimated delivery date of the products. Key features include: - Processing Days - Transit Time - Store/Warehouses - Carrier - Estimated Delivery Date Calculation The project scope is fully detailed, providing comprehensive, clear directions about what needs to be developed, ensuring clarity and understanding. The ideal candidate should have: - Thorough understanding of Java, Spring Boot - Substantial experience in e-commerce application development - Knowledge and experience in integrating desired features, particularly an estimate delivery date calculator - Proven ability to work following detailed spec...
...on-site exam in Nottingham, UK. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam content aloud. You will then enter the answers as instructed by the candidate. The...
As part of my endeavor to secure my systems, I am seeking an ethical hacker to primarily focus on data security. By extensively exploring the potential weaknesses and vulnerabilities, your primary goal will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of...Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the identified issues Rest assured, full access to the necessary systems will be granted for the successful execution of the job. Please note that a thorough professional background check will be performed before ac...
I need a flutter developer. The application is ready on github so the deployment on App Store is what's needed for iOS 16. Your primary role will be to ensure successful and smooth application upload and compatibility check. Please have examples of previous similar work to show.
...an interactive design for our property management application using Figma. The application is intended to streamline property management operations, offering functionalities like task management, team coordination, guest management, and more. Scope of Work: The designer will be responsible for: Creating an interactive and user-friendly design in Figma Developing wireframes and prototypes based on provided sketches and descriptions Suggesting and implementing improvements to enhance usability and aesthetics Ensuring responsive design for both web and mobile views Pages to Design: Home Page: Displays an overview of tasks, notifications, and key metrics for the day. Contents: Summary of check-ins/check-outs, ongoing tasks, alerts, and quick links to other sections...
...initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L visualization of all wallet investments in one view, allowing the user to check the total bonding curve of SOLs versus SOLs owned in the project. Implement a comment bot to automatically write comments on each project. Qualifications: Proven experience in developing trading bots. Strong understanding and experience with the Solana network. Familiarity with the Pumpfun platform is mandatory. Proficiency in programming languages such as Python, C++, or Java. Experience with trading APIs and platforms (e.g., REST, WebSocket, FIX protoc...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
i need to creat a mobile app with sign in a'd sign up + 3 pages: 1 where i can publish daily trading signals 2 a tutorial with image a d text 3 an api news where ppl can check daymily economical and financial news 1st page must be like showing i the screen shot
I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript...
I am looking for a developer who can create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be developed fo...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity." I want the summary as "...
I'm in need of a competent web developer to craft a straightforward website for my courier business. The site will be primarily focused on providing clients with pack...website for my courier business. The site will be primarily focused on providing clients with package tracking information. Key Website Pages: - Home Page: This will feature my company's logo, name, and contact information. - Tracking Page: This is where clients can input their tracking number to see the current status of their package. It should also display an estimated delivery date. The ideal freelancer for this project should have experience in web development and a strong understanding of user experience design. A good communication skill is also preferred, as I'd like to be updat...
Seeking an experienced and strategic virtual assistant with over 3 years of experience to join our growing team. This role is a longer-term role with an ability to grow within the group of brands we are building. Currently looking for someone with experience or great people management / communication skills. Requirements: - Open minded - Teamplayer - Excellent communication - Have used Bumble, Tinder or any dating sites personally *** Preferably with sales background Job details: Monday-Sunday 8:00pm-4:00am (MDT) Type: I-9 Contractor Must sign NDA Random audits performed Check ins daily and weekly with team Start date: Immediately after hire Responsibilities: All chatter roles responsibilities. Pay: Hourly, but for the right person who, there are...
...monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. ...
Ben Arda, aktif olarak yeni iş fırsatları arayan biriyim. Canlı destek hizmetlerinde 6 aydır çalışıyorum ve bu süre zarfında müşteri memnuniyeti, marka değeri koruma ve doğru üslup kullanımı konularında derinlemesine tecrübe edindim. Esnek çalışma saatlerine uyum sağlayabilme kabiliyetim ve hızlı, etkili çözüm üretme yeteneğimle ekibinize değer katabileceğime inanıyorum. İletişim becerilerim ve problem çözme yeteneklerimle müşterilerinizi en iyi şekilde desteklemeye hazırım. Güvenilir bir hizmet sunarak, işinizi bir adım öteye taşımak için iş ilanlarını değerlendiriyorum.
...inquiries. Requirements: -Proven experience as a Virtual Assistant or relevant role. -Proficiency in using ChatGPT for content creation and customer engagement. -Strong knowledge of Shopify and its functionalities. -Excellent research skills and the ability to stay up-to-date with industry trends. -Exceptional copywriting skills with a keen eye for detail. -Strong organizational and time management skills. -Ability to work independently and meet deadlines. -Strong communication skills and a customer-focused mindset. Contract Details: -Duration: 6 months (July 2024 - December 2024) -Payment: Monthly payments, rate to be discussed based on experience. -Renewal: Opportunity for contract renewal in 2025 based on performance. If you are passionate about skincare, digi...
I'm looking to build an AI-assisted informative blog, targeting a general audience. The blog creation will be based on WordPress, and will require interns, who will be given adeq...creation The ideal candidate should have the following skills/experience: - Proficiency in WordPress, with prior experience in blog creation - Strong writing and editing skills, ensuring content is engaging and informative - Familiarity with AI tools, or a willingness to learn and adapt to using these tools - Prior experience in creating content for a general audience is a plus - A keen eye for design and user experience This is a great opportunity for entry-level interns looking to gain experience in WordPress blog creation and AI tools. Training will be provided, so a willin...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
