Vba code rewrite vba codeงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
I'm seeking an experienced Android developer for a major interface update to my app. We need to facilitate a better user experience through user interface design enhancements and additional features. Key project aspects: 1. UI Design Updates: - Specifically, I want to improve the layout and navigation of my existing app. This process requires an innovative approach to enhance user experience and navigation flow. 2. Adding New Features: - Although I'm open to your expert suggestions for new features, the direction was not specified upfront. Potential freelancers must be proficient in Android development with a keen eye for intuitive, modern design. Working remotely, your ability to maintain clear communication for updates and changes on a shared session is crucial. Eff...
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.
Dough one 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 kno...
...need of developers proficient in low-code platforms to create a suite of applications. Firstly, we will need a web application, a mobile application, and an enterprise application developed. These are crucial tools for our business operations and customer interactions. In terms of functionalities, I require the following: - User authentication: The applications should have a secure login system. - Data storage and retrieval: The ability to store data and retrieve it when needed. - Integration with third-party APIs: Seamless integration with external APIs is a must. I'm expecting a relatively small user base initially, but these applications should be scalable and able to handle growth. Ideal candidates would have: - A strong background in low-code development - E...
More details: What is the desired color scheme for the HTML emails? Vibrant colors What type of data is being displayed in the emails? Graphs and charts How sophisticated should the timeline image design be? Moderate complexity with some unique elements
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 skilled web developer to assist in creating an integrated PHP/HTML code for integrating Star Micronics Cloud print. Your responsibilities will include: - Understanding the requirements of the Star Micronics Cloud print - Creating a detailed, clean, and functional code in PHP/HTML - Testing the code to ensure there is a smooth integration Ideal Skills: - Expertise in PHP and HTML - Experience with Star Micronics Cloud print integration - Skill in creating and integrating efficient codes. Please, only apply if you have a strong understanding of Star Micronics Cloud print and the ability to deliver a well-written, effective PHP/HTML code.
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 en...
Hi, I need many rewrites. The first batch is of 200 articles. I will ask for a 100 -150 word sample rewrite on the topic given by me. (Removed by Freelancer) Interested candidates, please bid. Long-term work for the right candidate. We will hire multiple writers. Regards, B
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
i wanna buy this plugin : and setting it for having this feature, for 1 of this need add custom code : need these features: 1. User area for cancel booking (unitl specific time setting) 2. Create service for specific day and time (example “Spinning Class” each monday at 10:00-11:00 am time) 3. Holiday block day 4. Limit user email / name booking only 1 time for service day/time (for this custom code ) 5. Waiting List when finished maximum capacity 6. Setting a specific range date for service example aviable / showing from start to end date
Want to modify xtream ui panel based on username and password to active codes Will share vidéo to explain it : This is démo how it will be : admin admin
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.
...second branch does the same thing except that it pushes different bottons so the tab order is different. Having two outcomes makes the python code to difficult for me so that i why I need help. I will also have to fine tune the number of tabs after you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 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 ...
...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...
Hi - I'm seeking an experienced Wikipedia writer to edit/write/fix content about a band. The article content is already in place but was rejected and I need someone who knows how to edit/fix the content to align with Wikipedia's guidelines. Key Requirements: - You're based in the the United States and speak English. - Your primary task will involve rewriting and editing the existing content. - Familiarity with Wikipedia's notability guidelines and other regulations is crucial. Your submission must meet the platform's quality requirements to get published. - The ability to create an engaging content that is not promotional in tone. It should inform readers about the business or organization. I'm hoping this can be completed within a month or so. I'm look...
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
We are looking for an expert for static site generation using faustj...headless WordPress in a monorepo project. Data fetching is done using graphQL. We already have all required react components for the site, but the components need to be moved into a reusable, independent ui library (including build scripts). We use Storybook which should import components from the ui library. We use styled components as css-in-js solution in our react components. We use graphql code generation to generate typescript types from our fragments. Static site generation should make use of SSR and server components. The coding is more than half done. We are looking for someone, who has already made all the mistakes, and guide us. My backend dev scope the project for 2 days. If it takes longer, we will ...
...to guide a transformer model to generate code-mixed sentences. Specifically, we are targeting basic code-mixing complexity - inserting words from one language into another. Key Responsibilities: - Develop and fine-tune a transformer model for code-mixing at a basic level - Implement the model in a way that can generate code-mixed sentences effectively Ideal Skills and Experience: - Strong proficiency in Python programming - Proven experience with NLP and transformer models - Familiarity with code-mixing and its linguistic aspects would be a plus - Good understanding of basic code-mixing complexities - Ability to design, implement, and evaluate NLP models This project is ideal for someone who is passionate about NLP and has a keen interest in ...
One excel file with macro as per the customer requirement
I'm seeking a skilled professional capable of converting GPT chats with code samples into interactive, running HTML pages. This project requires: 1. Expertise in HTML, JavaScript, JSON, GitHub, retrospective mobile display and the use of ChatGPT. 2. Proficiency in transforming chat scripts with intermediate level programming concepts into functional code. 3. The ability to generate dynamic HTML pages from these chats, complete with buttons that trigger specific code executions. This is aquick and challenging, yet rewarding task for those interested in innovative ways of transforming GPT chat conversations into executable, interactive web pages. Result will be stored as a github project, We will send invitation to awarded freelancer. Current budget is 62$+...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
...developing an AI Chatbot using the ChatGPT API integrated with Langchain, primarily for Customer support purposes. I'm looking for expert advice on enhancing and refining the existing code in the following key areas: - Handling User Input: I need guidance on improving the bot's ability to understand and process a wide variety of user inputs smoothly and effectively. - Generating Accurate Responses: I require assistance in fine-tuning the bot's response generation to ensure it provides relevant and accurate information to users' queries. - Performance Optimization: I am seeking recommendations on how to optimize the code for better speed, efficiency, and overall performance. The level of customization I'm aiming for in the Chatbot's responses...
I am in need of a skilled .NET developer, someon...gateway integration, ideally familiar with 2D/Sekretpay. - I've made modification to the code that should enhance the existing functionality of my project. Specifically, this is regarding a custom payment gateway where I have changed the API token. - Your role will be to assist in updating this code on the .NET framework, ensuring that changes made don't compromise any other functionalities. - Ideally, you should have prior experience in working with .NET and specifically in the realm of payment gateways and handling API changes. This will allow you to understand the complexities of the job better. If you believe you've got the skills and experience needed, I'd love to hear from you. Let's g...
We are in search of a skilled PHP developer to assist us in optimizing the code of our WordPress plugin based on feedback from WordPress. The ideal candidate should have a strong background in PHP development, particularly within the WordPress ecosystem, and be familiar with best practices for plugin development. Responsibilities: - Review and analyze feedback provided by WordPress on the performance and quality of our plugin code. - Identify areas for improvement and optimization within the existing codebase. - Clean and refactor code to enhance performance, security, and maintainability. - Collaborate with our development team to implement necessary changes and improvements. - Conduct thorough testing to ensure that the plugin functions correctly after optimizations...
I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.
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’m currently seeking a skilled web developer to help convert PUG code into HTML code for my ongoing project. The primary goal is to maintain the existing design format while ensuring the HTML version functions seamlessly. To accomplish this task swiftly and professionally, the ideal freelancer should: - Have a solid understanding and relevant experience of both PUG and HTML. - Be adept at maintaining the original design while converting from PUG to HTML. - Have a knack for inserting dynamic elements such as interactive forms into the converted HTML code. A demonstrated ability to pay attention to detail and deliver within a specified timeframe will be highly regarded. Additionally, a background in user-centric design could be beneficial.
As a developer versed with JavaScript, your mission is to break down my comprehensive project code into distinct components and push them into multiple repositories on Git. Key Tasks: • Deconstruct the overarching JavaScript codebase into its constitutive components • Create separate repositories for each of these components on Git • Implement the Gitflow workflow throughout this undertaking Ideal Skills: • Strong competence in JavaScript programming • Familiarity with code decomposition and the Gitflow workflow • Experience with creating and managing multiple repositories on Git. Your expertise in JavaScript and meticulous Git management will be instrumental to the success of this project.
Python refactor code, change logic for the investment strategy
I am residing in Canada and looking for a talented resume writer to revamp my resume, tailoring it to the Canadian job market. The resume should be targeted towards the Content Writing industry, specifically for the position of a Content Writer. Key highlights for the project: - **Resume Rewrite:** The primary goal is to rewrite my existing resume to make it more appealing and impactful for potential employers in the Canadian Content Writing field. - **Canadian Job Market Expertise:** Understanding of the Canadian job market and what employers in the Content Writing industry look for is crucial. - **Content Writing Industry Knowledge:** Prior experience in the Content Writing industry, either as a writer or working closely with such professionals, is highly desired. Ideal ...
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 have an existing small carport enclosure that needs to be brought up to code standards. It is currently made of wood and I would like to include windows as part of the design. Key Requirements: - The carport enclosure needs to be assessed and re-designed if necessary, ensuring it meets all relevant building codes. - Windows need to be incorporated into the design without compromising the structural integrity. - The use of wood as the primary material will need to be considered and any necessary adjustments proposed to ensure it's compliance with the code. - The enclosure must maintain its functionality as a carport while meeting all code requirements. I'm looking for a professional who has experience in architecture and compliance with building codes, wit...
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 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 need a Python code developed for vehicle route optimization. - The code should include 3 algorithms for route optimization. - Successful freelancers should include past work in the application. Ideal Skills: - Proficiency in Python - Experience in developing route optimization algorithms - Strong background in data analysis, web scraping, and machine learning, as these functionalities will be required in the project.
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.
I'm looking for a skilled PHP developer to create a code editor plugin. The plugin should replicate the functionality of the Shopify code editor, offering Syntax Highlighting, Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Implement Sy...
As the client for this project, I urgently require an expert in VBA.
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.
