Convert multiple rows to columns in excel macroงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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 )
...developer to join our team and help develop a smart contract for a wallet application. The ideal candidate should have experience with Tron blockchain development and be familiar with BIP 39 or BIP 44 for address generation. Responsibilities: 1) Develop a smart contract on the Tron blockchain for a wallet application. 2) Implement functionality for address generation using BIP 39 or BIP 44. 3) Ensure that fees for all wallet transactions, including sending TRX or any ERC10 or ERC20 tokens, are deducted from a specified multiple accounts assigned in the smart contract, and not from user. 4) Also user need to pay the fees to the contract as an escrow, i.e. user will not pay the transaction fee, the transaction fee will be paid by the assigned accounts...
I need a skilled developer to create a robust e-commerce website that caters to my business needs and has the ability to scale as my business grows. Key Features: - E-commerce Focus: The primary goal of this project is to create a fully functional e-commerce platform. - Payment Integration: I'm looking to integrate credit card and cryptocurrency payment options. These should be secure, reliable, and user-friendly. - Scalability: The website should be designed to accommodate a growing product base. Although the exact number of products isn't defined, the website should be built with the potential for a large inventory. Ideal Skills and Experience: - Proven track record in building e-commerce websites, preferably with scalable fea...
I need a large PDF document converted to a Word file that is fully editable. Requirements: - Convert a 11-50 page PDF to a fully editable Word document for content revisions. - The Word document should be formatted and ready for editing, but does not need to perfectly replicate the original PDF's fonts, colors, and layout. Ideal Candidate: - Proficient in PDF to Word conversion software and techniques. - Strong attention to detail to ensure all content is accurately transferred. - Experience in document formatting to ensure a clean and professional result.
I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.
I'm looking for a professional who can turn a Pine Script Indicator into a Trend ...turn a Pine Script Indicator into a Trend Following Strategy on TradingView. The indicator is written in Pine Script, and the end product should offer clear entry and exit signals based on the indicator's moving averages. Key Deliverables: - Convert the existing Pine Script Indicator to a comprehensive Trend Following Strategy. - The strategy should utilize moving averages as the primary factor for determining entry and exit points. Ideal Skills & Experience: - Proficiency in Pine Script - Strong background in trading strategies, specifically trend following - Experience building and implementing trading strategies on TradingView - Familiarity with moving a...
...talented graphic designer to create a unique logo, which will be primarily used for print materials. Key Responsibilities: - Designing a professional, eye-catching logo that suits the print medium - Incorporating my specific color scheme into the logo Ideal Skills and Experience: - Extensive experience in graphic design, particularly with logos - Strong understanding of color theory and how it applies to print materials - Ability to create visually appealing and memorable designs - Strong portfolio showcasing previous logo designs, particularly those used for print - Good communication skills to understand and incorporate my color scheme, and to provide multiple options if needed. Please include a link to your portfolio when yo...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.
We have a selection of AI images that need to have a transparent background to enable use within our business. Standard removal tools in Photoshop remove too much of the actual image.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Global Sales Opportunity! Do you love food? Do you love sales? We're a Sri Lankan company crafting exquisite Ceylon cinnamon, tea, spices, and coffee – and we're seeking enthusiastic Sales Associates to collaborate with us in finding new wholesale buyers. What you'll do: 1. Find potential wholesale buyers in your region or target markets and build lasting relationships. 2. Discuss product details, ensuring buyers are informed and engaged. We'll provide all necessary resources and documentation to support you. 3. Facilitate seamless communication between buyers and our company. We handle shipping, banking, and cargo, so you can focus on sales. Why join us? 1. Lucrative Commission Structure: Enjoy generous commissions on every sal...
I am creating portfolio of work. is there any way someone can check and convert my work into gif and be creative?
Hi Hossein, I enjoyed our phone call and clearly you know what you are doing. I like your idea of producing a cloned Vue 3 component that received the same input variables as the existing component, that is a _child_ of the existing component. That way you can do the development of the ...enjoyed our phone call and clearly you know what you are doing. I like your idea of producing a cloned Vue 3 component that received the same input variables as the existing component, that is a _child_ of the existing component. That way you can do the development of the new component, without interfering with existing functionality. I would like you to implement this for me in my app as proof-of-principle. I know you are busy with multiple projects so I am flexible on timing...
I'm in need of a skilled web developer to create a web3 crypto sports betting website for me. The site should have the following features: - User registration and login system - Real-time odds for different sports like Football, Basketball, Tennis, and Cricket - Support for multiple cryptocurrencies for betting Additionally, I'd like the site to have the functionality to: - Offer a cash-out option - Seamlessly integrate with social media platforms Ideal candidate should have experience in developing betting websites, be knowledgeable in web3 and cryptocurrency integration, and have a good understanding of the sports betting world. Your design should be user-friendly and secure. Looking forward to your bids.
...looking for a talented native Spanish speaker who is also proficient in editing to join our team. As a Native Spanish Speaker and Editor, you will play a crucial role in ensuring the quality and accuracy of our Spanish language content. We are seeking someone with excellent language skills, attention to detail, and a passion for delivering high-quality work. **Responsibilities:** - Proofreading and editing Spanish language content for grammar, punctuation, spelling, and style consistency. - Ensuring that all content adheres to linguistic standards and guidelines. - Providing feedback and suggestions to writers to improve the quality of their Spanish language content. - Collaborating with the content team to maintain consistency ...
We are looking for a talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required L...
I am in need of a skilled French Canadian translator to convert my short English story into French. The story doesn't contain any specialized terminology or jargon. Key points: - The translation must maintain the essence and tone of the original content. - It should be culturally relevant and appealing to a French Canadian audience. - Attention to detail is crucial to ensure a seamless and professional print publication. Ideal skills and experience: - Proven experience in translation, particularly for print publications. - Native-level fluency in French Canadian. - A good understanding of English and the ability to maintain the original content's essence and tone. - Experience in literary translation would b...
I need help with data entry and formatting for a Go...need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questi...
I'm seeking an experienced WordPress developer to craft an e-commerce website primarily using Easy Digital Downloads. Here's what I'm looking for: - Create an intuitive and seamless e-commerce experience. - Integrate Easy Digital Downloads as the core marketplace plugin. - Set up multiple Indian payment gateways, such as Net Banking, BHIM, GPay, and Phone Pay, ensuring security and ease of use. - Optimize site for performance, scalability, and SEO. Ideal Skills: - Proficiency in WordPress & Easy Digital Downloads - Experience with payment gateway integration - Strong portfolio with e-commerce examples - SEO and performance optimization expertise The successful freelancer will demonstrate a strong understanding of e-commerce strategies, particularl...
Convert my website, , into a PWA - a Progressive Web Application. 1. I want to convert my existing website on PWA 2. Can able to link on footer with any icon or picture, so any one click on that to install in mobile or desktop Example of PWA Wesbite CMS Cs-cart
We have a custom plugin that integrates with a MVNO (mobile phone company) to activate mobile phone plans. Currently there is a bug that at checkout, the plugin charges the CC (reserves the money) and then it should activate a phone line and create a PDF with QrCode and then capture the money but it doesn't activate the phone line or send the pdf. We also want to integrate a few new suppliers via their API so we need new functionalities added to the plugin. -woocommerce plugin FIX - linux management - deploy on linux, create new features - long term maintenance Gitlab version control - create pipeline to our staging server and do version control RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of ...
I'm looking for a skilled iOS developer to create a billing app using SwiftUI and Combine. The Android app's development build will be provided, which includes a screen showing a list of the APIs with details like requests, headers, etc. There are multiple modules in the app, such as Accounts, Customers, Stock, etc. We can set milestones based on these modules. The project is already set up, and some functionalities are already working, including the API layer. The code is very clean and easy for any developer to understand. Further details will be given on a call. We need a productive developer who creates pixel-perfect code. Experience does not matter; you must test the features you create.
I'm looking for a talented developer to create an online examination platform for my educational organization. Here are the main features and requirements: - Support for multiple question types: The system should be able to handle various question types such as multiple choice, true or false, and fill in the blanks. - Extensive subject coverage: The examination will cover more than 10 subjects or topics. - Automatic grading: The platform should have a robust automatic grading feature that can handle all types of questions, not just multiple choice and true or false. The ideal candidate is someone with a strong background in web development and experience in creating online examination systems. The ability to create a ...
...users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design
...company committed to providing high-quality educational cartoon videos for children worldwide. Our mission is to foster learning and development in young minds by delivering engaging content in multiple languages. Currently, we offer educational materials in six languages, including English, Arabic, Pashto, Persian, Urdu, and Dari, with plans to expand to encompass 100 languages in the future. - The main purpose of the site will be to showcase our educational cartoon videos. There won't be nursery and childcare services offered through the website, it's strictly for displaying our work. - Visitors should be able to interact with the site in a way similar to the YouTube Kids platform. Th...
We want to distribute our OpenGL-Based media server software via Linux. Appimage looks like a usable way to deploy on multiple distributions. We target solely x64 architectures. The software uses OpenGL, video capture, audio output and input and connects to IO devices via USB. We already have a working .deb workflow and it would be great if you could create an appimage workflow for us that we can introduce into our deployment.
Convert 2 page brochure from PDF to AI files. Recreate source files from PDF for easy editing. Create a layer from each section. Copy the text from each section. i.e. each image is a layer, each text block is a layer, each text heading is a layer For reference-page1 should contain approximately 19 layers.
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love ...
I have a file sourced from the internet that was originally in a landscape format, but I need it to be converted into a portrait layout for a poster design. I need this new file to be compatible with CorelDRAW without losing any pixel quality. Requirements: - Convert a landscape design to a portrait layout - Ensure the new file is compatible with CorelDRAW - Maintain high quality and pixel resolution throughout the conversion Ideal Skills: - Proficiency in graphics design - Experience with CorelDRAW - Ability to maintain high-quality resolution - Strong understanding of design principles & layout Please let me know your background in graphics design and any similar projects you've worked on.
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared ...
