Ask an excel vba expertงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
I'm looking for a writer to research and write a "How-to" eBook for more than 7,000 words and my budget is $70 USD for 7,000 words. . Paymaent conditions: Full payment upon completion (No upfront fees) Deadline: 14 days upon project acceptance. Upon project completion, you agree to me having the full rights to the eBook and its content. . To apply, please send me your past work samples so I can better evaluate your writing style . --- ผมกำลังมองหานักเขียนที่จะมาศีกษาหาข้อมูลและเขียน eBook แนว "วิธีการ" ความยาวกว่า 7,000 คำ ผมมีงบ $70 สำหรับการเขียน 7,000 คำ . เงื่อนไขการจ่ายเงิน : จ่ายเต็มจำนวน เมื่องานเสร็จ (ไม่จ่ายล่วงหน้า) กำหนดส่งงาน : 14 วัน หลังจากตอบรับงาน เมื่องานเสร็จสิ้น คุณตกลงที่จะให้ผม/ฉันมีสิทธิ์ใน eBook และเนื้อหาดังกล่าวทั้งหมด . ในก...
สวัสดีคุณ Facebook Marketing Expert ฉันสนใจประวัติของคุณและต้องการเสนอโปรเจคให้คุณ เราสามารถหารือเกี่ยวกับรายละเอียดต่างๆ ผ่านการสนทนาได้
วาดภาพจำลองโคมไฟของบริษัท ตามแบบ 2d ที่เป็น outline พร้อมรายละเอียดสัดส่วน และขนาดให้พร้อม อยากให้เห็น texture และรายละเอียดของงานให้ได้เหมือนของจริงมากที่สุด เช่น เหล็ก นอต พลาสติด สายไฟ อลูมิเนียม เเสงไฟ เงา อาจจะต้องมีหลายมุม ทั้งแขวน ตั้ง วาง จำนวนงาน : 7 แบบ (แต่ละแบบมีอย่างน้อย 3 มุม) รวม 21 รูป
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Hi there, We are looking for a Thai (!) graphic designer to support our Design department. We are currently working on a few exciting projects and need your creative help. You will need to create three options for a homepage layout + 3 additional designs once we chose one of the homepage options. You will need to allow us at least three (3) review rounds, where we will ask you to adjust the options based on our feedback. We will provide you with a company profile, a list of items that have to appear on the homepage, as well as a list of websites we like. If this sounds interesting, please contact us asap. Thank you!! P.s.: No agencies, and no copy and past cover letters please. ต้องการหา Graphic Designer ออกแบบ Layout เว็บไซต์ โดยมีรายละเอียดงานดังนี้ 1. ออกแบบ Layou...
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am looking for a skilled developer to create a trading system using Metastock. Key Requirements: - Develop a trading system on the desktop platform that supports Metastock. - The system should be efficient, reliable, and user-friendly. - Prioritizing smooth functionality and minimal latency in executing trades. Ideal Skills: - Strong understanding of Metastock and its capabilities. - Proficiency in developing desktop trading systems. - Experience in creating user-friendly interfaces. - A good grasp of the stock market and trading principles. - Effective communication skills and a proactive work approach.
I'm looking for a proficient Excel expert who can help me with importing data from an existing Excel file into a mark sheet template. Key Tasks: - Import data from an existing Excel file into a new mark sheet - Perform data cleaning post-import The ideal candidate should have: - Proficiency in Excel, specifically in importing data - Experience in data cleaning and manipulation - Attention to detail to ensure data accuracy Feel free to reach out if you have any questions. I look forward to your bids.
Hi Expert Web Infotech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Part time Bookkeeper needed for work in Orange County CA. You can work from home but may be needed for face to face meetings. Job duties to include reconciling bank statements, extensive use of excel spread sheets for tracking data, business and task management. Candidate should be able to use property management software to enter data, pay bills, generate reports.
I'm in need of a seasoned Te...market. We are close to the border of netherland, belgium and luxembourg. All these countries are very small and the people could speak really well english. I have all adresses of the shops in these countries. Also I have a english pricelist and we could teach your everyhing about e-scooters. You job is to contact these dealers and do your best that they buy from us. I would pay a salary per hour and an additional €40 for each dealer you managed to attract. Please send me your application and it should include where you have already worked as a salesperson and for which projects. Please tell me why I should take you. Looking forward to hearing from all interested Telemarketing professionals. Thank you very much bye Luca
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A t...
I need a meticulous freelancer to help with my data entry task. The specific requirements are as follows: - The primary task is entering textual information from scanned documents into an Excel sheet. This includes typing out the text exactly as it appears on the scanned document. Applicants should have: - Proficiency in data entry, especially text-based information - A keen eye for detail and accuracy - Experience working with scanned documents - Proficiency with Excel This is a straightforward project, but attention to detail is crucial. I will provide the scanned documents, and I expect the data to be entered accurately and efficiently.
I am looking for an expert in building Copilot-Chatbot with specific features and integrations to our existing product Quickfms. The project is of utmost urgency and requires immediate attention. Key Requirements: - Natural Language Processing: The Copilot-Chatbot should be able to understand and interact with users in a natural, conversational manner. - Multi-lingual Support: The ability to communicate in multiple languages is crucial for our global user base. - Integration with Quickfms: Seamless integration with our existing product is essential for providing a cohesive user experience. Platform Specifications: The Copilot-Chatbot should be accessible on both our website and mobile app. Please note that due to the urgent nature of this project, the ideal candidate shoul...
I'm seeking a professi...professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free to ask any...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
I'm looking for a skilled video editor to enhance my vlog footage. The project involves a video that's over 10 minutes long and will require: - Improving the color grading to give it more vibrancy and streamline with my aesthetic preferences. - Creating better transitions, to ensure a smooth and seamless flow between the different scenes and segments. The ideal freelancer for this job should have a strong background in video editing, specifically in creating dynamic transitions and manipulating color grading. Experience with long form content is a plus. I need someone who can elevate my vlog's visual impact whilst maintaining my unique style and tone.
I need expert in UE5. Please bid only if you an expert in computer graphics especially in UE5 First person template.
Scope of work, SureCart (high level). SureCart, SureTrigger, and SureMembers are powerful tools for creating and managing subscription-based platforms. Here's a detailed scope of work based on your requirements: Platform Setup and Configuration: Install and configure SureCart, SureTrigger, and SureMembers plugins/extensions. DONE. Set up payment gateways for processing transactions (Stripe, PayPal). DONE. Configure user roles and permissions for different membership levels (Freemium, Plus, Pro, Premium). Customize email notifications for user registrations, subscriptions, and other relevant actions. Product and Subscription Setup: Define and create payable products for each membership tier (Freemium, Plus, Pro, Premium). Set up subscription plans with varying features and access le...
I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specific requirements.
I require a talented photo document editor capable of editing files by adding names and altering dates. The specifics of the project are as follows: - Add specific names at the top of the document - Change the dates within the document Ideal candidates will exhibit the following skills and experience: - Proficiency i...the document Ideal candidates will exhibit the following skills and experience: - Proficiency in photo editing software, such as Adobe Photoshop - Attention to detail for precise text placement - Strong knowledge of fonts, alignment and character spacing - Adept at maintaining the authenticity of documents while making changes - Previous experience with similar editing projects Feel free to ask if you have any queries related to the project. Looking forward to ...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in co...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
In need of a copy specialist with marketing experience who can refine copy for a LinkedIn/Facebook Post, for a beta product launch. I'm trying to attract trial users, and the communications should be both inspiring ...trying to attract trial users, and the communications should be both inspiring and motivational. Essential Responsibilities: - Modify existing copy/create new copy with the goal to better position the product for beta launch to individual consumers - Make any necessary tweaks to website copy on home page, depending on user journey stage (before sign up, after sign up) Ideal Candidate: - a copy expert with experience in marketing. - Previous experience launching products and engaging B2C segment required - Proven ability to craft copy that's both inspiratio...
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.
I'm seeking an experienced game developer with a deep understanding of Cocos2d, Unity to join our team to create an engaging Android game with some special features. Key Requirements: - Proficiency in Cocos2d game development - Experience with Android game development - Ability to implement multiplayer mode and level editor functionalities - Knowledge of IO Game - Experience of multiplayer IO Game
Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.
I have an Excel sheet that requires daily data analysis using statistical methods. Key requirements: - Daily updates: The data in the Excel sheet will need to be analyzed using statistical methods and techniques on a daily basis. - Statistical Analysis: The main focus of the analysis will be on statistical methods. You'll be required to utilize various statistical tools to interpret the data and provide insights.
