Vba macro sort dataงาน
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 เป็นเมนูที่จะโทรออกอัตโนมัติ
... จะทำการติดต่อกลับเพื่อสร้างใบเสนอราคา ภายใน 2 ชม. หลังจากที่ฟรีแลนซ์มีการกรอกฟอร์มแจ้งความประสงค์ที่จะทำการแบ่งชำระเข้ามา (อ้างอิงจากเวลาทำการปกติของ จันทร์ - ศุกร์ เวลา 9.30 น. ถึง 18.30 น.) 11:04 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้
I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
...visually appealing site for my digital product business. The main goal of the site is to facilitate the sale of digital products, so it's critical that the design is conducive to ecommerce. I want to make it easy for customers to navigate the site, find products of interest, and complete their purchases. Key features I'm looking for include: - Product filtering: Customers should be able to easily sort and filter products based on relevant criteria to help them find what they're looking for. - Customer reviews: I want to incorporate a customer review system so that potential buyers can see feedback from others, encouraging them to make a purchase. - Social media integration: To help with brand building and reach, connecting the site seamlessly with social media p...
2 excel files with VBA macro as per customer requirement
I'm looking for a designer who can design a tattoo design for me. Here is the concept: Memento Mori (Remember Death)...rhythm: Reminds us of the vitality and pulse of life. Integration of Both Concepts: Dual-faced mask: One side represents life, the other death, showing the dual nature of existence. Combination of a blooming and withering tree: Illustrating the continuous cycle of life and death. I like the direction of these ideas. A tree in the middle with a Grim Reaper, Crow/Raven, and Veiled Skull of some sort on one side, and symbols of life on the other side. It should be memento mori vs memento vivere. Fading from one to the other across the image This would be stretching across my back so the separation of the two sides would be ideal. Start your proposal with &qu...
I'm looking for a designer who can design a tattoo design for me. Here is the concept: Memento Mori (Remember Death): Reaper or Grim Reaper: Symbolizes death an...rhythm: Reminds us of the vitality and pulse of life. Integration of Both Concepts: Dual-faced mask: One side represents life, the other death, showing the dual nature of existence. Combination of a blooming and withering tree: Illustrating the continuous cycle of life and death. I like the direction of these ideas. A tree in the middle with a Grim Reaper, Crow/Raven, and Veiled Skull of some sort on one side, and symbols of life on the other side. It should be memento mori vs memento vivere. Fading from one to the other across the image This would be stretching across my back so the separation of the two sides ...
One excel file with macro as per the customer requirement
...or other relevant parameters to enhance user experience. It should be possible to sort the documents by multiple parameters at the time. - Autocomplete Suggestion: An intuitive autocomplete suggestion feature would help users with their search queries. - Security: Access to the frontend is restricted to users whose credentials will be checked against the organization's LDAP. The fronted also need to authenticate to the opensearch backend with a given client key. Data Types: The search frontend should be able to handle different types of data including Text, Images, Audios, Videos, and more. This means the frontend should be able to communicate effectively with the backend to retrieve and display all these data types during search. Search Results Displa...
We are in need of a proficient Flutter developer to enhance our mobile application. The focus of this project is to refine the functionality of the Trending Screen, specifically to display products currently available on Wishive, which are integrated with Woo-Commerce and modify the click behaviour for in-app web-view. API calls will be provided. Below is a detailed breakdown of the task...to a new wishlist or an existing wishlist upon tapping the Heart icon. Note that this small mandate serves also to test a hew hire to join our team as part of a bigger project. Ideal skills and Experience: - Expert level proficiency in Flutter - Proven track record improving mobile app user interfaces - Experience implementing category filter options - Previous work integrating a popularity sort...
...to take my song, "Own Your Own Mind" by Lynn Fox, and turn it into a fun and light-hearted and maybe a bit sarcastic cartoon strip. This strip should provide a humorous example of what it means to own your own mind, or the opposite. It could demonstrate why it is important. Some key details: - Style and Tone: This could be light hearted or even a little bold. The song is a sit back and listen sort of song. - Colour: The final cartoon strip should be in colour, not black and white. - Panels: I envision the cartoon strip to have 3 to 5 panels to be used in a post on instagram and facebook. Credits will be given if you have a social account I can tag. I'm looking for someone who can bring this creative vision to life, with a strong ability to infuse humour and visu...
I'm seeking a skilled lead generator to find quality B2B leads for businesses in various industries. While there's no specific criteria involving the location, company size, industry, or revenue, a successful candidate should have: - Proven experience in B2B lead generation - Strong understanding of different industries - Proficiency in using software to mine and sort data - Exceptional communication skills Take note: No specific criteria was indicated, so the ability to identify potential leads accurately and effectively is key in this project.
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...
...**Sorting**: The grid should allow users to sort the data in ascending or descending order based on specific columns. - **Filtering**: Users should be able to filter the data based on specific criteria to find the information they need efficiently. - **Pagination**: The grid should support pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edi...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...
I've redesigned a website and I want a sort of comparision from old to new design and highlight it I can provide you both websites to take snapshots of the pages
I'm building the brand for a new business that offers affordable tax services to freelancers. This is a...the following: An employee with a side-hussle, investment property, private medical aid membership wanting to get your tax affairs in order. Independent contractor whose salary is subject to PAYE deductions, but incurs trade expenses to get the job done. A sole proprietor responsible for paying all your taxes. A freelancer who has only ever earned a salary but now you’re told that you have to sort out your own taxes. A business owner that needs to pay yourself a salary. Should your business be paying dividends? Should you register for PAYE? I can guide you through the income tax consequences of life events so you can rest assured that you have kept on the right...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is...
I'm looking for a professional who can ...from a website that I will share with you. This data should be filtered according to specific product details. Key Requirements: - Retrieving product information including SKU, Category, Sub-Category, Color, Gender, Age, Material, Sleeve Length - Implementing a filtering mechanism to sort and organize the scraped data - Attention to details for accurate data scraping The ideal freelancer for this job should have: - Experience in web scraping and data mining - Strong understanding of data sorting and filtering - Proficiency in managing and storing large sets of data - Excellent communication skills to understand and address any queries regarding the project Looking forward to working together ...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial...
I'm struggling with a problem - I've installed SSL on my server and it seems to be running smoothly with Apache. However, the issue arises with my DNS, where the SSL isn't working. Precisely, HTTPS isn't functioning as expected. What I need is someone experienced with server setup, particularly SSL encryption, Apache, DNS configurations, and fault-finding to step in and sort this out. IDEAL CANDIDATE: • Proven experience with SSL and DNS. • Knowledge of server configurations. • Proficient in troubleshooting and resolving technical issues. • Attention to detail for fault-finding. Please include your previous experience dealing with similar issues, your approach to problem-solving and why you're the best fit for this job in your appli...
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, ef...
We are looking for a skilled and experienced web developer to build a professional website using Webflow where users can share their Google Maps Saved Lists URLs and other users can search and filter these lists by city, country, categories, keywords, review rating, min. number of reviews and more. Users can sort by newest at the top, or by highest ratings, or by our algorithm. The website needs to be visually appealing, user-friendly, mobile-friendly and optimized for SEO. Currently I have a webflow, zapier, and airtable account, but happy to use other tools should the website developer prefer. Attention to detail, creativity, and the ability to meet deadlines are essential. Web developer's input into design and UX/UI are very much appreciated. If you have a portfolio of p...
...at a time. I hope you understood the functionality I want. Also, the app should be able to detect the aspect ratio of each page in the pdf file so that it displays it in 100% view without distorting the text or the images in the pdf file. Please kindly let me know if you can develop this very simple app. Also, the app should be a single standalone exe file. That is, it should not require any sort of installation process to install it. It should just run as soon as we double click it. I believe you can use the pyinstaller app to develop such a single standalone exe file. By the way, I need the file to be developed in python, and all source files should be provided together with the executable file (app). The ideal candidate should have experience in desktop application devel...
...keywords were established, we used our specialist tracking software to monitor our progression. Sounds easy, but it’s actually really complicated process that takes us a week or even more. Filtering the best backlinks from our resources After in-depth analysis, we continue with using a huge list of prospect websites to place the backlinks on. Our resources could contain up to 5 000 websites – we sort them by DA, PA, CF TF, niche relevancy, traffic per month, and even web-design parameters. That’s why we spend weeks manually choosing sites to place the backlinks on. Link Building Implementation DA 40+ 400 Backlinks/month Very high quality backlinks Contextual backlinks No spam, No PBN Time of link building: 6 months at the first stage and 24 months extension ...
I have a masonry business, we build anything that requires the use of cement and pavers for example patios, walls, driveways, walkways etc I need a logo with the name SV Masonry, and I would like the logo to include some sort of tool that we use for example bricks, shovels, cement etc
..."Aloha," I'm targeting a minimalist style logo inspired by flower colors like pink, clear brown, and purple. I need something unique and aesthetically pleasing that invokes the nature of our establishment. Considerations for the Logo Design: - Preferred Style: Minimalist. We're after a clean, crisp aesthetic that is instantly recognizable. - Color Palette: Pink, clear brown, and purple - the sort of warm, vibrant colors associated with flowers. - Essential Elements: Incorporate floral elements into the logo. The goal is to reinforce the brand's natural, tropical feel. Attached you will find samples of several logos that we have in mind an the color pallet we would love to incorporate. Ideal Candidates: - Proven background in minimalist logo design -...
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
...Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Exce...
