Excel vba fit all columns on one pageงาน
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 ที่กำหนดให้
Fit Junctions เป็นธุรกิจเกี่ยวกับการสอนออกกำลังกาย ได้มีนโยบายการพัฒนา Application และ Website สำหรับใช้ในการเพิ่มประสิทธิภาพในการสอนออกกำลังกายให้กับลูกค้า เป็นฐานข้อมูลหลักของบริษัท รวมถึงอำนวยความสะดวก ในการทำงานร่วมกันระหว่างทีมงาน
ข้อมูลในภาษาไทยจะเป็นไปตาม. YOU MUST BE A NATIVE THAI SPEAKER TO DO THIS JOB!!! NO EXEPTIONS!!! Im looking for someone to complete a SEO on our page: www.d-contact.shop. The page is in pure HTML, so no wordpress plug ins or anything like that. The metatext for google search has already been written in thai. If you deliver good work there might be aditional tasks such as off page SEO. We also have several other pages that needs fixing. ฉันกำลังมองหาคนที่จะทำ SEO บนหน้าของเรา: หน้าอยู่ใน HTML บริสุทธิ์ดังนั้นไม่มีปลั๊กอิน wordpress ins หรืออะไรแบบนั้น มีการเขียน metatext สำหรับการค้นหาของ Google เป็นภาษาไทยแล้ว หากคุณทำงานได้ดีอาจมีงานอื่น ๆ เช่น off page SEO นอกจากนี้เรายังมีหน้าที่อื่น ๆ อีกหลายหน้าที่ต้องการแก้ไข
Hi All, Our client is opening a new manpower agency focused on providing organizations like bars, clubs, tourist attractions, theme parks and government offices, concerts special protection staff. This company is being setup in Bangkok because of a huge market in Thailand. My client will provide manpower services for all clients with a very low and competitive pricing. They are in the process of setting up a very big corporation in Bangkok. We are currently seeking freshers or low experienced people or freelancers either male or female with a good knowledge of the local areas within Pattaya and are willing to support our clients with their security requests on time and in an economical way. This will be the launch of the testing phase of the firm. WE WANT TO REC...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I want translate English to Japanese 1 page within 1 hr.
I'm looking for a skilled Flutter developer to transform my custom UI design into a functional page within my educational application. Key project details: - The UI is specifically tailored for educational content, particularly course listings. - I'll require the course listings to be displayed uniquely, including incorporating course levels. Ideal skills and experience: - Proficient in Flutter development, with a strong portfolio of successful projects. - Prior experience with educational app design will be a big plus. - Ability to create custom UI elements and layouts. - Good understanding of user experience principles, particularly in educational contexts. - Strong communication skills to understand and implement my specific design requirements.
...deductions, and tax withholdings. Integration or Custom Built: - I am not sure whether I prefer a custom built HRMS or integration with an existing platform. I am open to suggestions and recommendations from the freelancer based on their expertise and experience. Skills and Experience: - Experience in developing and implementing payroll systems for existing businesses. - Knowledge of HRMS best practices and compliance regulations. - Proficiency in relevant programming languages and frameworks for HRMS development. - Ability to provide recommendations and guidance on the best approach for the HRMS project....
... Key Elements: - You'll be working with text content and images. No videos will be required for this project. - A design for the homepage is already in place. Your task will be to bring it to life, while adhering to our company branding. Customization Level: - The level of customization required is moderate. This includes adjusting layout and design elements to fit our pre-determined theme. Your Role: - As the primary coder on this project, your role will be to take my guidance and implement it effectively. Your prior experience in developing similar e-Learning platforms will be highly beneficial. Ideal Skills and Experience: - Extensive experience in Wordpress development, particularly in customizing homepages. - Strong understanding of e-Learning site design pri...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
...focusing specifically on the crotch area. KEY RESPONSIBILITIES: * Subtly smoothing out bunching caused by excess fabric * Adjusting the fit of the jeans for a more streamlined, natural look * Dutifully preserving the overall originality of the jean’s look in the editing process IDEAL SKILLS AND EXPERIENCE: *Proven proficiency in digital image editing, especially related to fashion products *Strong awareness of natural skin and fabric textures to maintain realism *Adept at working with both the color and shape facets of complex images *Exceptional attention to detail and understanding of modern fashion aesthetics The ultimate goal is to create images that put the product in the best possible light, enhancing its attractiveness without losing its authentic feel. I...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and effic...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I need a freelancer to replace the audio on one video, each approx 1.5 minutes in length. The replacement audio being provided will be in Mp4 format. Specific requirements are: Specific changes requested. - Familiarity with video editing software is essential - Should have experience working with Mp4 video and audio files - Demonstrable history of audio replacement or enhancement work in videos - Ideal candidates will be able to complete the task swiftly and flawlessly Note: The original purpose of the audio replacement (e.g., enhanced audio quality, new narration, removal of background noise) has not been specified. Therefore, the goal is merely to substitute the existing audio with the provided replacement.
As a property management business, we aim to attract new clientele through our new website. It should highlight the following services we offer: - Property Maintenance - Rental Management - Financial Management We specialize in residential properties, so the website should mainly cater to this market. The ideal freelancer for this job would have solid experience in web development and an understanding of real estate or property management. Not only do we need a visually compelling website but also functionality that effectively communicates our services to potential clients. Attention to detail, an eye for design, and understanding of SEO principles are also vital for this project.
I am currently having issues updating my pages with Elementor, and I'm not receiving any error messages. Additionally, I've noticed that my website's performance is slow and could benefit from more memory. Key Requirements: - Troubleshoot and resolve the issue of Elementor not updating pages without error messages. - Optimize the website's performance to improve its speed. Ideal Skills and Experience: - Proficient in WordPress and Elementor. - Experience in troubleshooting and resolving plugin compatibility issues. - Demonstrable experience in website optimization for speed and performance enhancement. Your bid should address these points specifically. Please provide examples of similar work you've completed in the past.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I am looking for an experienced developer to create a user-friendly web application. Users will upload two images: a headsh...realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The final image should be a natural looking photo of the person i...
...lasts 5-10 seconds. I need a simple .jpg image to be inserted into that segment. The image may need to be modified to fit properly. Key Points: - The green segment in my MP4 movie is 5-10 seconds long. - The .jpg image that needs to be inserted is simple with minimal detail. - There is no need for any animation effects on the .jpg image within the video. Ideal Skills and Experience: - Video Editing: You should have expertise in video editing and specifically in working with green screen technology. - Image Editing: A good understanding of image editing is required to ensure the .jpg fits well into the green segment. - Attention to Detail: As the image needs to be modified to fit properly, attention to detail is key. - Communication: Clear communication during thi...
...provide inspiration and not simply be copied. The elements must to fit together to make a cohensive looking logo. Key requirements: - Minimalist design with a modern, fresh and professional feel on white/transparent background. - Incorproating 4 elements: 1. Bottom of logo: a representation of hands (see 1 in image file). 2. Middle of logo: a water drop with a leaf inside (similar to 2 in image file) or something similar 3. Top of logo: an element which signifies technology or deep thinking. 4. includes the name “AgroNovare” being creative with the text (for example you see the triangle between the “o” and “a” in 2 (see 4 in the attached). - Color scheme should be block (not gradiated) deep green and navy blue on...
I'm in need of a skilled designer to create a high-converting landing page. Initially, I'll need one landing page to assess the quality of your work. If it meets my expectations, this will be an ongoing project with a new landing page needed every week. Key requirements: - Design a single, high-quality landing page that is optimized to generate leads. - Be able to deliver consistently on a weekly basis. - Understand the principles of user experience (UX) and design a page that maximizes conversions. Ideal freelancer: - Proficient in landing page design, particularly for lead generation. - Capable of delivering high-quality work on a weekly basis. - Experience with UX/UI design and conversion rate optimization is a p...
we need to made a web page. customer open by qr code the web page and they need to choose one language ( italian,france,spain). when click in one language by link they go to another web site. example. qrcode link. click on language france will be open (already existing)
...is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, profiles, connections, gas pipes, equipment or elements that may present interference in case of reinforcement. The information must be presented in a 3D model, in Navisworks or Revit format, where all the survey information is located. The collection of information should be done wi...
I meant to erase one page and save it but I erased all of it and saved it. It still says 15KB. Also see attachment. The file name at the bottom is it.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...content to match the music. The lyrics produced must be clean and suitable for audiences aged 18 and above. **Key Responsibilities:** - Develop and implement an AI system capable of generating music lyrics based on uploaded instrumentals. - Ensure the AI-generated lyrics are clean, appropriate for all audiences, and align with the given instrumental. - Collaborate with our music and tech teams to refine and enhance the AI’s capabilities. - Integrate the AI system into our existing platform for seamless user experience. - Continuously monitor and improve the AI’s performance based on user feedback and advancements in AI technology. **Requirements:** - Proven experience in AI development, particularly in natural language processing (NLP) and machine lear...
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to...
...consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zoho One and ERP integrations but also have a deep understanding of business processes, data management, and system admin work. Proficiency in managing user access and associated entity relationship is a plus. This endeavor aims to create a seamless workflow between Zoho and our ERP system, making data-driven strategic decision-making easier for us. The expert's ability to co...
I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.
...for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able t...
I am in need of a content creator capable of creating educational videos suitable for all age groups - children, teenagers, and adults. Your task will primarily focus on: - Making clear, informative and engaging educational videos that captivate the viewers. - Ensuring the content is suitable and understandable for all age groups. The ideal freelancer for this job would have previous experience in graphic design, video production, along with a knack for aesthetics and appealing to masses. Your portfolio showcasing previous related projects will be highly appreciated. Please state in your bid how you can best fit this project's requirements.
I'm in need of a talented graphic designer to create labels for 10 modern-style spice products. The labels will predominantly feature the nutritional information of the spices and should be designed to fit pouch packaging. Key Requirements: - Design Style: Modern - The labels should be reflective of contemporary design trends, with a clean and professional look. - Content: Nutritional Information - It is crucial that the labels include nutritional information of the spices. - Packaging: Pouches - The labels should be designed to fit pouch packaging, so understanding the dimension and layout constraints of pouches will be essential. Ideal Skills: - Graphic Design: A proven track record in graphic design, with a portfolio that showcases your skills in creating modern, c...
