Excel macro dynamic fileงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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 ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
I'm in need...tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer Relationship Management software will be a huge advantage. I'm looking for someone who can be available on an on-call basis for this role, as tasks may come up sporadically. Your punctuality, attention to detail and excellent communication skill...
I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to detail - Good p...
...specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be required to manage key client accounts, upload new content on Amazon listings, work with design, sales and other Lezzat team members to complete client projects. Please add the word AMZ Lezzat at the beginning of your cover letter so we know you have read this. Core responsibilities • Uploadin...
I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.
I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.
We are seeking a dynamic and motivated individual to join our team as a Real Estate Sales Executive. The ideal candidate will have a minimum of 1-5 years of experience in real estate sales, excellent communication skills, and ability of generating leads, converting leads, and closing deals. Responsibilities: Generate leads through various channels such as networking, referrals, cold calling, and online platforms. Communicate effectively with clients to understand their needs and preferences. Conduct property tours and provide detailed information about properties to potential buyers. Negotiate and finalize sales contracts, ensuring favorable terms for both parties. Follow up with clients throughout the sales process to provide updates and address any concerns. Stay updated on ma...
I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.
I'm in need of an experienced video editor who can help me create visually engaging and dynamic content for my social media platforms. Specifically, I'm looking for someone who is well-versed in editing Instagram Reels and Youtube Shorts. Key requirements: - You should be able to edit videos to fit within the 1-3 minute timeframe. - The ability to add text overlays, transition effects, and color grading to enhance the overall visual impact of the content. Ideal skills and experience: - Proficiency in video editing software. - Strong understanding of social media trends and what makes content engaging. - Ability to work creatively within the constraints of short-form video content. If you have a knack for storytelling through short videos and can bring a fresh and modern...
...in one day. If you repeat the same process 20 days a month. You are expected to make $6,000 a month. If you work hard and are great at sales, your success rate will be a lot higher. Flexible Schedule: Set your own hours and work from a location that suits you. This role is perfect for self-motivated individuals who thrive in an independent environment. Fast-Paced & Rewarding: Be part of a dynamic team and experience the satisfaction of helping businesses establish a strong online presence. To be successful, you'll need: • Proven Sales Experience: A minimum of 1 years of successful sales experience, preferably in a B2B environment. • Communication Master: Excellent communication skills, both written and verbal, with the ability to build trust and rapport w...
I'm in need of a dynamic Android application that will enable users to virtually 'try on' clothing items using their device's camera. The app should be compatible with both Android smartphones and tablets, and its primary functionality should be a virtual fitting room. Key Features: - Device Compatibility: The app should be designed to work seamlessly with both Android smartphones and tablets, ensuring a broad range of users can enjoy the experience. - Virtual Fitting Room: The core element of this app is its ability to allow users to try on clothes virtually. This should be an engaging and realistic experience for the user, helping them to visualize how an item would look on them. - Real-Time Interaction: Users should be able to use their device's camera i...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
I'm in need of an experienced WordPress developer for customizing my WooCommerce plugin. I'm looking to add some specific features to it, which are as follows: - **Product Variations**: The plugin needs to support dropdown options, radio buttons, and color swatches for different products. - **Dynamic Pricing**: I require the implementation of quantity-based discounts, tiered pricing, and special pricing for specific user roles. This is crucial to cater to different customer segments and create a dynamic pricing structure that can help in boosting sales and customer retention. If you're proficient in WordPress development, particularly in customizing WooCommerce plugins, and have a solid understanding of e-commerce and pricing strategies, I'd love to hear...
I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.
I'm looking for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrate new function...
I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.
I seek a skilled Youtube video creator to bring life to a few images I have, through 2D animation. The main goal of this 1.5-2 minute video is to promote my meme website, targeting meme enthusiasts of all ages. Key Requirements: - Creating a 2D animated video: You will be expected to utilise 2D animation techniques to transform the still images I provide into a dynamic and engaging video. - Content and Background Music: I am open to your creativity when deciding the content and background music for the video. - Promotion Focus: The video you create should be primarily aimed at promoting my meme website. Ideal Freelancer: - Experience in 2D animation: Previous experience with 2D animation is highly preferred. - Creativity: A creative approach in determining the content and backgrou...
...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...
I need a dynamic, realistic 3D animation video to showcase my product. The video should be more than 3 minutes long, ensuring every detail of the product is well-demonstrated. Key Requirements: - Realistic 3D animation skills. - Experience in product demonstration videos. - Ability to incorporate key features and usage of the product in the animation. The video will not only display the product but also its functions, use, and impact. I expect the outcome to be engaging and explanatory to leave no doubt in the viewer's mind about how the product works. Ideal Skills: - Expertise in 3D animation. - Great attention to detail. - Clear understanding of product positioning and marketing. If you have a robust portfolio of realistic 3D animations, especially product demons...
Project Overview: This project involves the creation of a new, dynamic website for JStar Capital, designed to enhance online presence and brand identity. The website will be modeled after an existing site known for its engaging design and animations, serving as an inspiration for the overall aesthetic and functionality. Objective: The primary goal is to launch the website by this Sunday, with initial content being placeholder text that will be updated in the following weeks. The website must also incorporate new icons and logos aligned with JStar Capital's branding. Tasks: Phase: Task 1.1: Conduct a detailed analysis of the benchmark website to identify key design elements and animations. Task 1.2: Create a design mockup that incorporates JStar Capital’s branding guid...
I am looking for a highly skilled professional who has a strong command over Premiere Pro for a commercial-style video editing project. Fixed budget 100rs per video Key deliverables include: - Creating a commercial-style video in 4K Ultra HD - Incorporating dynamic video-editing techniques to engage the audience - Ensuring all edits and transitions are clean, and align with the overall theme Ideal Skills & Experience: - Expertise in Adobe Premiere Pro - Proven experience in commercial-style video editing - Proficiency working with 4K Ultra HD quality videos - Keen eye for details Looking forward to your creative bids!
? Calling All Visionary Video Editors! My name is Linus, founder of an innovative advertising agency based in Norway. We’re on a mission to transform advertising through compelling video content that not only engages but inspires. As we prepare for ambitious expansions, including breaking into the dynamic Chinese market, we are searching for the best video editing talent out there. Why Join Us? • Innovate: Work on groundbreaking projects that redefine advertising standards. • Expand: Be part of our exciting expansion into new markets, starting with China. • Collaborate: Join a diverse team of creatives from Norway and beyond, all driven to create stunning visual stories. We are looking for professionals who are passionate about video editing and eager to ...
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
