Maximum record excel vbaงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm looking for a skilled English-speaking host or speaker for my social gatherings. The ideal candidate should be able to captivate and engage the audience throughout the event. Key Requirements: - Hosting experience: I need someone with a proven track record of hosting successful events. - Excellent English: Since the event is language-focused, the host should have a strong command of the English language. - Charismatic and engaging: The right person for this job should be able to keep the audience entertained and interested in the event. - Punctuality: It's crucial that the host is punctual and can manage the flow of the event smoothly. If you have experience in hosting social gatherings, excellent English skills, and a knack for engaging audiences, I'd love ...
German Recording project We have a project, that needs Native German speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 8$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
I'm looking for an expert to help manage and promote my Etsy shop. Key Tasks: - I need to list products in my shop, particularly those within jewelry, home decor and art...than 50 listings on my shop, so there’s a scope for expanding the product range. - I am looking for a professional who can devise a sales-driven strategy to enhance visibility and attract potential buyers. -i want someone who can build google my business profile and manage the same. Ideal Skills and Experience: - Proficiency in Etsy shop & google my business management and promotion. - A track record of increasing sales for similar businesses. - Familiarity with jewellery, home decor, and art & craft supplies markets. Please include in your proposal your approach to promoting my products...
France French Recording Project We have a project, that needs Native France French speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
...webpages. Key Tasks: - Implement GSAP animations on the landing page, product pages, and the About Us section of our website. - Utilize GSAP to bring dynamic, engaging visual elements to the forefront, making the website more interactive and appealing. Ideal Freelancer: - Extensive experience with GSAP Javascript, particularly in implementing scroll, morphing, and SVG animations. - Proven track record of enhancing the visual appeal of websites. - Strong front-end development skills to ensure seamless integration of the GSAP animations with the existing design and functionality. - The ability to commit to a long-term collaboration and deliver high-quality results consistently. Your role will be critical in transforming our website into a visually striking and engaging platform ...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
I'm seeking a proficient 3D modeler with extensive knowledge in AutoCAD software. Your task will be to create a high-detail 3D model of mechanical parts. Expectations: - Use Aut...with extensive knowledge in AutoCAD software. Your task will be to create a high-detail 3D model of mechanical parts. Expectations: - Use AutoCAD for all modeling tasks - Model will comprise complex mechanical parts - Provide high-level detail for all aspects of the model Ideal Skills: - Competency in AutoCAD software - Experience in modeling mechanical parts - Attention to detail - Proven track record in producing high detail 3D models Please attach your previous work samples which align with these requirements for consideration. I look forward to working with a skilled individual who takes preci...
I'm looking for a talented graphic designer to rework my current brand logo, specifically the symbol or icon component. The objective is to generate the same image, but it should be delivered in a large image size suitable for printing. Skills and Experience: - Proven track record in logo design - Excellent knowledge in working with high resolution imagery - Strong attention to detail - Proficiency in major design software, like Adobe Illustrator or CorelDraw
I'm looking for a full-time developer with extensive experience in and Flutterflow to join my agency. The main goal of the projects we'll get is to create a functional web application. The projects will involve tasks like setting up user authentication and registration, integrating databases, API integrations and more. Ideal candidates should have: - Proven track record of developing web applications with and Flutterflow - Strong experience with Full Stack Development (MERN, MEAN, etc), Mobile development (Flutter) and development cycles. - Ability to work full-time and meet deadlines. - Strong communication skills. - certification highly desirable. Salary: $500/month (for intermediate), up to $800/month (for seniors) based on experience, with bonuses on performance...
Looking for a skilled web designer and developer to work full time on our customers websites. Your primary responsibilities will include graphic design, HTML/CSS coding, JavaScript and Bootstrap p...Responsibilities: - Develop and maintain websites using HTML, CSS, JavaScript and Bootstrap using our proprietary CMS. - Implement interactive features and dynamic content using JavaScript. - Optimize images for fast loading. Must be strong in responsive design using CSS media queries. Skills and Experience: - Proficiency in Graphic Design software. - Strong experience in HTML/CSS. - Proven track record in JavaScript programming. - Ability to work creatively and proficiently. - Excellent communication and collaboration skills. - Strong Spanish and English speaking and writ...
I'm in need of a logo that can effectively represent my brand, ABC Company. The goal is to create a visual image that helps customers instantly recognize and remember my company. Ideal Skills and Experience: - Proven track record in logo design - Understanding of branding principles - Creativity and originality in design - Ability to translate a brand's mission and values into a visual representation - Strong communication skills to ensure the final design aligns with my brand's identity.
...customer acquisition. Key Responsibilities: - Devise strategies to attract hotels as our customers - Understand the unique selling propositions of our products - Build rapport and long-term relationships with hotel clients - Develop a strong understanding of the hotel industry's needs and demands - Provide innovative and result-driven sales strategies Ideal Skills and Experience: - Proven track record in sales within the hotel industry, particularly with targeting hotels in India - Strong understanding of customer acquisition in the hotel business - Well-versed in the mechanics of the hotel industry on a sales level - Exceptional communication and negotiation skills - Experience in building and maintaining client relationships in the hotel sector This role requires a sa...
(Business Development Executive) (with good track record) + Must have strong Sales Managerial Experience in any B2B SaaS company OR been as a Sales Partner. + Experience in dealing with B2B + USA Market + Must be interested in taking on new challenges. + Should have hands-on experience. + Only Freelancers are Allowed (No Agencies or No Companies)
I'm seeking a dynamic professional to skilfully manage my Inst...with my business promotion needs. Ideally, you have experience in generating captivating construction-related content. Responsibilities: * Designing and crafting enticing promotional content linked to the construction industry. * Strategically scheduling posts to maximize audience reach and engagement. Required Skills and Experience: * Proficiency in content creation and post scheduling. * Track record in managing business-oriented Instagram accounts. * Deep understanding of audience engagement strategies. * Construction industry knowledge or experience is a great plus. The main aim is to leverage Instagram as a platform to effectively promote my business while resonating with my target audience. Are you up for...
...Responsibilities: - Building backlinks from 40+ DA PA sites: You will be responsible for creating high-quality backlinks from reputable websites in the finance industry. - Ensuring global reach: The backlinks must be strategically placed in a manner that enhances my website's visibility on a global scale. Ideal Candidate: - Proven experience in SEO and backlink building: You should have a track record of successful backlink campaigns that have led to improved search engine rankings. - Strong understanding of the finance industry: Knowledge of the finance sector will be advantageous in selecting the most relevant websites for backlinking. - Creative and strategic thinker: The ability to think outside the box and develop a comprehensive backlink strategy is crucial for this...
I'm in need of a Shopify expert to create a modern, minimalist theme for my store. The ideal candidate should be able to bring my specific design con...ensuring the design is clean, appealing, and optimized for conversion. Key project requirements include: - Create a modern and minimalist theme - Ensure the theme is optimized for product sales - Implement the specific design concept I have in mind I'm looking for a freelancer with a strong background in Shopify theme design, a keen eye for modern and minimalist aesthetics, and a proven track record of creating themes that drive sales. Experience with UI/UX design and e-commerce best practices is a plus. Your design should not only be visually appealing but should also prioritize ease of use and a seamless shopping exper...
I'm in ne...user-friendly informational website. This site should be designed to encourage visitors to reach out for personalized travel plans. - **Content Writing**: The content you create should be both informative and detailed. It should provide valuable information to potential customers, encouraging them to engage with our services. Ideal skills and experience for this project include: - Proven track record in web development, particularly in creating informational websites - Excellent content writing skills, with a flair for detail and informative writing - Experience in the travel industry would be a plus, but not a necessity Ultimately, my goal is to have a professional, engaging website that showcases my travel business and entices visitors to reach out for tailore...
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.
I require an experienced Linux developer with a solid background in server administration, particularly security and firewall configuration. The primary focus is on enhancing system stability through secure server management. Key tasks and skills: - Server Administration: You should be proficient in maintaini...optimizing Linux servers. - Security Management: Understanding of security principles and best practices is essential. - Firewall Configuration: Expertise in firewall management and configuration. - Problem-solving: Ability to troubleshoot and resolve issues to ensure system stability. Please note that this is a long-term project, so commitment and reliability are important. If you have a proven track record in server security and Linux system management, I'd like to...
I'm looking for a skilled professional to help write a research blog on Artificial Intelligence (AI) and create an accompanying infographic. Ideal Skills and Experience: - Proven track record in writing engaging blog posts related to technology, specifically AI - Excellent graphic design skills to create a visually appealing and informative infographic - Familiarity with creating content for a tech-savvy audience The blog should be well-researched, informative, engaging, and easy to understand for a tech-savvy audience. The infographic should visually represent the key insights from the blog in a concise and clear manner. Please include any relevant samples of your previous work in your bid.
I'm looking for a talented web developer to create a website similar to Tottaa.com. The platform will primarily serve as a classified ads site, allowing users to list products, search for items, and register/login. Key Features:...management. - Blog Admin: Capability for an admin to manage and update the site's blog. Ideal Skills: - Proficient in full-stack development - Experience with e-commerce and classified ads platforms - Knowledge of user authentication and authorization - Familiarity with search functionality integration - Prior experience in building admin panels If you're confident in your skills and have a track record of developing similar projects, I'd love to discuss this opportunity further with you. Please include your portfolio and previous e...
I'm looking for a Laravel expert to help me integrate my POS system with my existing website. No live tracking, no location or other. Maximum 2-3 days task Key deliverables of this project include: - Seamless integration of the POS system with the website. Order from website goes to POS. - Website order in POS to POS print receipt screen. - Website: Multiple login (Google, Facebook) - Website: Eway payment sandbox integrated but also want to save payment details. - Website: The website only provides delivery option. Add pickup option also. Please include relevant examples of your previous work in your bid. Budget maximum: 150 USD
I'm seeking an expert in designing and prototyping to help bring my innovative concept in the field of industrial...- Prototyping: The next step will be developing a prototype. The ideal candidate will have experience in taking designs through to this stage, and will be able to advise on the most effective and efficient way to do this. The freelancer most suitable for this job will have experience in: - Industrial or electronics design and prototyping: It is essential that this individual has a strong track record of success in designing and prototyping in these fields. - Problem-solving: The product is intended to solve an industry-wide issue, so experience in problem-solving in this context would be highly beneficial. This is a potentially ground-breaking project for the r...
...Responsibilities: - Manage all aspects of this half-day event, ensuring seamless execution from start to finish. - Work closely with our team to develop a clear agenda and select top-quality speakers. - Take charge of marketing, ticket sales, and audience engagement. - Ensure all technical and logistical aspects of the event are meticulously planned and implemented. Skills and Experience: - Proven track record in event management, ideally with a focus on educational events. - Strong organizational and time-management skills. - Excellent communication and negotiation abilities. - Familiarity with PropTech is a big plus. - Prior experience in managing events with less than 100 attendees would be advantageous. I'm looking for someone who can bring a proactive and innovative a...
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
...trades based on the parameters of the strategy. - Backtesting and optimisation capabilities: The ideal developer will need to optimise and backtest the developed cBot across 6 instruments that I trade and modify the cBot if necessary to ensure first time success with trading forex pro firm challenges particularly as regards minimising draw down. The ideal candidate should have a proven track record in developing trading algorithms, particularly on the cTrader platform, and a solid understanding of Renko charting. A developer with experience in implementing custom indicators and functions in cTrader would be highly preferred. Solid optimisation and backtesting skills on cTrader is a must. Strong communication skills to ensure my needs are met throughout the project is also requ...
...aesthetically pleasing. - Poor User Experience: The existing design is not user-friendly, and it's affecting the overall functionality of the site. The redesign should focus on improving navigation and user interaction. Desired Color Scheme: - The new design should be bright and vibrant. This will help create a more visually appealing and engaging website. Ideal Skills and Experience: - Proven track record in redesigning WordPress websites - Strong understanding of user experience and design principles - Experience in creating visually appealing and engaging websites - Proficiency in working with color schemes and layouts If you have a portfolio that showcases your website redesign projects, please include it in your bid. Your creativity, expertise, and ability to deliver...
...their vicinity. - Menu and Item Selection: The platform should support detailed menu listings and an intuitive item selection process for users. Payment System: - The platform should support multiple payment options including: - Cash on Delivery - Online Payment (credit/debit card, net banking) - Wallet Payments The ideal candidate/team for this project should have a proven track record in developing similar platforms and should be proficient in backend and frontend development. Strong knowledge of payment gateway integration and security protocols is highly desirable. While the client did not specify a preferred technology stack, your proposal should include your recommended tech stack and the rationale behind it. The client is open to suggestions and is looking ...
...This could involve improving the visibility of the videos, analyzing and improving the retention rate, and promoting the content across various platforms. - Enhancing engagement: Engagement is crucial for the growth of the channel. Your responsibility would be to encourage and maintain a high level of engagement with the viewers to keep them coming back for more. Ideal Candidate: - Proven track record: I'm looking for someone with a successful history of growing YouTube channels, specifically in increasing subscribers, views, and engagement. - YouTube SEO knowledge: A good understanding of YouTube's algorithms and best practices is key. - Creativity: Thinking outside the box and coming up with innovative strategies for growth is highly valued. - Communication skills: T...
I own an event hall in India, particularly a marriage hall. Currently, it is the off-season, and I am seeking a digital marketing specialist who can devise and implement a robust strategy to attract clients throughout the year. Key Responsibilities: - Plan and implement a comprehensive digital marketing stra...leading and managing SEO and social media. - Experience in crafting and implementing successful marketing campaigns. - Excellent analytical and project management skills. - Strong understanding of current online marketing concepts, strategy, and best practices. - Ability to work under pressure and meet deadlines. Please note that this is a long-term project, and I'm looking for someone with a track record of delivering results, ideally in the hospitality or event manag...
