Combine multiple excel files into one worksheet vbaงาน
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 ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I want translate English to Japanese 1 page within 1 hr.
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 need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior
...STM32F030 bare-metal programming to develop firmware for a sensor-based embedded system. The project involves real-time sensor data acquisition, data parsing, peripheral control, cloud telemetry integration, and local display updates. This role requires interfacing multiple peripherals, including UART, SPI, ADC, PWM, and RS485-based devices. The firmware should be optimized for low-power operation, real-time data acquisition, and fault-tolerant operation. Develop bare-metal firmware (NO RTOS) for STM32 microcontroller. Implement multiple UART sensor interfaces (data request, parsing, checksum validation). Handle analog sensors (ADC readings, conversion, scaling). Implement PWM-based control for actuators (motor, pump, or fans). Interface an NB-IoT module (AT commands, CoA...
I'm looking for a website that can facilitate both the submission and assessment of exams and homework. The site will handle multiple choice questions, essay prompts, and mathematical problems, catering to both students and teachers. Key Features: - Diverse Assessment: The website should be capable of correcting various types of exams and homework, including multiple choice questions, essay questions, and mathematical problems. - User-Friendly Interface: The platform will be utilized by both students and teachers, so an intuitive, easy-to-navigate interface is essential. - Comprehensive Feedback: The site will need to provide a range of feedback, including automated responses, space for teacher's comments, and grading. Ideal Skills and Experience: - Proficient in...
...content and challenge you to design and execute an analytical strategy, just as you might in your professional life. In Week 5 you submitted a storymap including the overview of the problem, your research question, and available data sources which was approved by your instructor. The final project should include the following GIS skills: downloading and/or creating data, symbolize layers, perform multiple analysis to inform your issue, creating web maps and tables and describing your entire project in a storymap format. Grading Rubric - Your final project will total 320 points with 45 coming from your proposal and 275 coming from the remainder of the project. Please ensure your storymap has been published and shared with the UW organization. You can then provide the url below....
We are looking for a skilled digital artist or graphic designer to create progressive visual effects for a series of collectible artworks. Each artwork will have six upgrade tiers, with each tier receiving a static PNG base image and an animated GIF overlay that enhances its prestige. The enhancements must be scalable across multiple artworks within the same tier, meaning they should not require custom adjustments per piece. The effects should be subtle yet striking, adding depth and rarity without overwhelming the base artwork. Scope of Work: Develop six levels of GIF-based visual effects, with increasing intensity and prestige. The effects must be universal and reusable, applying seamlessly across all artworks in a given tier. The final designs must work as an overlay on a stati...
I'm in need of plans for a detached garage designed in a traditional style. The primary use of this garage will be for vehicle storage, specifically accommodating three or more vehicles. Ideal Skills: - Architecture - Structural Engineering - CAD What I Am Looking For: - Design plans that are aesthetically pleasing in a traditional style - Plans that consider storage and accessibility for multiple vehicles - Expertise in creating structural plans that are safe and durable Must be cbs construction to meet Miami Dade County standards
I need assistance extracting certain pages of ~400 scanned PDF files into 3 folders per file. The brief is attached. The files will be available via Dropbox. Ideal Skills: - Indonesian language familiarity a bonus - Familiarity with PDF handling - Attention to detail Experience: - Previous data processing work - Experience in organizing digital files is preferred Estimated time = 50 hours
...need a custom Notion workspace to manage tasks across multiple teams (both tech & non-tech). The system should be simple, mobile-friendly, and easy to use, as many team members are not tech-savvy. Key Features Required: ? Task & Project Tracking ✅ Single Page View – Track all pending activities in one place (e.g., website development, vendor hiring) ✅ Task & Subtask Management – Each task can have multiple subtasks for better tracking ✅ Track by Department & Assignee – View status updates for the Marketing Team, Engineering Team, etc. ✅ Progress Tracking – Percentage-based completion tracking ? Advanced Filtering & Custom Views ✅ Pre-set filters to track by Department, Assignee, Status, Due Date, and Progress ✅ Custom St...
I need a reliable copy typist to transcribe my scanned documents into PDF format. The ideal candidate should be able to provide a standard text output without any special formatting. Key Requirements: - Typing from scanned documents - Delivering in PDF format - Providing standard text without special formatting I appreciate attention to detail and quick turnaround times. Please reach out if you're interested and able to assist.
<Overview> The technology I am looking for this time is a display device that can be installed inside the vehicle and display information on multiple adjacent display areas. This technology has the function to change the display items for each display area based on user operations and the function to save the display items set for each display area. Please search for this technology. <<NOTICE>> The target car brands in this search are limited to US, European, Chinese, and South Korean brands. <Requirements for Payment> ★Clearly indicate the URL of the website or YouTube site as the basis for the evidence. ★Please clearly indicate where the above technology is disclosed. [example 1]★Technical Details YouTube: “youtube.com/watch/v=OEczSq” Time: 2...
...challenge, each player deposits an amount as a participation fee. The total amount is collected in an in-app wallet. After the game ends, the winnings are distributed as follows: 40% to the winner 10% to the loser as a consolation prize 50% taken by the platform as a fee C. Digital Wallet & Financial Transactions In-app wallet that allows users to deposit and withdraw money. Support for multiple payment methods like credit cards, digital wallets, and cryptocurrencies (if applicable). Secure financial management with user identity verification to prevent fraud. D. Room Types & Multiplayer Gaming Public Rooms: Open for anyone to join and watch challenges. Private Rooms: Created through private invitations for selected users only. Tournaments: Ability to host...
I'm in need of a versatile professional who can help with various tasks, mainly focusing on copywriting and content creation specifically for Instagram. Key Responsibilities: - Crafting compelling copy across a variety of themes and topics - Creating engaging Instagram content that resonates with our audience - Assisting with other tasks as needed Ideal Skills: - Excellent copywriting skills - Deep understanding of Instagram and its content dynamics - Versatile in handling different types of tasks Please get in touch if you're ready to help with this multifaceted role.
Convert Figma designs into responsive WordPress pages using Elementor
For a shared Excel file on Sharepoint, need two scripts (or a way to do the following): 1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date. 2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.
I need a professional imag...You will be working with: - Digital renders of merchandise, primarily decor. Approximately 30 images for edit, and, then simple color options for them. - PNG file format images. - Your task will include: - Isolating individual items from group images. - Editing these items to appear correctly in the photo. - Altering the items to display multiple color options. - All final images should be set against a clean white background. - Some images will have multiple items in the picture. Ideal candidates should have experience with product image editing, particularly for eCommerce platforms. Proficiency with image editing software is essential. Please provide examples of similar work if possible. Please provide requirements and advise of completion time...
...requirements and documentation required for account setup - Providing the ability to send received money to a designated bank account - Create a QR code and link for each invoice. - Embed invoice details (such as amount, reference number, etc.) on the payment and invoice page. - The integration should allow initiating payments, confirming transactions, and tracking payment status. - Should support multiple currencies. - Link the invoice link to our Visa account number to receive payments. - The payment link should include the invoice number, customer name and due amount. The ideal candidate will have: - Proven experience in Visanet QR code and payment link integration - Proficiency in online payment systems - Strong understanding of the requirements for online business transacti...
...currently at an intermediate level, looking for a minimum of 10 one-hour sessions. Each session will be conducted over remotePC, with the aim of improving my abilities and understanding of Blender. Key Focus Areas: - Rendering: I want to dive deeper into the intricacies of Blender's rendering capabilities. - Product Modeling: I need guidance on how to effectively create product models. Ideal Skills and Experience: - Extensive knowledge and experience with Blender. - Proven teaching experience, preferably with remote one-on-one sessions. - Strong understanding of product modeling and rendering. - Patience and ability to explain complex concepts in a simple manner. Please note, each session must be conducted on a remotePC for one hour. The sessi...
...at promoting self-reflection, personal responsibility, and emotional regulation among incarcerated youth. Program Details: - The program will cover six sessions, each with a distinct theme: identity and values, emotional intelligence, decision-making, anger management, overcoming past mistakes, and accountability. - Each session will be delivered through interactive quizzes, which will include multiple choice, true/false, and short answer questions. - A key component of the program is tracking the user's progress, which will be done through progress reports. Ideal Skills: - Experience in creating interactive educational programs. - Proficiency in developing quizzes with various question types. - Ability to design a user-friendly progress tracking system. Please bid if you...
I'm looking for a Telegram bot that can automatically execute trades based on Forex signals to MT4. These signals should be sourced from multiple predefined sources, not just a single channel or API. Key Features: - Automated trading based on Forex signals received through Telegram - Ability to source signals from multiple predefined sources Ideal Skills and Experience: - Proficiency in creating Telegram bots - Strong understanding of Forex trading - Experience with automated trading systems - Ability to integrate multiple data sources
More details: What kind of reports are you looking to make on the Discord account? Scam Are you looking for a detailed report format or a simple one? Simple Do you already have evidence for the scam activities? Yes, I have evidence links here
I need a graphic designer to recreate a design in high resolution for print. The design is a watercolor style and will be 1.2m wide. It should be delivered in multiple formats to ensure print readiness, including but not limited to: PDF, JPEG, TIFF, EPS, and Photoshop files.
I'm looking for a 3D rendered video of a metal bed frame that rises vertically on all four legs. The bed's elevation should be controlled by a wireless remote. Key Requirements: - The level of detail in the video should be a basic outline with movement. - The video should showcase multiple angles of the bed frame. - The functionalities of the remote to be highlighted are: basic up and down movement and custom height settings. Ideal Skills and Experience: - Proficiency in 3D modeling and animation software. - Previous experience creating 3D render videos. - Understanding of product animation for showcasing functionality. - Ability to deliver a video with a clear, simple, and engaging outline of movement.
I am looking for draftsman to complete some house plans with CAD and dimensions for the attached excel sheet. Please get in contact of you have any queries Regards
