Macro install 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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optimization: Your focus here should be to enhance user experience. This could involve improving page loading speed, streamlining the user journey, or other UX-related optimizations. - Create and install a new visual template: A fresh, engaging visual template can breathe life into the site. This is vital for user retention and engagement. Ideal candidates for this job should have: - Profound expertise in CS-Cart Multi-Vendor platform. - Strong debugging skills in PHP and MySQL. - Experience in server configuration and security settings. - Solid understanding of use...
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
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, s...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 manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...
I'm in need of a WordPress expert to install and configure Yoast SEO plugin on my site. The task primarily involves: - Expert installation of Yoast SEO plugin - Proper plugin configuration to ensure optimal site performance - Allowing for efficient future content management Ideal candidates should have a solid background in WordPress plugin installation and configuration, preferably with Yoast SEO plugin. Proven expertise in SEO strategies and practices is highly valued for this role. The goal is to effectively improve site SEO through this plugin installation. Substantial experience in similar projects is a huge plus.
I need an experienced Magento developer to install the latest version of Magento 2 on my VPS. I also require the installation of a specific theme (Theme A) and potentially some modules to enhance the functionality of the website. Key Requirements: - Install the latest version of Magento 2 on my VPS. - Implement the chosen theme (Theme A) to give my website the desired look and feel. - Potentially install some modules based on your expertise. While I have not specified any particular module, I am open to recommendations that align with the goals of my e-commerce site. Timeline: I need this project to be completed as soon as possible. Ideal Skills and Experience: - Proven experience in installing Magento 2 on VPS. - Proficiency in Magento theme implementation, specif...
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çã...
I am in need of a professional who can promptly install and customize a PHP script for me. The PHP script I need to be installed is purchased through codecanyon. You will install, test all functions and activate license on our server. Being somewhat urgent, my requested completion for this project is ASAP. I value efficiency and swift, quality work. Thank you
Install Wordpress and PHPlist on my server and provide instructions on how to access from my PC.
Project description: I'm seeking a proficient local network cabling contractor to handle projects and technical support. The task involves installation of network equipment (switches, access points, and security cameras for both indoor and outdoor areas). Your role will involve: - Mount/Install network equipment as directed - Field technical support - Remote support Contractor should carry liability insurance and C7 license is preferred Ideal candidates should have extensive experience with network cabling and a track record of executing similar projects successfully. It's crucial for the freelancer to be proficient in handling varieties of network cables especially Cat 5e, Cat 6 and Fiber optic cables, and familiar with network switches, access points, speak...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...
I am looking for a Google expert able to install the cookie consent mode v2 imposed by UE Law. I don't want any banner to be installed on my website and I want the code installed on my website to always autorised cookies using for all visitors on my website.
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.
...so far. 1. I first installed the pip3 and Python 3 Virtual Environment by running. - sudo apt install -y python3-pip python3-virtualenv 2. I then created and activated the Virtual Environment by running. - python3 -m venv projectsenv - source projectsenv/bin/activate 3. Then I installed opencv while inside the virtual environment - pip3 install opencv-contrib-python 4. After that I installed the depthai dependencies for Linux (still in the environment) - sudo wget -qO- | bash 5. Then I installed depthai (still in the environment) - python3 -m pip install depthai 6. Then I cloned the "depthai-python" git hub repository 7. Then I ran the install requirements (still in the environment) - python3 Finally, I tried to
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
I am in search of a skilled developer to set up PHP 5.6 and PHP 7.2 on our dedicated server. The server currently runs Plesk and Ubuntu 22.04.4 LTS. I need both PHP versions running on the server, as we have one Magento 1.9 website and one Magento 2.3 website. Key Requirements: - Install PHP 5.6 and PHP 7.2 on our dedicated server running Plesk and Ubuntu 22.04.4 LTS - Set up both PHP versions to be used on different websites - I may require support in configuring the websites to use the specific PHP versions after installation The ideal candidate for this project should have: - Extensive experience working with PHP installations on dedicated servers - Proficient knowledge of Plesk and Ubuntu - The ability to provide guidance on PHP version selection based on the websites' ...
I have code for login trading accound and fetch token data. I need to update more data ...stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Money you should waste you time for unrealish E...
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
...of a skillful developer experienced in OpenCart 3.0.x who can work on a TNT extension for me, with an emphasis on two key features: 1. Real-Time Shipping Rates: The extension should offer real-time shipping rates from TNT; it must consistently and accurately display current costs to customers. 2. Easy Installation and Setup: Ease of use is paramount. The extension should be straightforward to install and set up on my online store. The project deadline is within one month, so time management will be a crucial skill for interested freelancers. Proficiency with JavaScript, PHP, eCommerce, HTML and CSS is required, along with OpenCart experience. If you have worked on similar projects before, please include them in your proposal. This shopping cart has been operating for several ...
I'm looking for a skilled professional to help me install the eBay API on my existing Ubuntu 22.04 server for the primary purpose of showing orders on webpage. here is the sdk - Key Responsibilities: - Installation of the eBay API on the Ubuntu 22.04 server. - Ensuring the API is correctly set up to show orders on webpage. Ideal Skills and Experience: - Proficiency in working with Ubuntu servers, particularly version 22.04. - Prior experience installing and configuring the eBay API. - Ability to implement API functionalities for showing orders on webpage. If you have a good understanding of eBay's API and are experienced in working with Ubuntu servers, I'd be interested in hearing from you. Please share your relevant experience and explain how
...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...
...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 with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
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.
2 excel files with VBA macro as per customer requirement
I need an expert WordPress developer who can correctly install a Business Child Theme I've chosen on an undetermined (the freelancer must figure out which one) main WordPress theme. The ideal freelancer has to have experience dealing with WordPress themes and should be capable of figuring out the main theme on their own. Key Tasks: - Install Business Child Theme on main WordPress theme - Ensure compatibility of the child theme with the main theme The entire child theme design (pictures, logos, texts, etc.) must be loaded correctly so that I can immediately begin editing the site blocks myself. The freelancer will need to be proficient in WordPress, theme installation, and troubleshooting. The ability to determine the parent WordPress theme through analysis of t...
One excel file with macro as per the customer requirement
I'm in need of a talented frontend developer to create a robust and user-friendly search frontend for document base. The documents are already indexed in an Opensearch database with various custom fields (Speaker, Place, Theme, Keywords,... ) apart from the standard ones (document format, creation date, update date, size, link to ...and integrating them seamlessly into the search frontend. - Ability to implement interactive user interfaces, such as autocomplete suggestions and dynamic filtering and sorting options. - Experience in creating responsive and intuitive search result displays. - Prefered technology : React, Reactivesearch () Expected delivery: - Source code, build and install instructions - Developper guide for maintenance and evolution
The main goal of this project is to find relevant influencers using our Shopify Collabs. Influencers which you will contact, they need to call their followers to install our new android Dance APP. In our APP influencer need to create one new video, and call their followers to dance with them inside our app until the song is finished. App is a new type of "collab dance app" where each user record dance on one small segment of any song (2-4sec) creating a new cool unpredictable music video. You need to try and test our app as well to understand it a bit. Key Responsibilities: 1. Check our Shopify Collabs Account and optimize it using our website, pictures, videos, reels, etc. You can create some pictures, reels as well. 2. Find Influencers using our Shopify Account or ma...
installation of theme and make the theme ready to be used
I need a proficient Linux systems administrator to help install and configure LibreNMS on my Linux system primarily for Network Monitoring. Key Requirements: - Install LibreNMS on a Linux platform - Configure LibreNMS for optimal Network Monitoring - Set up monitoring of Virtual Machines Important Skills: - Expertise in Linux system administration - Familiarity with LibreNMS and its Network Monitoring functionality - Experience with monitoring Virtual Machines.
...of a skillful developer experienced in OpenCart 3.0.x who can work on a TNT extension for me, with an emphasis on two key features: 1. Real-Time Shipping Rates: The extension should offer real-time shipping rates from TNT; it must consistently and accurately display current costs to customers. 2. Easy Installation and Setup: Ease of use is paramount. The extension should be straightforward to install and set up on my online store. The project deadline is within one month, so time management will be a crucial skill for interested freelancers. Proficiency with JavaScript, PHP, eCommerce, HTML and CSS is required, along with OpenCart experience. If you have worked on similar projects before, please include them in your proposal. This shopping cart has been operating for several ...
Hi there, I'm in need o...a working webpage. - Implement responsive design principles to ensure optimal viewing across various devices. - Optimize website performance for speed and SEO. - Conduct thorough testing to identify and fix any bugs or issues. - Provide up to 3 revisions and 3 days post each submission for reviewing. - Integrate plugins and third-party tools to enhance website functionality such as Calendly - Install the theme and test its working on our WordPress account. Terms and Conditions: - Be available in IST time zone 9 to 6 PM. - All shared resources and deliverables are confidential and may not be shared, reused or published anywhere else without prior consent. Looking forward to seeing your work and hopefully collaborating with you on this proje...
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 delivering high quality and d...
I'm on the lookout for a well-versed WordPress developer, profici...all aspects related to WooCommerce, including payment methods. The ideal freelancer for this job should have formidable experience with WordPress and WooCommerce, a proven track record of improving website performance using PageSpeed Insights, and a comprehensive understanding of e-commerce web development. Good afternoon everyone, I have aweb page in my c panel; I have 2 themes that I want to install. to each one independently by wordpress. In addition to this, I want WooComerce to be able to be used and linked to all payment methods, in different currencies. Please take into consideration we have our added products must also be. Installed plugins. high load level by PageSpeed Insights
I have a magento webstore running on magento 2.3.4. I want to update it to the latest version with all patches, while maintaining current customers/database/products. I also want usps first class mail parcel/usps ground advantage to show up again as a shipping method.
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...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...
I need an electrical engineer to perform circuit design and troubleshooting tasks using a hardware simulator, specifically for .HDL files. Your primary task will be to install an electrical system with the help of the simulator. Key Responsibilities: - Circuit design using the simulator - Circuit troubleshooting - Electrical system installation I require you to be proficient in using a hardware simulator, especially with .HDL files. You should also have a solid understanding of circuit design and troubleshooting. Time is of the essence, so the quicker you can complete the project, the better.
Scope of work, SureCart (high level). SureCart, SureTrigger, and SureMembers are powerful tools for creating and managing subscription-based platforms. Here's a detailed scope of work based on your requirements: Platform Setup and Configuration: Install and configure SureCart, SureTrigger, and SureMembers plugins/extensions. DONE. Set up payment gateways for processing transactions (Stripe, PayPal). DONE. Configure user roles and permissions for different membership levels (Freemium, Plus, Pro, Premium). Customize email notifications for user registrations, subscriptions, and other relevant actions. Product and Subscription Setup: Define and create payable products for each membership tier (Freemium, Plus, Pro, Premium). Set up subscription plans with varying features and ac...
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.
