Vba code to consolidate data from multiple workbooks into one sheetงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
...1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง 1.3 Export ราคา รถยนต์มือสอง 1.3.1 สามารถ Export ข้อมูล รถยนต์มือสอง ให้พนักงานได้ โดยเลือกเงื่อนไข โดยเลือกเงื่อนไข ได้ 2 วิธี 1.3.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.3.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.3.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.3.3 แสดงได้ทั้งเป็น Preview และ Excel file 1.3.4 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 2. รถยนต์ใหม่ 2.1 Download excel file format การกำ...
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี 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. ระบบแชททั่วไป และแชทส่วนตัว
looking for job typing document from book by on line I mean want to work at home
I want translate English to Japanese 1 page within 1 hr.
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
I'm looking for a developer to create a complex ecommerce website based on Odoo ERP. This project involves extensive customization and integration of various features primarily tailored for a multi-branch business model. The system must be able to handle multiple branch warehouses, with each customer being assigned to a specific branch based on their location. Key Requirements: - Integration of Point of Sale (POS), Accounting, Customer Relationship Management (CRM), Inventory Management and Purchases features from Odoo ERP. - Implementation of a system that assigns customers to a branch based on their location. This should be done automatically based on IP, and also allow customers to manually select their preferred branch. - Seamless ...
There is a website that I do not have access to the hosting and I just need an embedded video extracted from it and saved as an MP4 file. Let me know if this is something you can do, looking to get it done now within the hour.
Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...Platform**: The primary platform for this component will be web. - **Language Support**: The component doesn't need to support multiple languages. **What I expect from you:** - A fully functional Blazor keyboard that can be integrated seamlessly into web applications. - The keyboard should be able to facilitate on-screen typing and have a virtual layout. - You should be able to deliver clean, well-documented code that can be easily maintained and extended. **Skills/Experience Needed:** - Extensive experience with Blazor and web development. - Prior experience in building on-screen typing and virtual keyboard components would be a huge plus. - Good understanding of UI/UX design principles to ensure a user-friendly and intuiti...
The Job You will be responsible for : Handling inbound calls and emails in a professi...professional manner. Resolving customer inquiries and requests and ensuring strong customer satisfaction. Working with various internal teams to ensure prompt and accurate order processing and delivery. Escalating customer feedback as required. Ideal Candidate You have at least 1 year experience within a Customer Service or Customer Success role, ideally within the Ecommerce / Marketplaces, IT Services and Retail industry. You possess excellent interpersonal as well as written and verbal communication skills. You are a strong team player who can manage multiple stakeholders You are adaptable and thrive in changing environments You pay strong attention to detail and deliver work th...
...email/password authentication, a WebView pointing to , and integration with Wonderpush for push notifications. 2. Project Objectives To develop a user-friendly and functional mobile application that allows users to log in through multiple authentication methods and access the website via an integrated WebView. The app should also be capable of sending push notifications. 3. Required Technologies Framework: Flutter Languages: Dart Compatibility: Android and iOS Push Notifications: Wonderpush 4. Feature Details 4.1. Loading Screen Description: A simple loading screen displaying the app logo and a loading animation. Display Duration: 2-3 seconds or until the app is ready. 4.2. Login Page Description: A page that allows users to log in via: Facebook Lo...
I'm ...looking for a skilled web developer to create a clean, minimalist one-page website for my company. Key Requirements: - The website should be one page only, containing all necessary information about my company, the services we offer and essential contact information. - The design should be clean, minimalist and professional, in line with current web design trends. - The site should be easy to navigate and responsive across all devices. Your Skills: - Proficiency in web development, specifically one-page websites. - Strong design skills with a focus on minimalism. - Experience with responsive design for cross-device compatibility. Please provide examples of your past work and let me know your availability. This is an urgent project, so I�...
...tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Re...
...Prescription refill requests: Allowing customers to refill their prescriptions with ease online. - Online Appointments System: Include an efficient system for booking appointments. - Live Chat Support: Enable real-time assistance for users. - Multiple Pages with different sections: An organized site with separate pages for company’s information, contact details, medicines list, etc. Design Aspects: - Main Color Scheme: Red and white to create a bold energetic impression. - Design Style: Modern and clean to ensure easy navigation for users. Ideal skills and experiences: - Experience in developing comparable online pharmacy or healthcare sites. - Strong understanding of UI/UX optimized for ease-of-use. - Proven track record in secure payment and sensit...
...The scans have some imperfections that need to be cleaned up. - Smoothing the surface: The model needs to have a smooth finish for 3D printing. - Closing holes in the model: I need any gaps or holes in the model to be fixed. I am able to download the scans in multiple file formats, so please let me know which one works best for you. Additionally, I intend to sell these prints, so you will need to sign a Non-Disclosure Agreement. Ideal skills and experience for this job include: - Proficiency in 3D modeling and 3D printing - Experience with cleaning up 3D scans - Attention to detail - Knowledge of file formats such as STL, OBJ, and PLY I will attach an example photo. If this goes well I then have other scans to fix ...
...with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be required to manage key client accounts, upload new content on Amazon listings, work with design, sales and other Lezzat team members to...
I'm looking to develop a platform that supports adult live cams. The primary focus of the platform will be private shows, with user access governed by a subscription model. Key Features: - **Private Shows**: The core functionality of the platform lies in the support of private, adult content live shows. The system should allow for easy broadcasting and viewing of these shows, ensuring a seamless experience for both performers and viewers. - **Subscription-Based Access**: Your task will be to integrate a subscription model for users. This means that users will pay a recurring fee for access to these private shows. The system should be able to handle multiple subscription tiers. Ideal Expertise: - **Live Streaming Development**: Experience in devel...
I need financial data from bloomberg or any other database for research.
...process of designing an e-commerce website in Figma and I'm seeking a frontend developer who can transform this design into a fully functional and responsive website. Key Functionalities: - Shopping Cart: A seamless and user-friendly shopping cart integration is crucial for this project. The cart should allow for addition of items, editing of quantities, and a smooth checkout experience. - User Registration and Login: The website should have a user registration and login system. This will help in personalizing user experiences, managing orders, and providing security to customers. - Product Search and Filter: A crucial feature for an e-commerce site. It should enable customers to easily find products they are interested in, through categories, filters, and sea...
one page with about a paragraph of text (Single page)
...can create an application that allows for seamless remote control of ventilation systems. The ability to work across multiple platforms is essential as the application needs to be compatible with iOS and Android devices, as well as Windows computers. Primary Features: - Timer scheduling - Remote control of ventilation systems - Monitoring parameters including temperature, humidity, twilight, and weather - Real-time notifications and alerts - Scheduling system actions - Support for multiple users simultaneously Given the sensitive nature of the data and operations, the application must be secure. Your work will involve implementing advanced encryption to safeguard our communications and data. The ideal candidate for this project should ...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
... PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with...
...Analysis to transform temperature readings into a frequency/bpm output. This project is intended for a research project I am undertaking. I am looking to see if FFT/Wavelets are able to produce acurate bpm readings so there is not definitive method to follow which is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generating the output in R code. Maximum budget for this pr...
I'm in search of an experienced and creative detective story writer. I'm keen on a mystery genre with a narrative that unfolds from multiple perspectives. The story must include: - Unexpected plot twists to keep readers engaged - Detailed environment description that appeals to the senses and begs readers to explore more - In-depth character development that makes readers emotionally invested Expertise in writing multi-dimensional characters and masterful world-building is a must. Proven history of captivating plot creation is a bonus. Please include writing samples, particularly those showcasing your ability to interweave plot twists and rich environment depiction. Your work should demonstrate mastery in sustaining suspense and develop...
I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry
Input data dari laporan keuangan perusahaan ke excel (Balance sheet, laba rugi, cashflow). Cari beberapa data penting dari laporan tahunan perusahaan dan dimasukkan ke excel. Buatkan excel dan grafik dari data yang diinput dalam format yang menarik dan informatif untuk dibaca.
...according to my given instructions. PROCEDURE: I will send you trimmed video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDEO. REPLY ...
...developer, proficient with , to manage two key aspects of a project. Key Responsibilities: - **Database Design and Implementation**: Your primary task will be to design and implement a database system. I prefer PostgreSQL, so experience with this DBMS is a must. - **API Development and Integration**: The project requires a complex API development and integration task. You should be comfortable dealing with multiple endpoints and third-party integrations. Ideal Candidate: - Proficient in Backend Node.js development with a focus on - Prior experience in designing and implementing PostgreSQL databases - Proven expertise in developing complex APIs with multiple endpoints and third-party integrations - Strong problem-solving skills and attention to de...
...designer to create a bespoke logo for a website, as well as for other uses. Your design should bring to life my brand’s unique identity and vision. Here are some key points about the project: The business is in Alice Springs so logo with outback and aboriginal feeling Please see the attached file for one logo i really like - Purpose: The logo should encapsulate our brand identity and visually enhance our website. In addition to the website, the logo may be used for different functionalities, which underscores the need for a versatile and scalable design. - Skills and Experience: Prior experience in logo design is essential. Please include examples of your past work in your application to demonstrate your competence and creativity. Experienc...
...for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrat...
I need an experienced developer to fix current issues with my ansible code. Facing two primary challenges: 1. Connectivity issues: My ansible code fails to establish a steady connection during its runtime. 2. CMDB Retrieval Issue: There's a problem retrieving data from the Configuration Management Database (CMDB). The data is being accessed directly from the CMDB rather than through any API. Ideal Skills - In-depth understanding of ansible code - Experience with CMDB - Knowledge in data retrieval procedures Please note there are no specific authentication or permissions involved. All the data access is being done using direct file access. Your task would be to streamline this process and solve the ...
I need an experienced video editor to regularly produce high-quality and engaging video content for my social media channels, including LinkedIn, Online courses, website and Only Fans (If you are not comfortable with male nudity or medical procedures, this is not for you) We have multiple businesses and multiple channels: - One is a day spa - One is an injectables clinic - One is a penis Enlargement Medical Clinic - We will provide: Footage - Broken down in Dropbox folders Guidelines - As per Australian medical guidelines Ideas - List of ongoing topic ideas - Video Editing Needs: I require advanced video editing services, focusing on tasks like color correction and incorporating some special effects. Slight background music and some subtitles....
...skilled Senior Python Developer to assist with a project that involves a blend of web scraping and data analysis, with a focus on the following tasks: - Extracting data from multiple websites - Automating data extraction and parsing - Analyzing and visualizing scraped data The ideal candidate should have: - Proficiency in Python, with a strong understanding of AI and Machine Learning - Hands-on experience with web scraping, particularly working with diverse data sources - Ability to automate data extraction and processing efficiently - Adept at data analysis, with the ability to visualize and interpret data Although I haven't specified any particular tools or libraries, your familiarity wit...
I need a graphic designer who can handle multiple design tasks. Key Responsibilities: - Photo Editing: Enhancing and retouching images for both web and print. - Logo Design: Creating unique and professional logos. - Video Editing: Editing and enhancing video content for various platforms. There are no specific style requirements provided, so the ideal candidate should be versatile and able to adapt to different aesthetics. Please note that the specific requirements for the design tasks, such as color schemes, typography, and image resolution, will be communicated to you on a project-to-project basis. Skills and Experience: - Proficiency in Adobe Creative Suite (Photoshop, Illustrator, Premiere Pro). - Proven experience in photo editing, logo design...
...design and impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other forms of communication. - Survey results will then collate ...
I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.
...media manager to push my online presence on multiple platforms, making my brand more visible, generating leads, and forging stronger connections with our audience. The platforms to be managed include Facebook, Instagram, Pinterest, Youtube, and LinkedIn. Operating as much more than just a 'poster of content', the ideal candidate will also: - Create unique and engaging content that resonates with our audience. - Foster an active and engaged community, responding to comments, and driving discussions. - Provide analytics and reporting to monitor the success and reach of different content types and campaigns. The ultimate goal of this project is to generate leads. Therefore, special consideration will be given to those with a prov...
I need a talented artist to create multiple political cartoons for a book I'm compiling. Your work must revolve around: - Political figures - Social issues - Satire These cartoons need to be impactful and carry a strong message related to the above themes. It's essential that you have a good understanding of how to use humor and satire to convey political and social commentary. Cartoons will be reproduced as: - Digital images - Printed illustrations I'm looking for a variety of styles – some cartoons should be in color, others in black and white. Ideal Skills: - Proficient in creating political cartoons - Comfortable with satire and humor as mediums to depict social commentary - Able to deliver in bo...
...of processing data from around 30,000 products across 5-10 different stores. Key Requirements: - Cross-reference 30,000 products from 5-10 stores: The tool should be able to analyze and compare prices for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The comparison results should be integrated and displayed on the corresponding product pages. Or through a widget function. Project Scope: - Estimated 3,000 to 8,...
I need a web developer to implement a fundraising tool into my Shopify site that will track product sales of multiple teams. This tool should conveniently reside on the same platform as my Shopify site and include a user-friendly dashboard with comprehensive sales data. Key Features: - Monitor sales from multiple teams at the same time, similar to the setup on Poppinpopcornonline.com. - User dashboard should display various metrics: * Total sales per team * Highest selling products per team * Breakdown of individual contributions per team and top three highest sellers * Top selling products for each team member * Ability for the individual team member to share their link via email and social media Ideal Candidate: - Pro...
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures
