Vba code to extract data from sap to 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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
I'm looking for an ...experienced Wikipedia editor to create a page for my company. We already have a website so the information will be derived from there. The page should be a basic summary of the company, highlighting our key offerings and what distinguishes us in our industry. It should be well-researched and comply with all Wikipedia guidelines. The ideal candidate will have: - Proven experience in creating Wikipedia pages for companies - Strong research skills to extract relevant information from our website - Excellent writing skills to summarize the information in a concise and engaging manner - Comprehensive understanding of Wikipedia guidelines and policies If you have experience with similar projects, please provide examples ...
Would like you to begin immediately. This should be a quick project for someone with the correct skills. I need assistance in copying product data from the manufacturer's site to ours. This is only for approximately 25 products. Key responsibilities include: - Transferring product descriptions - Moving over technical specifications The ideal candidate will have: - Proficiency in data entry - Understanding of eCommerce platforms, so that the formatting is correct on our site. - **** Formatting must match the formatting on the manufacturer's site and be responsive on our responsive site. If you don't know how to do this, please don't make a proposal. **** Here is an example product: The description should be placed
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.
...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 with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the 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 accura...
Proposal for GCC Tax Laws GPT Development Introduction We aim to revolutionize how businesses handle compliance with GCC tax laws—introducing GCC TAX LAWS GPT, a groundbreaking AI-powered tool designed to streamline GCC Tax Laws processes and save you time and money. We are looking for an eligible and experienced programmer to develop and implement the AI and GPT platforms. The developer must understand AI requirements and develop AI functionalities in GCC tax laws. The Challenge GCC Tax Laws and regulations can be complex and ever-changing. Manually navigating these complexities can be time-consuming, prone to errors, and lead to costly penalties. The term GCC stands for Gulf Country Council, which brings six Gulf nations together, i.e., Bahrain, ...
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...
I have a C# project that I need translate to Delphi. The code is not too extensive but use SQLite. I will send the project source code if you send me a good proposal with you experience in c# and delphi. Please not send automatic proposals. thanks you!
I have a C# project that I need translate to Golang. The code is not too extensive but use SQLite. I will send the project source code if you send me a good proposal with you experience in c# and Golang. Please not send automatic proposals. thanks you!
...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 the
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 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 thi...
I'm currently struggling with a logic error related to file location mismatch in my Google Colab notebook. I'm attempting to train a neural network model, however, this recurring issue is hindering progress. To solve this problem, I am seeking an individual with the following skills and experience: - Proficiency in debugging and solving logic errors, specifically those related to file location mismatches - Thorough understanding and practical experience with neural network models - Familiarity with Google Colab Notebooks and how they manage files and directories - Proven ability to quickly identify and resolve issues affecting model training My aim is to have this issue corrected promptly so I can continue with my model training.
Ferrari badge CAD model needed. *note this model is not available on the free CAD sites, the size of the badge is different* Pictures of the part and measurements provided highly important the part is to scale - must be to scale trace from pictures? solidworks 2017 model required there is pins in the back of the original badge, drawing with measurements show the key features of this. scope is a CAD Model complete that can be 3D printed to replace the original.
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.
I am in need of a SharePoint expert who will be on hand for 4 hours daily to assist with various tasks relating to my SharePoint site. The selected individual will be primarily tasked with: - Document management: The organization, updating, and safeguarding of crucial documents. - Workflow automation: Streamlining business processes to improve effectiveness. - SharePoint site customization: Tailoring the site to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoint, organized, detail-oriented, and...
...proficient ABAP developer with extensive experience in resolving issues related to the ADR6 table in SAP. The primary issue I am encountering is an ASSERT dump when attempting to update the table. Your task will be to resolve this and improve the overall functionality of the table. Key Responsibilities: - Identify the root cause of the ASSERT dump when updating the ADR6 table. - Resolve the issue to ensure successful and error-free updates. - Optimize the ADR6 table to improve system performance and ensure accurate communication mail ids. Ideal Candidate: - Proven experience working with the SAP ADR6 table. - Strong understanding of ABAP programming language. - Ability to troubleshoot and resolve complex technical issues in SA...
I require a proficient graphic designer to remove a medium complexity object, in this case a balloon animal from a photo. Key Details: - The task requires careful attention to detail in order to maintain the integrity and quality of the image post-edit. - Prior experience in object removal and photo editing is a must. - Expertise in graphic design software like Adobe Photoshop is expected. The ideal freelancer for this job would have prior experience and a portfolio that includes similar photo editing projects. This task requires advanced skills in photo manipulation and editing.
...specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet 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...
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.
We're looking to automate our timesheet comparison process. Our current timesheet data is in two online platforms and the automation workflow needs to run on a weekly basis and compare the 2 timesheets. Key Tasks and Requirements: - Create a data entry automation flow that will extract data from our current online platforms. - The data has to be extracted for 2 pay periods from platforms - 1st to 15th and 16th to End of Month for every month. - compare the 2 data sets by employee and date. if there is a mismatch, it needs to be flagged. - send email to the employee and reporting manager about the mismatch. - send highlevel email to operations head about all mismatches ...
I'm looking for a freelancer to assist with a data entry project. The task involves inputting text data from scanned documents into a database. Key Requirements: - Proficiency in data entry, particularly handling text data - Experience working with scanned documents is preferred - Attention to detail to ensure accurate input - Ability to efficiently and accurately create a database The primary goal of this project is to have a comprehensive database created from the scanned documents. I would greatly appreciate a freelancer who can handle this task with precision and efficiency.
I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key advantage.
...requirements and conditions and once I start the trial, people are failing to perform. Also, too many bids from countries I do not desire; Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to detai...
...are seeking a professional software application firm experienced in providing cloud-based payroll solutions for international organizations. The aim is to streamline our farming organization's payroll processes, saving time and resources for HR and Finance teams. Functional Requirements: Streamlined payroll processing with features like automated calculations, deduction management, and generation of various reports. Integration with existing software like SuccessFactors - SAP and compatibility with internet banking for seamless transactions. Remote accessibility, robust security features, and compliance with data protection laws. Ability to generate pay slips, tax forms, and support self-service access for employees. Technical Requirements: Cloud-base...
