Extract specific data excel macroงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm seeking a creative designer to craft a colorful and bold Instagram Story post to promote my newly released app. This is a small, quick project and I'm looking for a fast turnaround. Key Message: - The ...the core user benefit of managing bookings and purchases. Design Elements: - Incorporate eye-catching app screenshots. These should be presented in a visually engaging manner, highlighting the key features of the app. - Include a clear, compelling call-to-action button. This should encourage viewers to take action by downloading the app. Ideal Skills: - Proficiency in graphic design with a specific focus on social media content creation - Experience in designing for digital marketing and app promotion - Ability to work efficiently and produce high-quality work und...
I'm in need of a skilled individual to download a short video, lasting 20 seconds, and edit a specific phrase out. The phrase in question is "Microsoft Surface Ratt tillbehor gor halva jobbet". The successful freelancer for this task should have: - Proficiency in video editing software, like Adobe Premiere Pro, Final Cut Pro, or similar - Attention to detail to ensure the phrase is removed entirely and seamlessly - Quick turnaround time as the video duration is short - Experience with censoring specific words/phrases in videos The main purpose of editing is to remove the referred phrase without taking away from the content's coherence or quality. The ideal freelancer will have experience with similar tasks. Your bid should reflect the entirety
...an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the document ac...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
...have a PDF document that I need typed into a Word document. The main purpose of this is to facilitate content editing. The PDF is text-only and not complex in layout. When typing the content into the Word document, I need you to follow specific formatting guidelines that will be provided. This job is more about ensuring the text is editable and looks nice in a Word document than simply transferring text from one file format to another. Requirements: - Proficiency in both PDF and Word - Typing speed and accuracy - Attention to detail and ability to follow specific guidelines - An eye for design and layout for the custom formatting - Previous experience with similar projects is a plus. Please ensure you are comfortable with the editing purpose and the custom formatting r...
...the Ultimate Member plugin. I want to implement a feature that allows users to be sorted by their distance from a specified location using Google API. Here's a more detailed description of what I need: - **Location Search:** This feature should enable users to input a location, and the system should sort users based on their distance from this point. - **Radius and Distance:** I don't have a specific radius in mind - the system should simply sort by closest proximity regardless of distance. - **Presentation:** The sorted users should be displayed in a list view. This is the primary way users should be able to see their matches. The ideal freelancer for this job should have: - **Experience with Ultimate Member Plugin:** A mastery of this plugin is crucial to the suc...
I need an experienced logo designer with a knack for modern and minimalist styles. The logo you create will be aimed at perfectly representing my brand personality, setting itself apart from competitors, and luring customers. Key requirements are: - Incorporating brand-specific colors to enhance brand recall - Demonstrating creativity that translates into a modern and minimalist design Ideal freelancers will be proficient in popular graphic design software, with a portfolio that showcases their ability to create unique, minimalist logos. Knowledge and understanding of color theory will be an asset.
I need a comprehensive website created for my small handyman business which offers plumbing, electrical and carpentry services. Specific features the website needs to include are: - An online booking system that allows customers to schedule our services. - Detailed descriptions and visuals for each service we offer - plumbing, electrical, and carpentry. The ideal freelancer for this job would have experience building e-commerce websites, particularly with a booking feature. Proficiency in web design to accurately capture the essence of my services is also needed.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solutio...
I need a simple yet unique logo designed swiftly. I will provide a jpeg or ppt file as reference. The logo will need to be developed using Illustrator or other vector graphics software. It should be versatile enough to use across multiple platforms, ensuring it remains crisp and clear. Key Points: - Combination of text and icon in the design - Specific color preferences will be provided - Required in an hour or less Ideal Skills: - Proficiency in Illustrator or similar software - Ability to work swiftly without compromising quality
...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 experienced in workflow automation and Power Automate. Below is J...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The nu...
Hello, I am looking for a game designer and someone who can create a GDD to submit it to a specific platform to let us join their dev team to publish games on their platform We require a fully detailed GDD with at least 15 pages and you need to be able to incorporate images and video footage of the game you are writing the GDD about. If you understand all the above please type RED at the beginning of your proposal. Proposals without it will be ignored.
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks. Key Responsibilities: - Data Processing: You will be required to process data including but not limited to sorting, filtering, 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 ...
I am urgent...in need of a freelancer with skills in web scraping, data extraction and web crawling. Your task will be to gather specific information from an online directory of race events throughout the world. Key Responsibilities: - Set up a weekly automated web scraping process. - Extract and deliver the following data points: Event name, Event date, Event location, online registration page, contact form page, and contact information along with some other info that we can grab. Required Skills and Experience: - Proficiency in web scraping and data extraction. - Capable of setting up an automated weekly process. - Ability to perform the task ASAP. - Strong attention to detail to ensure accuracy of information. Please note that timeliness and dat...
I’m looking for a proficient web developer to design a platform that serves as a bridge between patients in need of specific medications and pharmacies offering those medications. Key Features: - Search Functionality: The platform should help users (both patients and pharmacies) to easily find what they're looking for. - User Registration/Login: It should facilitate the creation, authentication, and management of accounts for patients, pharmacies, administrators, and moderators. - Secure Payment Options: A reliable and secure payment system is a must. User Roles: 1. Patients 2. Pharmacies 3. Administrators 4. Moderators The registration process must be thorough and secure, it should collect the following information: - Full name and contact details for identification ...
I am looking for an Asterisk/SIP expert to help me configure a SIP trunk. Specific tasks include: - Configuring the SIP trunk on my Asterisk server - Assisting with troubleshooting any issues that arise during the setup process Requirements: - Expertise in Asterisk and SIP configuration - Experience with setting up SIP trunks - Familiarity with troubleshooting Asterisk setups Additional information: - I already have a SIP provider - Ongoing maintenance assistance will be required after the SIP trunk has been configured.
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.
In need of a highly skilled frontend React developer capable of...frontend React developer capable of: - Building user interfaces that are smooth and intuitive - Implementing responsive design to ensure excellent mobile experiences - Integrating with APIs to create seamless interaction with the backend The UI design should reflect a clean and minimalistic style, thus enhancing user interface and overall user experience. The candidate's familiarity with specific React libraries or tools wasn't specified, but general expertise in Redux, React router, and Material-UI will be beneficial. An eye for aesthetics, along with an understanding of user-centric design and how to implement it into a streamlined, functional website is paramount to this role. Want to create 4 UX sc...
I'm searching for a Shopify expert who can seamlessly import reviews into my Shopify store from another Shopify store via a specific plugin. Subtle Points: - You should have prior experience in not only importing reviews but doing so specifically through the plugin. - Please be knowledgeable about the different formats reviews could be stored in, although in this case, it's specifically via a plugin. Skills and Experience: - Extensive experience with Shopify, particularly in importing/exporting data - Proficient with plugins and their utilization for data transfer - Specific prior experience with the concerned plugin - Excellent problem-solving skills for any unexpected issues during import - Diligent attention to detail to ensure all reviews are i...
...looking for: Skills & Experience - Solid knowledge and experience with reinforcement learning algorithms and federated learning frameworks. This is a non-negotiable. Objective - The primary aim of this project hasn't been decided yet. But your suggestions and professional advice will be very much appreciated, and potentially, highly impactful to the project's direction. Target Platform - No specific platform has been decided for deploying this project yet. However, your insights will be valuable in making this determination. Feel free to bid if you have the necessary skills and experience. Let's create something remarkable together....
...functionality within our iOS mobile application. Currently, users are experiencing difficulties logging in via Facebook authentication. The project involves diagnosing the root cause of the problem and implementing necessary fixes to ensure seamless and reliable Facebook login experience for users. Key Tasks: Diagnosis of Existing Issues: Conduct thorough testing and analysis to identify the specific issues causing the Facebook login failure on the iOS app. Review Facebook SDK Integration: Evaluate the integration of Facebook SDK within the iOS app to ensure compliance with the latest SDK version and best practices. Address Authentication Errors: Implement necessary changes to resolve authentication errors encountered during the Facebook login process. Error Handling and Loggin...
...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 accuracy and ...
...the United Arab Emirates. Introducing GCC Tax Laws GPT GCC Tax Laws GPT leverages the power of Generative Pre-trained Transformers (GPT) technology to create an intelligent and user-friendly solution for GCC Tax Laws compliance. Here's how it will work: • Automated Data Analysis: GCC Tax Laws GPT will be trained on vast amounts of GCC Tax Laws data, enabling it to analyze invoices, receipts, and other financial documents accurately. • Personalized GCC Tax Laws Guidance: GCC Tax Laws GPT will analyze your company's specific GCC Tax Laws profile and generate customized reports and recommendations for optimized GCC Tax Laws compliance. • Reduced Errors: GCC Tax Laws GPT's ability to analyze complex GCC Tax Laws rules will significantly ...
I need a PowerShell script that can both uninstall a specific application (Application A) and install a new one from our internal company server. This new application is not currently present on the Windows PC. Key Requirements: - The script must first check if Application A is installed on the Windows PC. If it is, it should proceed with uninstalling it. - The new application should be downloaded from our internal company server. - The script should ensure that there are no existing versions of the new application installed. Ideal Skills and Experience: - Proficiency in PowerShell scripting. - Experience in software uninstallation and installation. - Familiarity with downloading files over a network. The script should be efficient, reliable, and well-documented. Please provide a...
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 tr...
