Excel 2003 vba codingงาน
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
Develop website and coding every kind of project สร้างเว็บไซต์ เขียนโปรแกรมทุกรูปแบบ
...text data sourcing from various online resources. The ideal candidate should have: - Proficient skills in data entry. - Extensive experience in sourcing data from online platforms. - High-level experience with Microsoft Excel spreadsheets. This role will involve extensively scouring a range of online resources to gather text data and enter this information precisely into Excel Spreadsheets. Precision is critical, and a methodical approach to ensure the highest level of accuracy is a must. The final data needs to be well-organized and formatted in a user-friendly manner on Excel Spreadsheets. Candidates must showcase their past data entry works involving online resources for validation. Familiarity with different types of data and online research skills will be ...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...
...the data based on the AI and GPT’s Platform Response. • We will pay the cost of Azure Cloud Infra/Azure APIs/Connectors/3rd Party AI Model/AI Tools required for Hosting, Processing, and Training of Models, etc. Part B: Development of Generative AI capabilities for Users enabling prompt (Single Document: PDF, Word, Excel, Image). • Development and Implementation of Generative AI Capabilities for Users, enabling them to perform text prompts on single documents PDF, Word, Excel, Image and enabling users AI Questions, Extract Summary, and perform AI Instant Capabilities such as Quickly retrieve relevant data, Calculations and Financial Analysis, Guidance on Standards, and regulations, Financial Modelling and Forecasting, Compliance and Auditing Support, Ta...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and ind...
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I'm in need of a coding solution that can help me keep my email list up to date on an ongoing basis for my membership. I currently use Circle and FloDesk. The issue lies in the fact that Zapier, which I currently use for automation, cannot maintain tags when members unsubscribe. Key Job Requirements: - Integration: The coding solution should be able to synchronize and interact with my Circle and FloDesk accounts in real-time. - Real-Time Updating: The email list needs to be updated continuously as members subscribe and unsubscribe. - Unsubscribed Members: The specific action that should trigger an update is when a member unsubscribes. This action should be reflected in the email list promptly. Appropriate Skills: - Proficient in coding and experienced in work...
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered cor...
I'm looking for a talented web developer who could build an escort website for me, similar to www.elsilencio.cl. It needs to be in Spanish. The key features should include: 1. User-friendly Interface - This is very critical as we require smooth navigatio...key features should include: 1. User-friendly Interface - This is very critical as we require smooth navigation for our users. 2. Photos, Descriptions, Services Offered, Videos, and Stories - These should be clearly available about the escorts on their profile page. 3. Visitor Interaction - The visitor should have the ability to fully connect with our escorts. Ideal skills include: 1. Strong coding skills 2. Experience in web design 3. SEO knowledge 4. Familiarity with escort website design is a plus. Looking forward to ...
I'm seeking an expert in Ninjatrader 7 (NT7) coding to bring new functionalities to my platform. The core requirements of my project are: - Incorporating Custom Indicators into NT7: I need you to hard code specific elements into the system for customized utilization on the chart trader. - Advanced Charting Features: I would require the integration of advanced charting features in NT7. Chart trader modifications. As a freelancer, you should ideally have: - Proven experience in coding for Ninjatrader 7. - Knowledge of financial markets, trading systems, and indicators. - High-level skills in coding and data visualization. Join me in upgrading the potential of my NT7 trading platform. Counting on your expertise to make trading more insightful and efficient.
I'm looking for a skilled professional to help with the maintenance of my websites built with core PHP and MySQL. Key Tasks: - Website changes: Regular content updates and design changes are anticipated, so the candidate should have flexibility and be comfortable with changes. - Feature Additions: I'm looking to extend the functionality of the websites, so the candidate should be able to i...coders only - Must be able to work on USA hours and be able to respond within a couple hours , during 8am - 1pm every day. - Must be Fluent in English, able to communicate well To guarantee a response from me, please answer the following 4 questions: Please let me know what is your strongest skill, what you have worked on recently, what time zone you are in, and what is your favorite part ...
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required Strong emotional intelligence (EQ) and interpersonal skills required Experience with workflow design required Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel: Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements: This role frequently communicates with others, must be able to exchange accurate information in these situations This role routinely uses standard office equipment such as computers, p...
I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
I need a professional who is highly proficient in both Weebly and Square website design and implementation. Apply with "I can get started right now and available for Weebly webasite development! and can deliver in 24 hours" I'm looking to create a new site in the platform. If you're experienced in website design, e-commerce setup and custom coding in Weebly+Square, I'd like to discuss your skills further. Initially, we would like to create the home page following the standards of Weebly with mobile responsiveness. So make sure to apply with your past Weebly websites and budget for home page only. Also you must be ready to answer all of our questions and knowledge base transfer in an organized way. Happy Bidding!
...email marketing and CRO * Ability to work independently and thrive in a fast-paced, dynamic team environment * Excellent communication and collaboration skills to work cross-functionally * Sharp attention to detail and ability to spot optimization opportunities * Fluent English is required for this role * Set up and configure marketing automation platforms, including designing standardized coding templates, creating of flows * Work with engineering team on event labeling and providing necessary data for platforms * Develop and maintain a system to track and segment customers for targeted marketing campaigns * Utilize data insights to inform campaign strategies and optimize customer journeys * Develop and execute marketing automation campaigns, including lead nurturing an...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
Project Overview: Your mission involves the crafting of cutting-edge Bricks Builder modules, driven by design specifications from Figma. This project is not just about coding; it's about creating art that works, bringing new value into the digital space, and helping companies succeed in their ventures. Your Tasks: Create Bricks Builder Modules Using Bricks Widget Creator: Start with the provided Figma designs to develop custom modules. Your creativity in this phase will set the foundation for the unique digital experiences we aim to deliver. Develop a Static yet CSS-Responsive Bricks Page Template Using REM: Ensure the template you create is fully responsive, adapting gracefully to any screen size. Employing REM units and 62.5 Mechanism for styling will ensure scalability an...
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
...system, leveraging Raspberry Pi 5, 2D Lidar and Arduino Uno/MKR 1010 WiFi as part of my college project. Key responsibilities will be to aid in motor control and visualizing real-time Lidar data. Specific requirements include: 1. Implement FastSLAM algorithm – You will need to have a thorough understanding and experience in implementing this particular SLAM algorithm. 2. Utilizing Python – All coding tasks should be performed using Python. 3. Deliver Real-time Lidar Data Visualization with: - Map Display: A real-time map should be drafted using the Lidar-scanned data. - Moving Trajectory: Display the accurate position and movement trajectory of the SLAM system. Having a background in working with Raspberry Pi and Arduino, while specializing in FastSLAM an...
...to implement proper caching, image optimization, script optimization, reduce unnecessary plugins etc. I don't want you to use plugins but need manual work. Also We had some issue with polylang multidomain and fonts did't load in secondary domain. And getting stange 404 errors from time to time until we reset permalinks, I guess because of premmerce. I need serious WordPress developer who have coding knowledge of HTML, CSS, JS and PHP and databases and server or overall WordPress stack. Note: This job is not for someone who just install plugin and says deal....
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed b...
