Excel vba custom date pickerงาน
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...
Develop Real-time Tracking Flight and show position and status on map == Frontend == - Fullmap display - Can add custom layer from backend to map - Can define color of status from backend == Backend == - Authenticate - Config map - Config Api for tracking plane - Display Data from api (Keep data to database)
ทำ 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)
เรามีเว็บไซต์ของเราอยู่แล้ว เเต่ขาดคนมาพัฒนาต่อให้เป็นไปตามความต้องการของผู้บริหาร คุณสมบัติ 1. เข้าใจ Magento2 2. มีประสบการณ์ปรับแต่ง extension ของ Magento2 3. มีประสบการณ์ และสามารถ Custom Template Magento2 ราคาตามแล้วเเต่ตกลง หากต้องการรายละเอียดเพิ่มเติม รบกวนติดต่อผ่าน ID Line : mic19448
เป็นเว็บไซต์เชิง marketplace ปัญหาตอนนี้ 1. เว็บไซต์ช้า น่าจะเกิดจากตัว code 2. ดึงข้อมูลสินค้าจากหลังบ้านไม่ขึ้น 3. หาคน Custom บางรายการ งบประมาณแล้วแต่ความสามารถ
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ตอนนี้กำลังหา Freelance Programmer เพื่อเขียน Drupal8 อยู่ครับ อยากได้คนที่สามารถเขียน Custom ได้ด้วยครับ รายละเอียดสามารถสอบถามได้ภายทาง Line ครับ Location Based in : THAILAND Line ID : sompon_l
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...various trendline trading methods. The resulting script should be centered on trendline trading. Your role will involve creating a script that operates effectively on the TradingView platform. Prior experience in similar projects will be advantageous. Please include samples of your previous work in your bid. Thanks, and I look forward to a productive collaboration. Details: I will provide my custom indicator to you. You will provide script for strategy that allows me to test for the following: *UC = user customization (the user should be able to set the following settings) 1. Buy when certain conditions are met based on the indicator using a certain percentage* of the available cash. 2. Sell a certain percentage* of the position when certain conditions are met (stop loss*...
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...
...unique Twitch stream overlay capturing the essence of a thunderstorm. Key features of the project include: - Thunder/Lightning/Storm theme: I want an overlay that portrays a thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching storm theme....
...unique Twitch stream overlay capturing the essence of a thunderstorm. Key features of the project include: - Thunder/Lightning/Storm theme: I want an overlay that portrays a thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching storm theme....
I am in need of a freelancer who can create a simple custom diagram for me. The diagram is intended to illustrate the relationships between different concepts. Below are the specifics: - Diagram Type: It won't be a regular flowchart, Venn, or Mindmap, but rather a unique combination that suits my specific need. - Diagram Elements: It should incorporate text boxes and various shapes to align with the concept definition. Ideal candidates would have demonstrated experience in visual communication, diagram making, and conceptual design. An ability to understand complex relationships and depict those simply is a must for this project. I have attached an example of a crude version of the diagram that I am looking for. I would like to use no more than two colours (it could...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is desi...Requirements: 1. Fluent both orally and written in English and the local language (Khmer) 2. Have good research skills, and experience in internet research, preferably business-related 3. A native of India, domiciled in Cambodia DELIVERY ELEMENTS: • All relevant news, if reported in the native language (Khmer) must be translated into English • Weblink of the news, together with o Source name o News date Note: Milestone will be released the following week (Monday) after the job completion to give us time to organize the report and contact you if we need additional clarification.
Hi, I'm searching for a developer who can make a custom quotation system inside my WP website. This tool has to do retrieve data from my woocommerce products and display them inside a new page. These are the specifics: The products in the website are simple ad variable. They have some custom fields added with ACF. The main task is to create a new page that allows the user to go through 3 steps. In step 1 the user can choose: Brand, Model, Setting via a drop-down menu. In step 2 choose: Total KM, Duration, Condition, Change. In step 3 show Price, Inventory and Delivery Time. This data must be related to the variants of the individual products therefore show only the corresponding variant in the corresponding drop-down menu also in WooCommerce. This page has to be acces...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP ser...
Hi, Job Title: Senior Developer - SQ...for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office. - Work Location - Dubai - Number of Working Days - 6 days ( Monday to Friday ) - Number of Working Hours - 10hrs per day - N...
As a fast-growing business, I require a talented WooCommerce plugin developer to create a custom plugin for my e-commerce website. The aim is to bring in a dynamic transformation of product images in response to the selection of different attributes. Key requirements and tasks include: - Generate a solution that initiatively changes a product's image based on attribute selection (specifically size and color) - Develop an interface at product level that allows adding images for each attribute - Ensure this functionality does not necessitate the creation of variations. Notably, I have a diverse product range involving 10+ colors, so the proposed solution should cope with this complexity. Ideal Skills and Experience: - Fluent with WooCommerce plugin development - Solid under...
I'm looking for a skilled website developer to cr...company, its values, offerings, and more. The ideal freelancer for this project will have: - Significant experience in building company websites. - A good understanding of SEO, to ensure the website ranks well in relevant searches. - Up-to-date knowledge of modern design trends and user experience (UX) principles. - Strong communication skills, enabling effective collaboration throughout the development process. At the moment we have this website: and we would like to replace it with something more up to date. My partner has this other website: and I like the style of it but I would appreciate any ideas with design. We're looking for something clean and stylish.
...be the backbone of an advanced project - an IoT device with connectivity capabilities. Key Responsibilities: - Designing a custom circuit: Your main responsibility will be designing a custom circuit. Given that the project is advanced and involves IoT features, the circuit design will need to be equally intricate. - Building a functional prototype: While the primary focus is on circuit design, you will also be involved in prototype development. Your understanding of components, connectivity and functionality will be crucial in bringing this prototype to life. Ideal Skills and Experience: - Proficiency in circuit design: You should have experience in designing custom circuits, ideally for IoT or similar advanced projects. - Prototyping experience: Understanding of...
Looking for a freelancer with expertise in managing and manipulating numeric data sourced from Excel spreadsheets. The work involves: - Efficient management of extensive numeric data - Organizing the data effectively onto separate worksheets according to their specific types Ideal candidates are those with previous experience in data entry and strong proficiency in Excel. Your responsibility would not only be to perform accurate data entry, but also structure it logically and intuitively. It requires excellent attention to detail, precision, and the ability to understand data categories. We value those with a proactive approach who can offer insights into improved data organization. Solid experience in similar projects is preferred.
I have a site to get inspiration from...should have a professional look and be user-friendly, with an interface that makes it easy for customers to browse and purchase products. - As for payment integration, it's crucial that the website supports credit card processing. I have a specific processor, Lenbox, that I'd prefer to use. Ideal Freelancer: - Proven experience in developing e-commerce websites using WordPress. - Familiarity with custom payment gateway integration, specifically Lenbox. - A good eye for design with the ability to create a visually appealing and user-friendly website. If you feel you have the skills and experience needed to complete this project successfully, I look forward to reviewing your bid. Please include examples of similar projects you'...
I am seeking a confident designer's assistance to create 18 unique images for me. Each image will feature: - A texture-based background. The theme for each one will be a metallic card. - 1 to 2 words of minimalist-style engraved text. - My logo, also engraved in a minimalist style. Each image should be a medium size, measuring between 5 and 10cm. Ideal Skills: • Graphic Design • Illustration • Photoshop This project requires a keen eye for design, particularly regarding texture and minimalist aesthetics. If you have a strong understanding and capability within this area, I’d love to see your prior work reflecting these styles. Very porly done example in attachments :)
...disclosed at this time, to further my projects in data analysis. The collected data will need to be formatted into a user-friendly spreadsheet which can be easily utilized for further usage. Key requirements and skills: - Proactive approach to understanding and gathering a broad range of data types - Experience with data analysis tools and strategies - Proficiency in spreadsheet software, particular Excel - Strong organizational and communication skills - Keen attention to detail when it comes to data gathering and analysis - Able to deliver the complete data in a spreadsheet format Your experience in data collection and analysis, with previous jobs involving diverse data types, will be highly advantageous. Upon completion, you may be contacted for further data analysis tasks. ...
...and actions taken. Offer ongoing recommendations and optimizations based on analytical data. **Deliverables**: A comprehensive SEO strategy tailored to the book's promotional needs. Monthly performance reports. Ongoing support and adjustments for three months post-implementation. **Project Timeline**: The initial phase of the SEO campaign should be completed within 30 days from the start date, with ongoing optimization and reporting to follow for at least three months. **Budget**: Please provide a detailed quote for the initial setup and the monthly maintenance phase. **Vendor Requirements**: Proven experience in SEO with a portfolio that includes similar projects. Excellent understanding of Google Analytics and other SEO tools. Strong communication skills and t...
...customers, the app will allow users to create profiles by entering: Customer Name Contact Information (Phone, Address) Vehicle Details (Type, Engine Type, Oil Type, Filter Types, Battery Size, etc.) Additional Notes Existing customer data can be easily accessed and updated upon subsequent visits. Service History Tracking: The app will record and display the vehicle's service history, including: Date of service Employee who performed the service Services rendered Mileage at the time of service Reporting: Generate reports to track the number of cars serviced. Future Considerations (Not required for initial development): QR Code Support: Implement QR code scanning as an alternative to RFID. SMS Reminders: Develop a system to send automated service reminders to customers. Target...
I am looking for a talented web designer who can create a simple wedding website for me. This project will include creating three specific pages, including: - A home page: This page should clearly display the couple's names and the date and time of the wedding. Additional details about the wedding and maps showing its location should also be included. It should be simple in design but still capture the simplicity and elegance of the event. - Event details page: This page will provide more in-depth information about our wedding, including aspects not covered on the home page, the venue, and other necessary details. - RSVP page: Our guests should be able to confirm their attendance easily through this page. - A Tips page is also needed for our guest's convenience. The ...
...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experien...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
...detail and adherence to brand guidelines. *Use creative editing techniques to enhance visual appeal and engage the audience. *Add appropriate music, sound effects, and graphics to enhance the overall impact of the videos. *Understand project requirements and deliver videos that meet or exceed expectations. *Review and incorporate feedback to continuously improve the quality of the videos. *Stay up-to-date with industry trends and best practices in video editing and YouTube Shorts content creation. Requirements: *Proven experience in video editing, with a strong portfolio showcasing your editing skills. *Proficiency in video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar. *Strong attention to detail and ability to deliver high-quality work under tight dea...
Contact us for leather jackets track suits shoes bags or in other fabric you want... also for sports items and sportwears....we send you sample as free of cost for quality checking.... All items are good in quality and cheap in price We export all these items and goods...in other countries If you are interested then contact us.... Thank you?
I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills ...Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your ...
