Vba excel 2010 pastespecial method range class failedงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...หรือโมบิล จากนั้นส่งมอบและอนุมัติการส่ง ระยะเวลาของโครงการจะขึ้นอยู่กับจำนวนเวิร์คช็อปและความพร้อมของผู้เข้าร่วม ‐‐-------------------- Please apply only if you are located within these regions: Chiang Mai, Chiang Rai, Surat Thani & Songkla. It will be required to download/sign in our app to monitor each tasks; mainly looking around car branded independent workshops that provide the full range of oil and lubrication services. We are interested in those who are using Castrol, Valvoline, PTT, or Mobil branding; then deliver and approve submission. The project duration will depend on the number of workshops and the availability of participants.
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)
ต้องการสคริป Jquery Script สำหรับโฆษณาวีดีโอ ก่อนโหลดตัวเล่น Iframe จาก data-href button - ตอนกดโหลด Player จะมีโฆษณามาแสดงทุกครั้ง ก่อนที่จะดึงตัวเล่นมากจาก data-href <div class="player_ep"> <div style="text-align: center"> <button type="button" data-href="" data-resolution="fast_p2p" class="btn btn-primary play-ep">Player 1</button> <button type="button" data-href="" data-resolution="google_photos" class="btn btn-default play-ep">Player 2</button> </div> </div> โดยรูปแบบ ดึงโฆษณาวีดีโอมาแสดง จะดึงจาก รูปแบบคล้ายๆ แบบนี้ครับ หรือออกแบบมาให้ก็ได้ครับผม <script> ...
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
...มูลนิธิต่างๆให้เข้ามาลงทะเบียนเพื่อรองรับการบริจาคจากผู้บริจาคในรูปแบบต่างๆ เช่น ผ่านบัตรเครดิต ตัดบัญชี QR หรือ Line (ขอบเขตของงานเป็นแค่การเชื่อมต่อ Redirect ไปที่ Gateway หนึ่งๆ แต่ไม่ต้องพัฒนาเรื่องการชำระเงินเอง) สามารถพัฒนาจากที่อื่นได้ แต่ตอนทดสอบต่างๆต้องเข้ามาทำงานในที่สำนักงานใหญ่ (กรุงเทพ) Screen ต่างๆ ที่อยู่ในขอบเขตการพัฒนา Donors • View Organizations - Display story and donation method selection • Donation Status - Display result of the payment from Payment Gateway, Direct Transfer, or Rabbit Line Payment • List Donation Transactions - Search for all the donation transactions based on the input from donors like citizen id, full name, and mobile number Administrators • Manage Organizations - List all organization that were regis...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Food R and D is looking to launch its range of baby products in Q2 2016. We are launching 4 ready to eat baby food in cups and 2 Freeze dried products in boxes. As part of our brand debut, we are looking to promote brand identity as well as familiarity among consumers. หากต้องการข้อมูลเพิ่มเติมสามารถติดต่อได้ทางข้อความ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.
I am currently experiencing configuration errors for configmap where i get error "error: failed to create configmap: Request entity too large: limit is 3145728 task: Failed to run task "default": exit status 1."
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
I'm on the lookout for a professional who can help me with an Integrated Management System (ISMS and BCMS Toolkit) to streamline management processes. This system should be designed to benefit all e...user-friendly and can cater to all employees regardless of their technical proficiency. - Develop the system with an aim to enhance the overall efficiency and productivity of the organization. Ideal Candidate: - Proven experience in developing and implementing similar Integrated Management Systems. - Strong understanding of ISMS and BCMS concepts. - Ability to create user-friendly systems for a wide range of employees. - Excellent problem-solving and time management skills. If you think you fit the bill and can help me streamline our management processes, please don't hesit...
Bus I'm looking to build a bus booki...ability to choose their preferred seating - Implementation of real-time bus tracking for up-to-date travel information - An easy way for administrators to add new boarding and exit points, bus types and route details - Database of all the bookers which book through us. - Need login system in built its good if we have login with Google option in it Payment: The website should have UPI as a payment method for customers to handle online transactions seamlessly. There is currently no time limit on this project. Freelancers with experience in web development, particularly in designing booking systems, user interface design, and integrating payment gateways would be well suited for this project. Knowledge of live tracking features would also...
I need a modern and sleek website designed to showcase a range of electronics. It will primarily target professional users, so a polished, professional look is crucial. Key Features: - The website should have a clean, user-friendly interface that presents the technical specifications of the electronics clearly and effectively. - The implementation of SEO is key as we want the site to rank highly in search engines for relevant keywords. - Integration of features like product comparison and user reviews are not a priority for now, we're focusing on technical specifications. Skills and Experience: - Proven experience in designing and developing websites for the electronics industry, especially geared towards professional users. - Expertise in SEO and driving organic traffic to ...
...Paysavo.com. The video will be around 10 minutes long. The video will need to cover, in detail, the following: - An introduction to - A Functionality overview - The Deposit and withdrawal process - How to use our Crypto exchange - Our International money transfer services - The Multi-currency wallet function -Currency conversion functions -Various currencies supported. -Various Payment method. - Conclusion Also provide short videos for a Help page outlining each functions per outline While there isn't a stringent outline set in place, the above will serve as a flexible guideline for the flow of the explanation. Our target audience for this video are general public, potential investors and business partners. So, a professional yet straightforward explanation is crucial...
... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
I'm seeking a tu...include: - Simultaneous project development and learning: We'll work on a real project in your area of expertise, allowing me to learn by doing. - Tailored teaching: As we work, I'd like you to explain the 'why' behind each step we take, breaking down complex concepts into understandable parts. - Flexibility: I haven't stated my preferred learning style, so your ability to adapt your teaching method to suit my learning style is essential. The ideal candidate should have: - Strong knowledge and experience in Programming, Graphic Design, or Marketing. - A passion for teaching and can explain complex topics in a simple and engaging manner. - Patience and flexibility to adapt teaching style to suit my learning needs. - Ability to guide ...
I'm looking for a dynamic, creative motion graphics designer to help create educational content aimed at making science more engaging and understandable to everyone. Key Requirements: - Experience in creating educat...creative motion graphics designer to help create educational content aimed at making science more engaging and understandable to everyone. Key Requirements: - Experience in creating educational motion graphics, ideally in the field of science. - Ability to translate complex scientific concepts into clear, concise and engaging visuals. - Considerable understanding of designing content for a wide range of audience, especially those without a science background. Your innovative approach to design and ability to engage varied audiences is key to the success o...
As a client seeking to create a detailed and useful content on business report writing, I am in need of a diligent freelancer who can create business report writing sample blogs. While I haven't specified particular topics or a target audience, the successful freelancer must have a versatile writing skill that can cater to a broad range of readers, whether they be students, professionals, or business owners. Key Responsibilities: - Generate blog posts that serve as concrete examples of outstanding business report writing. - Craft content that educates readers on different elements of business reports, potentially covering topics such as report structure, data analysis, and presentation techniques. - Showcase your prowess in report writing, demonstrating a high level of know...
...3. Calling service like Uber 4. Payment gateway Features in modules 1. Admin * Login. Option to create new ids * Dashboard * Setting up price for the product. * Tax module * User Access Module * To create new users for admin * To create new vendor users * Reports * Delivery status of product * Qr generator * QR printer * Handling of failed transactions * Auto mailer to admin user of the performance and to customer for promotions 2. Customer 1. Otp based login and signup 2. Change password 3. Profile management and editable 4. Purchase product through online payment. No refunds/returns 3. Vendor 1. Login id can be created by admin only 2. Change or reset password 3. Profile managem...
Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...
I'm looking for a dedicated Shopify expert to assist with a medium scale product listing project. - I have a range of 51-200 products that need to be listed on my Shopify store. - Each product requires a unique, custom description. - The project does not include photography services, so I will provide all necessary images. Ideal candidates should have: - Extensive experience with Shopify and product listing on e-commerce platforms. - A flair for writing engaging, SEO-friendly product descriptions. - The ability to handle a medium-sized product listing project efficiently and accurately.
I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.
I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.
Bus I'm looking to build a bus booki...ability to choose their preferred seating - Implementation of real-time bus tracking for up-to-date travel information - An easy way for administrators to add new boarding and exit points, bus types and route details - Database of all the bookers which book through us. - Need login system in built its good if we have login with Google option in it Payment: The website should have UPI as a payment method for customers to handle online transactions seamlessly. There is currently no time limit on this project. Freelancers with experience in web development, particularly in designing booking systems, user interface design, and integrating payment gateways would be well suited for this project. Knowledge of live tracking features would also...
I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.
...tester to join our team. As a penetration tester, you will be responsible for identifying and exploiting vulnerabilities in our systems to ensure they are secure. Your main tasks will include conducting vulnerability assessments, performing penetration testing, and providing recommendations for remediation. To excel in this role, you should have a strong understanding of various testing methodologies, possess analytical skills to interpret test results, and be familiar with a wide range of penetration testing tools and techniques. Skills required: - Penetration testing - Vulnerability assessment - Ethical hacking - Knowledge of network protocols - Familiarity with security frameworks - Strong problem-solving skills This is a medium-sized project with a duration of 1 to ...
I'm looking for a skilled website designer and developer to create a website for my digital marketing agency. - Purpose: The website will serve as the online face of my agency, so it needs to be engaging, professional, and reflective of our services. - Services: We offer a range of services, including SEO, Social media marketing, Pay-per-click advertising, and UI/UX, so the website should be designed to showcase these services effectively. - Target Audience: Our target audience is primarily small businesses and startups, so the website should be designed with these groups in mind. The ideal freelancer for this job should have a strong portfolio of website design and development work, ideally in the digital marketing space. Experience in e-commerce, UI/UX design, and optimiz...
...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...
I'm seeking an experienced UX/UI Designer to create a conversion-optimized user interface. A strong unders...Details: - Objective: The main goal of the project is to effectually improve conversion rates. - Target audience: The design should ideally appeal to professionals aged between 25 and 44. Ideal Skills and Experience: -Proven expertise in UX/UI Design -Understand visitor flow and conversion funnels -Experience in designing for a professional demographic For the design elements and functionalities, I failed to specify in advance, thus am open to your professional recommendations. The final deliverables should include engaging, dynamic elements that effectively drive conversions. I look forward to your creative, fresh ideas. Let's optimize for an enhanced conversion ...
I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.
I'm in need of a professional who can help me list a range of jewelry findings on Amazon. This task involves: - Listing: Editing current products, creating product listings for different types of jewelry products. - Keyword Optimization: Including relevant keywords to improve searchability and visibility on the platform. - Categorization: Ensuring the listings are correctly categorized to reach the right target audience. - Images: Adding high-quality images of the findings to attract potential customers. The ideal candidate for this project should have experience in Amazon product listing, particularly in the jewelry category. Knowledge of SEO and Amazon's backend processes would be beneficial. A keen eye for detail and good organizational skills are also key.
I need a mechanical engineer with experience in product enhancement to improve the design of a wearable exoskeleton robot product. Key aspects to be addressed include: - Improving the adjustment and attachment aspects of the product, specifically in relation to Straps and fasteners, Joint movement range, Comfort padding, IP65 rating, Battery pack integration, Electronics and wiring integration, Adjustment to waist width and depth. Ideal skills: - Strong mechanical engineering background - Experience in product development - Proficiency in working with wearable technology products is a big plus - Knowledge in ergonomics, performance enhancement, and aesthetics - Ability to understand and meet user needs through custom adjustments I'm looking for someone who can combine ...
