Convert table to list excelงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm looking for someone associated with the University of Pittsburgh who is able to scan four pages from a book located at University of Pittsburgh's ULS. This task is for a research project. - No specific scanning device required, an iPhone scan or clear photo will suffice. - No need to convert the scans into any specific format, as they will be used just for reference purposes. The book is in Japanese, but I can guide you even if you only know English.
...for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio showcasing past product visualisation projects. Exceptional attention to detail...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and...
**Project Overview:** We are seeking an expert designer with strong experience in app design. The project involves updating existing designs to use the new responsive engine, building a couple of new pages, popups, and few features to enhance user engagement and conversion on our app. The current app is based on an old version of [Airdev's Canvas Framework]() (version: <3.0) **Scope of Work:** - Convert old AirDev Canva based app pages and reusable elements to new responsive engine - Design and build popups for sharing and rating content - Design and build a public page optimized for conversion - Update and refresh the homepage/landing page - Create a faceted search page Optional scope - Custom plugin development (very basic plugin / wrapper for
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 ...
I'm looking for an experienced CAD designer to help convert my 2D PDF into a fully interactive 3D plan using AutoCAD. The reproduction should have a medium level of details to capture the critical components of the plan but don't necessarily have to be high detailed with textures. Ideal Skills: - Proficiency in AutoCAD - Experience in converting 2D blueprints to 3D models - Ability to make the 3D Model interactive Experience in creating interactive 3D models is crucial for the successful completion of this task, as the final output will need to respond interactively to the user's prompts. Expertise in AutoCAD software will also be important to accurately and efficiently convert our 2D PDF into 3D.
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
...need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
Project Title: Conversion of FBX File to GLTF Format Project Description: We are looking for a skilled freelancer to convert a detailed 3D model from FBX file format to GLTF format. The model is currently optimized for use in 3D rendering software, but needs to be converted to GLTF for compatibility with web-based applications. Responsibilities: - Convert a high-quality FBX file into GLTF format while retaining all textures, materials, and animations. - Ensure the converted file is optimized for web use, with careful attention to minimizing file size without compromising the visual quality. - Provide technical advice on maintaining the integrity of the 3D model during the conversion process. Requirements: - Proven experience in 3D...
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
Job Overview: We are seeking a detail-oriented and experienced researcher to compile a comprehensive directory of leading doctors specializing in autism recovery for children across London, India, and the US, this list must be backed up with evidence of the doctors pedigree and why they are bated as one of the best. As well as a separate list of therapists based in London maximum of 25 in each discipline both lists is to be contacted to try and arrange an appointment so email and tel number needed . This project requires exceptional research skills and a strong medical or healthcare background. Project Scope: The researcher will create two distinct lists: one featuring top doctors specializing in autism recovery for children in three major global regions,...
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and h...
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external...Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation material (PP...
I'm looking to transform my logo into a modern and sleek 3D 4K animation that can be used across various platforms. Key Requirements: - You will be required to convert my existing logo into a 3D format. - The animation should be in 4K resolution. - The style should be modern and sleek. Deliverables: - The final animation should be provided with all source files. - The animation should be suitable for use as an email signature, on social media, and on our company website. Ideal Freelancer: - Proficient in 3D animation and graphic design. - Experience in creating logo animations. - Ability to deliver a modern, sleek design. - Previous experience with 4K resolution animations is highly desired. Looking forward to seeing your proposals!
Hello, I am looking for someone with some knowledge about LeiaPix. The idea is to convert 2D image in video. I run a technology company for the real estate sector, creating and selling digital solutions for real estate professionals. I'm currently working on a project to create a platform that would enable estate agents to transform their photos into video using AI. Have a look on attach file. So I'm looking for people who know how to use LeiaPix and who can create quality effects to transform photos into video. My clients generally have between 8 and 15 photos per property.
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression...Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation material (PP...
...need of a skilled content writer to craft a compelling, highly technical brochure aimed at businesses. Key Requirements: - Target Audience: I'm targeting businesses specifically, so it's important that the content is tailored to their interests, needs, and challenges. - Objective: The primary goal of this brochure is to convert business owners and professionals into leads. The content should be persuasive, engaging, and most importantly, capable of encouraging action. - Technical Level: The content needs to be highly technical, incorporating industry-specific jargon that would resonate with professionals in the business sector. Ideal Skills and Experience: - Proven track record in writing lead-generating content, particularly for businesses...
I am seeking an experienced professional in both outbound and inbound cold calling, with specific focus on promoting a product or service. - The primary aim is to enhance our corporate outreach and drive product interest amongst a business-oriented audience. - Ideal skills would encompass convincing communication techniques, persuasive sales tactics, and the ability to professionally handle objections. - The candidate must demonstrate prior experience in B2B sales and a strong understanding of business needs. This requires a keen, results-oriented individual who can effectively convert calls into business opportunities.
I'm looking for a skilled developer who can take my SVG/FIGMA design and convert it into a responsive landing page using Bootstrap. Requirements: - Convert provided SVG/FIGMA design to a responsive landing page - Implement the landing page using Bootstrap - Apply a color scheme Skills and Experience: - Proficient in HTML, CSS, and JS - Experience working with SVG images and/or FIGMA designs - Strong understanding and experience with Bootstrap - Prior experience with responsive web design Please note, the landing page doesn't need any specific sections like "About Us" or "Contact Form" - just the landing page itself.
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab upda...
Dear Freelancer, I have a little task for a video editing professional that is done very fast. Right now I have 37 short clips that need to be converted from 16:9 format to YouTube shorts format (9:16, 1920x1080px) In these videos you can see interview clips of two people sitting at a table. There are a total of three camera perspectives: - Presenter - Interview guest - Both at one table This task is about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, i...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
...looking for a Shopify store creation expert who can help me set up my niche product store. I have a website and domain already, and I have a specific theme/design in mind that I would like to use. The ideal candidate for this job should have experience in Shopify store creation and should be able to customize the chosen theme to fit my brand. Some other skills that would be beneficial include: - Knowledge of Shopify apps and plugins that can enhance the store's functionality - Understanding of SEO best practices for e-commerce websites - Ability to create high-quality product pages that can attract and convert customers - Experience with payment gateway integration and order fulfillment processes. Overall, I am looking for someone who can help m...
Hi Ram . We have already worked with you. Now i have one more wish. I have PNG needed to convert in DWG . This PNG is word - sign "Bulldog" which i need to make sticker for my motorbike.
