How to pull values from another worksheet excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
อัปเดต 4 แบบฟอร์มออนไลน์ใน Javascript Update 4 online forms in Javascript. Remove 3 paragraph from 1 form and add 1 text field to another form. Example, what needs to be done: Adjust this form according to the picture attached. Possible long term collaboration ahead.
...สามารถ 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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
Creating the corporate website for a chemical company with eCommerce function. Able to search 300000+ items and show suggested result while typing, login to see price, can generate a quotation online, has add to basket order function and send out email confirmation . If possible, the product data will link to an ERP database ( Winspeed). Has live chat function and customers can subscribe to our newsletter. Back office can pull the quotation data, order data and customer data. The website will have CMS to manages pages like news, promotion, career opportunities. Also include contact form and catalog request form. Also need graphic design for banners. And also do SEO. สร้าง website บริษัทโดยมี eCommerce function สำหรับสินค้าประเภ...
...developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization....
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table ...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and ...
I'm seeking a developer to create a comprehensive members' social media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scalability will be...
I'm looking for a professional who can extract specific text content from a website and organize it into different categories.
I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This work will prepare the files for our in-house frontend developer to implement into our site. Key Responsibilities: - Translate Figma design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages. The successful freel...
...allows the client to publish the product in a category (Example: Cards) and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an image of the category, a descriptive text and a graph that shows the evolution by...
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a lar...
I'm looking for a PHP expert to handle several minor tasks on my website. Key Responsibilities: - Implementing links from images to other pages. - Making the odd amend to the site - updating google maps code The work is quite straightforward and doesn't involve any major development. It's more about making small changes and ensuring the website works smoothly. Ideal Skills: - Strong PHP development skills. - Proficiency in HTML, CSS, and JavaScript. - Experience with integrating links and implementing simple changes. - Ability to understand existing code and make small tweaks. If you're a PHP developer who can quickly and efficiently manage these minor tasks, I'd love to hear from you. This may lead to ...
I'm looking for a skilled photo editor who can remove six palm trees from an image and fill in the space to make it appear as if they were never there. The aim is to blend the background seamlessly. Retaining high detail in the remaining parts of the picture is critical. Your expertise in photo manipulation and detail-enhancement will be a great fit for this job. High-level proficiency in using photo editing tools such as Adobe Photoshop or GIMP is essential. Strong attention to detail is also key to ensuring the picture maintains its natural look. If resolution can be increased, that is a plus. Keeping the cost down is important.
...priority project, and I need it completed as soon as possible. I would like to model it somewhat after this application or similar noise applications - Key Features: - Social Media Integration: The app should allow users to share content on various social media platforms. - Push Notifications: The app should be able to send push notifications to users to keep them engaged. - In-App Purchase Functionality: There should be options for users to make purchases within the app. Design Preferences: - Bold and Colorful Design: I prefer a design that is vibrant and stands out. - Custom Branding Elements: The app should incorporate specific branding elements to align with our company's image and values. Ideal candidates for this p...
I'm in need of someone to take the following designs and redraw them using photoshop or illustrator. It's a straightforward design. * Key Skills: 1. Graphic design 2. Logo design 3. Creative direction * Ideal Experience: 1. Have previously redesigned logos. 2. Experience in creating intricate logos. 3. Understanding of color psychology would be advantageous. Remember, I'm not necessarily out to recreate the wheel here, but I'm definitely looking for a more refined, sophisticated look.
I need a competent developer to incorporate bank transfer as a payment method on my existing website. Currently, my site only supports PayPal and I want to add another layer of customer convenience by allowing bank transfers. I need to be able to sell theater tickets, so an interactive sitting map should be available. While I haven’t decided yet on a specific bank or service for processing these transactions, I am open to suggestions. If you have prior experience with multiple processors, that would be a significant advantage. Ideal skills and experience: - Proven background in E-commerce website development - Knowledge of various payment processors - Understanding of safe and secure payment gateways - Ability to integrate new pa...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup&...
...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel autom...
We have Andorid TV app built in OS 9 chipmunkband seem to have problem working in Andorid boxes 10 and 11 but work on phone no problem and So we think we may need to upgrade gradle and some depencies Also we need package changed so the upgrade is done it will installed and not conflict with exsisting apps that are same Build .so os will see as a different app Attached are two soure codes similar
I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to include analytics to track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time ra...
I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization techniques
I'm looking for a creative logo designer who can help me convey my company's values and mission, product or service offerings, and target audience in a single, modern and persuasive logo. Key Requirements: - Design a logo that conveys Company values and mission, Product or service offerings, and Target audience. - Utilize the colors Blue, Red, Gold, Black, and White. - Complete the project ASAP. Ideal Skills and Experience: - Proven track record of creating innovative logos that effectively communicate a company's core values and resonate with their target audience. - Expertise in using color psychology to convey specific messages through a logo. - Ability to work under tight deadlines and deliver high-quality results in a timely manne...
I am looking for a skilled professional who can take the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately ...requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please let me know how many you think you can create and ...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitat...of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and me...
