Advanced excel macros vbaงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
For my online store specializing in custom trailers, I need a web designer experienced in building advanced e-commerce functionality. Key Deliverables: - An e-commerce platform to showcase my custom trailers - Advanced product customization options to enhance user experience Ideal Skills: - E-commerce website design expertise. - Experience in advanced product customization systems. - Familiarity with the automotive or trailer industry is a plus.
Deseo un sistema de ventas que me permita crear una base de datos para mis clientes , registrar inventario de bidones , registrar los pagos en efectivo Transferencia y los que deben , registrar compras , Cuento con un cuaderno con informacion de los meses de enero febrero y marzo quisiera ingresar esa informacion . Adjunto un formato de excel donde llevo prácticamente ingresando datos manuales , necesito llevar control de los ingresos y egresos
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I'm in need of an Excel Calculation Expert. I have data spreadsheets that need to do the calculations using Excel Your primary task will be to: - I've dataset (excel file), that needs to do the calculation using excel - Once it done then you need to write report as per following requirement Deadline: 10 hours or less
I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours
I am seeking a talented pop vocalist with a knack for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal a...for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal abilities - Previous songwriting experience or ability to translate poetry into musical form. This is a fantastic opportunity for those who excel in conjuring up catchy pop melodies and are skilled at breathing new life into writ...
I need a skilled WordPress developer to list custom posts by closest distance to the current users address, w...up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent project so I would require the task to be completed in a timely manner. If you have the skills and availability to get this done, please get in touch.
I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.
I am in need of an expert Instructor in Python for advanced machine learning. You should have a strong background in neural networks, natural language processing, and reinforcement learning. The ideal candidate should: - Be proficient in Python - Have deep understanding and experience with neural networks, natural language processing, and reinforcement learning - Be able to teach advanced machine learning concepts - Have prior experience as an instructor in an online setting Your role would include: - Preparing course material - Delivering lectures in a clear, understandable way - Providing assignments and projects for students - Offering guidance and feedback - Assisting students with any questions they may have This project is an exciting opportunity for someone who is n...
I'm in need of a professional who can translate an advanced-level English agreement into Arabic. This is an urgent task, and the translated document is needed within a week. While the document in question is quite complex, legal or technical, there's no need to have the translated document proofread by another Arabic native speaker. It's crucial that the freelancer has a solid understanding of both languages and legal or technical terminologies. Experience translating similar documents would be ideal.
I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintain the same output as the pres...
We are seeking a talented AI expert to urgently develop a sophisticated multi-modal sentiment analysis and emotion recognition system. This system aims to analyze and understand human emotions expressed through various modalities, including text, images, and audio. The primary objectives of this urgent project include: 1. Multi-Modal Data Integration: Develop algorithms to effectively fuse information from text, images, and audio sources to capture the holistic context of emotional expression. 2. Text Analysis: Implement state-of-the-art NLP techniques to extract sentiment and emotion from textual data. This involves sentiment polarity detection, emotion classification, and fine-grained sentiment analysis. 3. Image Analysis: Utilize deep learning architectures such as convolutional neu...
In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.
I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.
...OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices&quo...
Preferred Commnications and Wi-Fi, Inc. is looking for Watchguard firewall techs for both firewall and endpoint security pre-Install config. and support. Requirements: - In-depth knowledge of hardware firewalls and their functionalities. - Expertise in intrusion detection systems. - Experience with high-risk threat detection and response. - Capable of optimizing firewall settings for maximum security. I am looking for a professional with a sterling track record in enhancing hardware firewall intrusion detection capabilities. If you are up to the task and confident with high-risk threat management, I would like to hear from you.
...Automating complex business processes: I need someone who can create a system that can handle high complexity with advanced data processing and integrations. - Data Analysis and Visualization: You'll be required to develop analytical tools that can process and visualize data effectively. - Custom Form Development: I need custom forms to be built for various purposes within the applications. Ideal Skills and Experience: - Proficiency in Power Automate and Power BI: You need to be well-versed in both these tools to be able to create powerful low-code applications. - Proven track record in automating complex business processes: Experience in handling high complexity tasks involving advanced data processing and integrations is a must. - Strong analytical and visualiza...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
We are looking for a developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen sizes. Columns: - ...
...include: - Functionality enhancements: While specific changes haven't been identified, a comprehensive analysis and improvement of any weak spots is crucial. Your expertise in assessing and enhancing functionality is of immense value. - User interface: The project entails making necessary modifications in the UI design to ensure user-friendliness. Ideal skills for this role would include: - Advanced WordPress knowledge - Extensive experience in plugin development and updates - Strong troubleshooting abilities - Versatility in UI design and functionality optimization Please note that this project needs to be completed ASAP. Freelancers with immediate availability would be preferred. I look forward to collaborating with a savvy WordPress developer to improve and automate...
I'm looking for a freelancer who can help me shape my large, 535,000-word document into ...be in a smaller cap size. - I would like the index o show the page number for each essay. - I did the first 8 manually, and you can take them as an example model. Doing this manually will take me forever and I am sure someone pro like you can do this fast and easily. Ideal freelancer would have: - Prior experience in book formatting - Strong grasp of English language - Knowledge of Word's advanced formatting options It is just simple Text, no images, tables, or charts. (attached you can find the document itself). I seek a simple and neat result from someone with attention to detail and ability to organize a large document. Your bid should include any necessary revisions to ...
Job Title: AI Automation Expert Responsibilities: AI Development: Design, develop, and deploy AI solutions to drive business efficiency and automation. Automation Strategy: Collaborate with teams to identify au...AI in predictive maintenance, reducing downtime and increasing efficiency across our supply chain." 4. "AI-powered chatbots have transformed our customer service, providing 24/7 support and freeing up human resources for higher-value tasks." 5. "We're developing AI-driven products and services that create new business models and disrupt traditional industries." - AI-driven decision-making - Advanced data analytics - Automation of complex processes - Integration of AI with other emerging technologies like blockchain and IoT - Ethical consi...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
I'm ...ReactJS and NestJs to expand my existing CRUD application. Here are the features I need: 1. Buying and Renting Functionalities: The app should handle not only cars but also apartments. The interface needs to cater to both clients and admin. The system currently only has admin view on the frontend, views for the customer should be implemented. Im open to discuss how to best implement this. 2. Advanced Audit Functionality: I want to ensure system integrity through audit trails. Capability to track one critical element of the system and to record login/logout sessions is a must. 3. Google Maps Implementation: I'm open to suggestions on how this could enhance the app and the user experience. Experience in online marketplace development and audit systems would certai...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
I need advanced level steel shop drawings to begin the fabrication process. Here's what's needed: - Shop Drawings Detail: I require a meticulous approach, ensuring all the details required for a general contractor and architect to sign off are included. - Format: I need the final drawings to be delivered in PDF format. - Inclusive specifications: The final shop drawings should include the material specifications, welding symbols, and bolt connections details. Ideal candidates for this project should have experience in creating detailed steel shop drawings and a good understanding of the fabrication process. Proficiency in AutoCAD is a must, as well as a keen eye for detail. I'm in need of detailed steel shop drawings that are geared towards fabrication. I have set...
