Excel vba macro programmingงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
...build a visa appointment bot for personal use. Key Requirements: - This is a personal project, not for a business, and the primary goal is to automate the task of securing a visa appointment. The Bot: - The bot should be able to navigate a visa appointment booking system, select the appropriate options, and secure an appointment on my behalf. Skills and Experience: - Proficiency in bot programming and automation is crucial. - Experience with task automation and appointment booking is a plus. - Understanding of web scraping and navigation is a requirement. - Attention to detail is important to ensure the bot selects the correct options during the appointment booking process. Please get in touch if you have prior experience with building similar bots or automations, part...
As a gift basket business owner, I'm seeking an experienced Woo-commerce developer who can resolve a shipping issue on my website. The problem lies with the incorrect calculation of delivery...problem lies with the incorrect calculation of delivery fees if the customer's billing and shipping address differ. - The Requirement: I need the system to accurately use both the billing and shipping addresses when determining the delivery fee. The rates must differ based on the zip codes entered. - Essential Skills: Deep understanding of Woo-Commerce, PHP, Javascript, and any other relevant programming language. Prior experience in handling shipping/delivery rates customization is a plus. In your proposal, please discuss your previous similar projects and your chosen approach ...
...looking for a highly proficient and experienced AI-expert for programming and coordination tasks in this project. Given your experience in the AI world, this role will be a perfect fit if you have: - A bachelor's degree or equivalent experience in a field relevant to this job - Previous experience in similar roles, with emphasis on AI programming languages - Strong analytical skills and propensity for problem-solving Key Responsibilities: - Communication and Coordination: You will need to work closely with the team, maintaining strong team dynamics and effective communication - AI Programming: Mastery and proficiency in AI programming languages are crucial for this role Ideal Skills and Experience: - Proficiency in AI programming languages -...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
I urgently need a C++ developer to assist in expanding my project. Your task will be to implement a unique feature which requires capturing low-level screenshots directly from the GPU. The key responsibilities include: - Developing a new, specialized feature that c...implement a unique feature which requires capturing low-level screenshots directly from the GPU. The key responsibilities include: - Developing a new, specialized feature that captures and handles GPU screenshots. - Ensuring the smooth and efficient performance of this new feature. It's beneficial if you have prior experience with similar GPU-related tasks and a solid understanding of C++ programming, API integrations, and screenshot capture techniques. Please bid now if you believe you have the skills and can d...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
...WILL BE CONSIDERED? I need a knowledgeable Stratum v2 expert for assistance with the following tasks: - Mining Pool Configuration: Proper setup and configuration of the mining pool. - Mining Software Integration: Seamless integration of mining software into the current setup. - Protocol Optimization: Optimization of the Stratum v2 protocol to ensure peak mining performance. The specific programming languages used for the current implementation are unknown as the previous question was skipped. In terms of hardware, my setup currently includes Windows and GPU. Thus, the successful freelancer should have experience working with these specifications and will consider this in the implementation process. The ideal freelancer should have an extensive background in Stratum v2 prot...
I'm looking for a functional implementation utilizing AWS media convert in a .NET core environment, with a specific focus on video transcoding. - Functionalities: The main functionality to be implemented is video transcoding with the target being MP4 format. - Desi...convert in a .NET core environment, with a specific focus on video transcoding. - Functionalities: The main functionality to be implemented is video transcoding with the target being MP4 format. - Desired Output: The desired output resolution for the transcoded videos should be 1080p. Ideal Skills and Experience: - Significant experience with AWS Media Convert - Proficient in .NET core programming - Experience with video transcoding technologies - Understanding of video formats, particularly MP4, and resol...
I'm looking for a developer with in-depth experience in creating smart contracts on the Ethereum bloc...contract should allow for the distribution of ERC20 tokens to multiple recipients in a single transaction. - Implement pause functionality as a security feature. This is crucial to protect the contract from any potential vulnerabilities or attacks. - We would like to be able to interact with the contract if possible (on etherscan) Ideal skills and experience: - Proficiency in Solidity, the programming language used for Ethereum smart contracts. - Prior experience in developing multisend contracts and incorporating pause functionality. - Knowledge of best practices for smart contract security. - Ability to deliver a secure and efficient smart contract that meets the specifie...
I need a Python expert with an ability to cover various functionalities as per the need. The project might involve data analysis, web scraping, automation, or could be anything else as per the project requirements. The ideal candidate should have: - Expertise in Python programming and its different libraries. - Experience with data analysis, web scraping, automation. - Strong problem-solving skills. While applying, please share: - Your past work related to Python programming. - Your Python programming experience level. - Detailed proposal of how you can assist in this project.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send the smaller ...
I need an expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Da...
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
I'm seeking a skilled microcontroller programmer for translating our control strategy into a code compatible with a dsPIC microcontroller. This code should be able to handle inputs of both voltage a...is paramount. 3. Beyond written code, you should provide thoughtful documentation and comments so we can understand your strategies and algorithms. I am not specific about setpoints for voltage and current, so the approach should be adaptable. Ideal freelancers should possess the following skills and experience: - Strong understanding of PI control strategies - Fluency in microcontroller programming - Ability to translate MATLAB code into different languages - Problem-solving mindset to adapt to shifting parameters In your bid, please share relevant experience relating to thes...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
I am seeking an experienced developer to create a website scraper which is capable of collectin...data. This savvy tool must be designed to extract from () site: - Text content - Images - Product information - Address - Contact details - Videos It is essential for the scraper to perform its task on a daily basis. Yet, there won't be a need for the gathered data to be automatically integrated into a database. Ideal Skills: - Web scraping - Developing scraping bots - Programming knowledge - Manual data mining expertise Please only apply for this job if you have significant experience in creating web scrapers. This project requires a quick turnaround, so the ability to work under time constraints is key. Let's converse about specifications, and develop the solution I nee...
Hello, so this is will be for the new project.
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
As we're in the development stage of building a decentralized application, I'm looking for a skil...looking for a skilled Solana developer to join the project. The main focus of the project is on building a decentralized application. Therefore, the ideal candidate should have experience with smart contract development and blockchain integration. Skills and experience required: - Proven experience in smart contract development and blockchain integration - Strong knowledge of Solana and Rust programming - Experience in deploying decentralized applications The ideal developer will be able to work closely with our team to bring our decentralized application project into reality. The project is already in its development phase, so we are searching for an expert who can hit...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
Hello, I'm looking for someone who could continue programming my iOS app and possibly fix any errors. This is actually a relatively simple app that shouldn't be very difficult to program. You don't have to do that much because the app is actually relatively simple. Key Responsibilities: - Addressing UI/UX, performance, and functional issues that may arise. - Implementing new features based on provided specifications. Ideal Freelancer: - Proven track record of iOS app development. - Proficiency in Swift and Xcode. - Experience with bug tracking tools. - Ability to translate user feedback into actionable development tasks.
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
