Excel vba transpose multiple columns into rowsงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ 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
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 freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.
...beautifully designed and should be able to toggle between light and dark modes. I only need the design. This form does not require a database. - The form should be designed to be versatile and multiple types of utility forms - The form should include various fields, including but not limited to Name, Email, Phone number, Address, and Message. - The form should be equipped to handle and incorporate different types of utility forms such as Contact form, Feedback form, Registration form, and Survey form. I will provide you with a mockup of the form; you will be tasked with transforming this concept into a functional form. Most have side admin panel Ideal Skills and Experience: - Proficient in PHP and HTML - Strong background in front-end development and design - Pri...
We are seeking a skilled and versatile Multilingual Translator to join our team. As a Multilingual Translator, you will be responsible for accurately translating a variety of documents and content from English into multiple European languages. This role requires fluency in English and proficiency in at least one European language, with the ability to translate effectively while maintaining the original meaning, tone, and style of the content. Fluency in English and proficiency in at least one European language (e.g., Spanish, French, German, Italian, Portuguese, Dutch, etc.). If you are a talented translator with a passion for languages and cultures, we encourage you to apply for this exciting opportunity to join our dynamic team.
I am looking for a skilled graphic designer to create a unique logo for my brand "ProPuera," which will resonate with the brand ethos of purity across multiple product categories. Key Requirements: - Reflect the brand’s meaning of a 'Product with Purity' in the design. - Create a versatile logo that suits multiple categories including home & kitchen, beauty & skincare, health & wellness, and fashion & accessories. - All final assets must be delivered in multiple formats (JPEG, PNG, EPS, and source Adobe files). Ideal Candidate: - Experience in designing logos for e-commerce businesses. - Strong portfolio demonstrating creativity and versatility. - Proven ability to work collaboratively on feedback and revisions. Please DM ...
...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...
I'm looking to build a website to expand my vending machine business into the online space. The site's main purpose will be e-commerce, aiming to sell our range of product worldwide, with a particular focus on customers in Australia. Key Features: - Showcases our product range: plush toys, bouncing balls, and toy capsules. - User-friendly shopping experience. - Able to process payments in multiple currencies. Ideal Skills & Experience for the Job: - Proven experience building e-commerce websites - Familiarity with international shipping, specifically to Australia - Excellent understanding of user experience design.
pI am looking for an experienced software developer to create a PVC software for me. The core features required are: - PDF data extraction and printing: The software should have the capability to extract both text and images from PDF files and facilitate printing of the same. Proficiency in PDF manipulation tools is highly desired. - Image extraction and pr...The software should fully support localization for all local Indian languages, with specific advantages in Hindi, Tamil, and Bengali. Understanding of the cultural context and linguistic nuances associated with these languages is a bonus. Ideal candidates will have a strong background in software development and previous experience in creating similar software. Knowledge and understanding of multiple Indian local languages ...
...configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, and generating informative tables for efficient processing. Inquiry: Enable users to upload customer lists for comparison with purchase prices, configure margins, and calculate selling prices directly. The module should support export to Excel for conveni...
I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and co...potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and ne...
Needs to hire 20 Freelancers - Translate short small mobile page(s) from English. - Languages Needed: Spanish (Latin America) Spanish (Spain) French Czech German Portuguese (Portugal) Hungarian Ukrainian ndonesian Italian Japanese Arabic (Standard) Korean Romanian Vietnamese Polish Thai Turkish Greek Russian Urdu (Pakistan) - Good translator can become our "go-to" translator for these kind of projects in that language.
...software developer to create a self-ordering kiosk software. This is an urgent requirement and I'd like the project completed as soon as possible. Key Software Features: - Menu Customization: The software needs to enable users to browse through a customized menu and make their selection. - Payment Processing: The software should integrate secure and efficient payment processing features, accepting multiple payment formats. - Order Tracking: Users must be able to track their orders in real-time through the kiosk software. While no particular operating system compatibility was specified, universal compatibility would be preferred. Past experience in developing similar kiosk software would be a significant advantage. A developer with an acute understanding of UX/UI design, p...
...optimization to build quality backlinks and improve domain authority - Regularly monitor and report on the performance of the implemented SEO strategies - Utilize white-hat SEO techniques that align with Google's guidelines - Collaborate with me to ensure that the SEO strategies are aligned with my business goals Ideal Skills and Experience: - Proven track record in managing SEO projects for multiple websites - Proficiency in on-page and off-page SEO practices - Strong understanding of keyword research and implementation - Expertise in traffic analysis and reporting - Familiarity with the Miami, Florida area would be a plus, but not mandatory - Excellent communication and collaboration skills I'm looking for a dedicated partner who can deliver sustainable, long-term r...
I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks
I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making technical functionalit...
I'm looking to create a top-notch e-commerce website that can handle transactions across multiple payment gateways and cater to a global audience. This site should be well-integrated with multiple payment options including Credit card, PayPal, Stripe, UPI, Phone pay, Google pay, Paytm. The site should be developed with a global scale in mind, with the ability to sell to countries such as United States, United Kingdom, Australia, India, and beyond. Key Requirements: - E-commerce Website: You should have a strong background in developing e-commerce sites with extensive experience in integrating multiple payment gateways. - Global Audience: The site should be designed to handle transactions in multiple currencies and be adapted to different countries' ta...
I'm looking for an expert who can effectively drive traffic to my new website and establish...campaigns on TikTok, Google, Instagram, and Facebook. - Setting up analytics and tracking mechanisms on my WordPress site. - Tailoring the content and strategies to attract teenagers, young adults, and parents, my target audience. The ideal freelancer should have: - Proficiency with TikTok, Google, Instagram, and Facebook, as well as WordPress. - Proven experience in driving traffic and engagement on multiple platforms. - Strong analytical skills for tracking and interpreting data. - A good understanding of the specified target audience and how to effectively engage them. - Ability to optimize content and strategies for selling products/services. - Excellent communication and problem-...
I am looking for a skilled virtual assistant to help hunt specific items and promote select services on Facebook marketplace. Key Responsibilities: - Searching for specific items...Promoting select services The ideal candidate should be able to gather and provide me with specific information on the items found as well. This includes: - Price - Location - Condition - Seller Finance - Land contract The selected freelancer will need to have: - Prior experience with Facebook marketplace and an understanding of how it works - Excellent communication skills - The ability to manage multiple tasks simultaneously - Attention to detail is a must. Please include the word "marketplace" in your proposal to show you have read the requirements. Looking forward to working with ...
...converted into a webpage form that 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
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
...conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....
...to identify inefficiencies and areas for improvement. - Implement workflow optimization strategies that enhance project efficiency and reduce time-to-completion. - Integrate multiple systems to ensure seamless data flow and accurate project tracking. Challenges: - Inefficient communication between teams: The current system hampers cross-functional collaboration and slows down project progress. - Manual data entry and duplication: We're struggling with data accuracy issues due to manual entry and duplication. - Lack of automation: The absence of automation is a bottleneck in our current processes. - Poor visibility into project statuses: The lack of real-time visibility is impacting decision-making. - Inaccurate reporting: Our current reporting mechanisms are failing...
I'm in need of a comprehensive, multi-tasking personal assistant AI to support me in a variety of ways. In...sports activities and training regimes. - Calorie Calculations: It's important for me to track my calorie intake, so I'll need you to help me with this. - Heart Rate: Monitoring my heart rate and keeping track of this data. The ideal candidate for this job should have experience in creating and managing AI personal assistants. You should also be proficient in integrating these assistants across multiple platforms, as I will need you to make it compatible with iOS, Android, and web browsers. Your attention to detail and ability to multi-task effectively will be key in this role. I'm looking for someone who can streamline my daily activities and provide ...
I'm in need of an expert in Excel for a project centered around statistical data analysis. Key Requirements: - I require someone able to handle statistical analysis in Excel. - The data is large and will require a high level of accuracy and attention to detail. - Since the data source is not specified, you should be flexible and able to adapt to varying data types. Ideal Skills and Experience: - Proficient in Excel, especially in handling large data sets. - Experience with statistical analysis in Excel. - Previous success in providing accurate data analysis. Please note the source of the data is not explicitly mentioned, so experience with different data types is a plus.
I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.
...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents fro...
I'm in need of a skilled Laravel developer to create a QR scanner-enabled webpage. This webpage should be capable of updat...Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and experience for the job: - Proficiency in Laravel and PHP - Experience with database setup, management and integration with web applications - Knowledge of QR code integration and processing in web applications - Ability to make decisions on how to handle multiple scans of the sam...
I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...
I'm seeking a talented designer to assist with our company rebranding. Here's a brief of what we're after: - A fresh and unique rebranding design concept. - As the company name and specific services weren't stated, we're looking for someone who can provide a wide array of design services or is open to collaboration on multiple fronts. Ideal skills and experience for this project: - Strong experience in branding and rebranding initiatives. - Portfolio demonstrating a broad scope of work in different design streams. - Availability to collaborate and communicate on refining our brand vision. I look forward to seeing how your creativity can benefit our brand transformation.
I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and functional...
