Vba arrayงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
One excel file with macro as per the customer requirement
We're in need of an experienced photo editor to refine pictures from our wildlife safaris - both local and international. The primary tasks include color correction and cropping/resizing. Here are the specifics of the project: - **Editing Requirements**: As a wildlife safari company, we collect a vast array of pictures from our adventures. Your role will be to ensure that the colors in these images are corrected to appear as natural as possible. Additionally, you'll be responsible for cropping and resizing images to enhance their overall visual appeal. - **Desired Look**: We're aiming for a 'natural and realistic' style for the edited photos. The goal is to maintain the authenticity of the captured moments while enhancing their visual quality. Experience i...
I'm on the lookout for a professional garment designer with a knack for creat...vision into appealing, contemporary styles - Ensuring that the garments are not only fashionable but also practical and comfortable - Developing detailed tech packs for production The garments should cater to a broad audience including men, women, children, and the elderly. An understanding of the diverse needs and preferences of these demographics is crucial. Prior experience in creating a wide array of styles, from casual to formal, vintage to modern, will be highly valued. A portfolio that showcases your versatility and ability to adapt to different aesthetics is a must. If you're a creative professional with a keen eye for detail and a passion for innovative garment design, I'm exci...
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 delivering high quality and defect-f...
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.
Helllo. I am seeking a full-stack developer who can rendering 3d object with polypoints and animations like zoomin or zoomout with mouse control. This project involves leveraging React and to create an interactive 3D object rendering application, utilizing a polypoints array for precise geometric representation. By integrating Node.js for backend operations and employing React Three Fiber (R3F) for seamless integration of within the React ecosystem, the project aims to enhance front-end development capabilities, offering a dynamic and immersive user experience. Budget: $100, Deadline: 2 days Excited to see your applications!
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined 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, please provide example...
...Web APIs used should require user authentication (oAuth). So your application should allow user to login and logout. The basic requirement is to use Facebook’s Login Button. But more marks will be awarded for using SDK (basic to intermediate) or implement your own oAuth (hard). • The main data for your application retrieved from Web API should be at least as complex as an array of objects. E.g. An array of likes, or array of photos. • Your code should be appropriately structured into MVC. A bundler, i.e. webpack, should be used to bundle all the modules together. • Templating (e.g. or JSX etc) should be used to handle the display of dynamic content (and structure your code). The following are intermediate to hard requirements. Some of these req...
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 need a talented graphic designer skilled in Canva to develop an array of marketing materials. These will including social media graphics, flyers, infographics as well as designs for banners and other signages. The designs will be primarily used on Facebook and Instagram. The main objective of these materials will be to promote a product or service while simultaneously building brand awareness. The ideal candidate should be creative, understand the nuances of designing for social media and print, and have a knack for visual storytelling. A portfolio showcasing similar past experiences will be highly appreciated.
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.
In search of a highly skilled Corel Draw editor to provide comprehensive modifications to an array of existing designs. Your primary tasks will involve: - Adjusting layers and details of our current CDR (CorelDRAW) files - Not simply making superficial tweaks, but real, valuable impact through detail-specific adjustments An ideal candidate would have previous experience editing and manipulating vector graphics, particularly in Corel Draw. Proficiency in handling text and typography within the software is a plus. This is not a job simply about making changes, but about understanding how each modification affects the bigger picture. Let's enhance these designs together! Requirements :- 1) We need convert all designs in 3 color a) White Color b) Black Color c) ...
In search of a highly skilled Corel Draw editor to provide comprehensive modifications to an array of existing designs. Your primary tasks will involve: - Adjusting layers and details of our current CDR (CorelDRAW) files - Not simply making superficial tweaks, but real, valuable impact through detail-specific adjustments An ideal candidate would have previous experience editing and manipulating vector graphics, particularly in Corel Draw. Proficiency in handling text and typography within the software is a plus. This is not a job simply about making changes, but about understanding how each modification affects the bigger picture. Let's enhance these designs together! Requirements :- 1) We need convert all designs in 3 color a) White Color b) Black Color c) ...
As the client for this project, I urgently require an expert in VBA.
In this project, I am seeking a mid-level Frappe framework developer. You will be expected to handle an array of tasks including: - Customizing existing modules to optimize their performance and meet our unique business needs. - Constructing fresh modules to expand the functionality and efficiency of our system with innovative solutions. - Providing technical support and bug fixes to ensure the system runs smoothly and efficiently. Your 3-5 years of experience working with Frappe framework would be instrumental in achieving my project's goals. We have wireframes and designs ready for this project which will guide you and facilitate a better understanding of the desired outcomes. The ideal candidate for this project is an excellent problem solver, meticulous in their attent...
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 interfaces for Excel.
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 Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
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 reporting is key. If you can meet th...
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'm in immediate need for a professional who excels in copy typing. The specific skillset required includes: - Expertise in copy typing from an array of formats (Handwritten notes, Printed materials, Digital files, etc.). - Ability to work efficiently and accurately under minimal supervision. - Complete adherence to the provided guidelines and formatting. - Ability to operate and deliver within unspecified timeframes. Time sensitivity for the completion of this project is currently undefined. Interested freelancers should be flexible for any time constraints that may present.
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 interfaces for Excel.
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 skills and experienc...
• 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 a...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 T...
I'm looking for a highly skilled and professional video editor for my Instagram reels. I am willing to pay upwards of $100 per edit.. Here are some essential details: - Each video is expected to be 45 seconds- 1 minute 10 seconds long. - It will mostly contain a wide array of topics, from providing valuable content to pre-handling objections and showcasing authority or case studies - The preferred style for the video edits is fast-paced and energetic, combining engaging storytelling while keeping it clean and simple In terms of skills and experience: - Proficiency in video editing software is a must - Experience in social media content, particularly Instagram reels, is highly preferred - Ability to create fast-paced, engaging content while maintaining a clean and minimalist...
I'm in the market for a skilled and experienced developer who can craft a cutting-edge multivendor E-commerce platform designed to cater to the electric vehicle (EV) market. The platform will be offering a wide array of products including electric vehicles, charging equipment, and various EV accessories. Essential features for the project include: - User Registration and Login: The platform should allow for seamless and secure user registration and login processes. - Product Search and Filtering: A robust search functionality combined with effective product filtering capabilities to help customers easily find what they are looking for. - Secure Payment Gateway: The platform should integrate a reliable and secure payment gateway to facilitate smooth transactions and protect us...
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 for successful output.
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.
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.
I'm on the hunt for an adept professional capable of sourcing, securing, and delivering an array of software development opportunities encompassing mobile applications, web development, and even desktop software creation. Key Requirements: * Proven expertise in Python, JavaScript, Java, RPA and automation, with hands-on experience on relevant projects. * Ability to provide detailed project proposals - the success of our collaboration heavily depends on this. * A broad understanding of the software development landscape, and a strategic competence in identifying and securing viable projects - your proficiency in this will make us a perfect team. Experience: If your experience includes winning bids and securing technology-focused projects in a competitive market, you're ...
...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 Excel sheet. Very Important: Excel Formula/Script/Code/Macro/VBA Function or whatever you can call which is embedded in and compatible with excel. (You have to open the attachment to run a script on it). When the available quantity of a spare part reaches a certain value ( Minimum Stock Value or Less ), An automatic Notification Message including the data of I.N , S.P.D , and A.Q, Will be instantly sent into my what's app Number So I ...
...This model will serve as a crucial part of my eCommerce store, allowing customers to pick their preferred color, style, and even customize dimensions before placing an order. Key Features Needed: - Interactive color selection: This will allow for an engaging and user-friendly interface for customers to pick their desired color. - Multiple style options: The model should be able to present an array of styles for customers to choose from. - Customizable dimensions: Customers should be able to adjust the dimensions of the product as they see fit, to ensure a personalized end result. Industry Focus: The 3D customization model will be specifically used for a fashion site. As such, it's important that the model is designed to cater to the unique needs of this industry. Integra...
I'm seeking a skilled content writer endowed with a strong SEO background and copywriting experience for my technology-focused agency. W want to handle an array of clients, necessitating someone capable of delivering dynamic and engaging content. Key Responsibilities: - Blog Writing: Devise and generate original, compelling blog posts with a deep understanding of technology-related themes. - Copywriting: Create persuasive website content enhancing user interaction to fulfill clients' requirements effectively. SEO Expertise: The content should be SEO-rich with emphasis on the following strategies: - Keyword optimization: Proficient in keyword research and effectively incorporating them into the content for better visibility. - Metadata creation: The ability to create meta...
Seeking a skilled website designer adept at creating eCommerce platforms. The online store does not have a specific product line yet, so flexibility and adaptiveness in design are required....online store does not have a specific product line yet, so flexibility and adaptiveness in design are required. While we're not sure about the payment gateway yet, we do anticipate that we'll be listing fewer than 50 products initially. Skills and Experience required: - eCommerce website design - Knowledge in integrating payment gateways (just in case) - Experience in managing and displaying an array of products - Proven expertise in user-friendly designs. Briefing guidelines and further project details will be provided when selected. Please provide samples of previous work when s...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentia...
I have a daily dataset of the prices and funding fees of cryptocurren...format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.
I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first closes...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
I'm currently seeking an experienced HR recruiter to assist with sourcing senior-level candidates as soon as possible. Key job responsibilities would involve: - Developing and implementing overarching outbound hiring strategies - Outreach to prospective senior-level candidates through various channels - Managing the candidate interview and recruitment process Experience in a broad array of industries would be ideal, as the specific industry for the roles remains open-ended. As this project requires immediate attention, a proven track-record of prompt and successful senior-level recruitment is essential.
I'm seeking a talented app developer to build an engaging entertainment app that will be available on both iOS and Android platforms. The ideal candidate for this project should have: - Proficiency in cross-platform app development, - An impressive portfolio of interactive, user-friendly app designs. - Knowledge and skill in creating apps for...purposes (games, videos, etc.). Since I did not select any external APIs for integration, focus should be placed on: - Ensuring the app works smoothly without the need for external APIs, - Guaranteeing data security in the absence of third-party API integrations. This project is an exciting opportunity to showcase your ability to create a compelling entertainment app that resonates with a wide array of audiences. Looking forward to ...
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowled...
I am in need of a dynamic marketing individual who can manage an array of tasks efficiently. Your skills would not only include the handling of various social media platforms but also the creation of crisp, engaging content and the successful roll-out of advertising campaigns. Your duties also involve making crucial phone calls, and hence, excellent verbal communication skills are a must-have. The overarching goal of this role is to boost product sales, so previous experience in sales-driven roles would be beneficial. Key Responsibilities: - Social Media Management: You would be expected to handle all social media outlets and ensure constant interaction with our valued customers. - Content Creation: Expect weekly creation of unique, compelling content that effectively demonstrat...
...linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macr...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.