Excel vba save workbook in specific folderงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm in need of a skilled programmer who is proficient in PHP and WordPress. The specific task I have on hand is integrating an API into my WordPress website. I'm looking for an individual with the right mix of expertise and experience to help me achieve this. Please make sure you have the following skills before applying: - Proficiency in PHP - Previous experience with WordPress - Experience in API integration If you think you have what it takes, please apply and provide details of your relevant experience.
I'm after a unique and eye-catching font design for my upcoming album release. The font needs to be of a Chrome style, with a m...font should resemble a sleek, polished chrome surface, ensuring it stands out and fits the theme of the album. - Metallic Silver Color Scheme: The font should be colored in a metallic silver shade, adding to the chrome-like feel and ensuring it's visually striking. - Bold Mood: The font should evoke a bold mood, reflecting the powerful and impactful emotions conveyed in my music. Ideal skills and experience for this project: - Graphic design with a focus on typography - Proficiency in using font creation/editing software - Experience in creating stylized and unique font designs - Ability to understand and translate a ...
...coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to understand that the scope of the project is conversion and compatibility, rather than development or adjustment of any specific function. Therefore, a strong understanding of technic...
I need a word background editor for my CV and cover letter that's creative and understands a chef's profession. She/He must comply with this video tips: This tool must have: - Customiz...tips: This tool must have: - Customizable templates for versatility. - The ability to alter font and color options. - Image insertion functionality to make visually engaging documents. The editor needs to work well with Microsoft Word and other word processing software. Ideally, it will offer designs specific to the culinary profession, creating a bold but professional impression of a head chef. Skills in graphic design and software development are preferred. Expertise or understanding of culinary aesthetics is a bonus.
I'm in need of an experienced freelancer to assist me with mapping my Shopify products which exist on Baselinker software to relevant marketplaces. The primary goal of this project is to improve inventory management. Your tasks will include: - Setting up the mapping of my Shopify Baselinker products on various marketplaces. - Ensuring that all of my products are correctly synced and organized - Assisting in customizing the inventory management system to fit my specific needs Ideal skills and experience for this project include: - Prior experience with Baselinker software and its marketplace mapping capabilities - Strong understanding of Shopify and its inventory management system - Proven track record of managing large inventories through software systems I...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the E...
I'm looking for an experienced SEO freelancer who can help in building quality backlinks. Key Requirements: - SEO Expertise: You should have a proven track record in SEO. - Backlink Building: You should be able to build backlinks using only the "Anchor Text". - Domain Authority: The websites the backlinks are sourced from should have a Domain Authority of 20 or higher. Please note that the target search engines and audience for this campaign are not specified. You can suggest specific websites/industries, but the decision-making will be open to discussion.
...to measure the specific gravity of lead acid batteries. This will serve as a crucial tool to check the health of various batteries in real-time, ensuring they're operating effectively and do not pose a risk of failure due to overcharging or undercharging. Key Features: - The hydrometer should have a standard accuracy of ±0.01. This level of precision is essential to correctly assess the battery health and predict any potential issues. - The data collected from the hydrometer needs to be available through a web interface. This online access will allow me to monitor multiple batteries from a central location, offering more convenience and control. Ideal Skills and Experience: - Experience in designing and developing electronic hydrometers or similar IoT ...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity....
I am looking to create a site similar to , ...website. This will involve creating a system where users can customize their profiles. - Uploaded Video Monetization: In addition to the standard features of user profile customization, I am looking to include a feature where users can monetize their uploaded videos. - Payment Statements: It is essential that the platform generates payment statements for users. Ideal Skills and Experience: - Proficient in web development and design - Familiarity with video streaming platforms - Experience in user management systems - Past projects involving monetization features are a plus. Note: The project will revolve around the specific aspects mentioned above. If you have experience in this domain, I'd like to ...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input f...
In the pursuit of the perfect label for my cosmetics product, I'm in need of an exceptional freelance designer with a flair for typographic artistry. Ideal Candidate: - Expert in creating visually appealing and luxurious typography. - Background in graphic design, specialising in product labels. - Strong understanding of aesthetic details on cosmetic labels. - Ability to understand and implement specific design elements provided. Project Specifics: - I have particular design elements that I want to be incorporated, specifically luxurious typography. - Open to your creative suggestions on how to best enhance these elements. - Final design should not only be attractive but also align with the high-end positioning of our cosmetic product. Th...
I'm currently in pursuit of a talented graphic designer to create an engaging cover for my non-fiction book. The ideal candidate will have strong creative abilities, a deep understanding of marketing principles, and substantial experience in book design. Key Responsibilities and Requirements: - Develop an innovative, appealing cover based on your expertise, as I didn't specify a certain style or specific elements to be included on the cover. - Have a strong portfolio demonstrating ability to create compelling covers for non-fiction books. - Proficiency in graphic design software. - Excellent communication skills, as we'll need continual collaboration. Looking forward to seeing your proposed designs and vision for my book cover.
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I am seeking a proficient Pine Script specialist with a proven track record in creating high-accuracy indicators for TradingView. The goal is to produce an indicator that can deliver buy and sell signals with exceptional precision, particularly when applied to short timeframes ranging from 1 to 5 minutes. Key Requirements: - Development of a Pine Script Indicator: The main task is to design an indicator that generates both buy and sell signals. The accuracy of these signals is crucial, and they should be specifically tailored for the 1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable tool. -...
Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.
Please read everything before starting. If you submit junk it will be rejected so please only quality work. The company: This is a 3d printing company that focuses on t...read everything before starting. If you submit junk it will be rejected so please only quality work. The company: This is a 3d printing company that focuses on taking old blow molds that are not made any more and remaking smaller sizes of them based off of old christmas decor. The name of the company: Yule-Glo Colors can be: Red, Green, Yellow PLEASE KEEP IN MIND, I want a old classical look, maybe a old christmas light bulb in there, I want classic, not modern. I will attach some of the images of these classics that we are making for inspo and feel free to incorporate a graphic of them or like a digi...
I'm in need of a specially developed Stream Deck plugin, tailored to capturing and instantaneously replaying in-game voice clips. This plugin will not need to integrate with any streaming software, but must have the ability to work seamlessly within gaming environments. Key aspects of this project include: - Development of a button functionality on the Stream Deck that allows clipping of in-game voices. - Instant replay feature for the captured voice clips. - Automatic saving of these voice clips without prompting the user. Firstly, I already use a plugin for the Streamdeck called “Sound Deck” for videogames and this plugin has a feature that allows me to record the voices, or sentences, of my teammates the voice chats and then i can immediately play...
I am looking for a Cantonese-Spanish translator to accompany me on a daytime business trip to Guangzhou in June (06/28, 07/1-2-3). The trip will last less than a week and involves business negotiations. Ideal candidates should be: - Speaks Cantonese and Spanish fluently. - Strong in industry-specific terminology, particularly in business. - If possible, have some experience in exports. Your main responsibility will be to help me with translations during the different business meetings that are scheduled. Their role is crucial to ensure fluid communication. Your support will be greatly appreciated.
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
...complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance issues. - Maintain high code quality and adhere to best practices in Flutter development. **Requirements:** - Prov...
...artworks in a predetermined (similar) style as samples in attachment. Paintings should be very similar as design in attachmnet, but can not be exact copies. Can be the same text, also with McDuck or Bunny. Hight resolution of arts 8000x6000px. We want also source files in PSD to change/remove a texts. We are looking for someone for a long-term cooperation. Send your portfolio to get an impression of your previous work. 1st artwork: Mr Bunny with Mrs. Bunny, graffiti background White Text: A journey to Love: 2nd artwork: McDuck with lots of USD White Text: Forbes 3rd artwork: McDuck with lots of money, cigar in hand Gold Text: NO LUCK ALL HUSTLE 4th artwork: McDuck with bottles of Dom Pérignon Gold Text: DRINK CHAMPAGNE - SAVE WATER 5th ...
I'm in need of a skilled builder who can create a powerful cross-platform crypto mining app. The app should not only facilitate the mining of a new crypto every hour, but also give users the option to purchase premium packages using a variety of crypto wallets. Key Requirements: - Development for both iOS and Android platforms - User-initiated mining process - Support for mining of a new, specific cryptocurrency - Inclusion of secure transactions for premium package purchases Your role in this project will be to design and implement a user-friendly interface that enables seamless navigation and functionality across both iOS and Android. You'll also need to integrate secure and reliable crypto wallet options to facilitate premium package purchases. Prior e...
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...
...elements I'm looking for: - Proficiency in creating modern, visually appealing websites with clean design. - Strong expertise in UI/UX design principles to ensure an intuitive user experience. - Attention to detail and a commitment to delivering websites that are both visually striking and user-friendly. Skills and experience required: - Proven experience in designing and developing modern, professional websites - Strong understanding of user experience and user interface design - Familiarity with creating effective contact forms - Wordpress, Javascript, HTML, CSS Please provide examples of your previous work, particularly any company websites you have developed. I'm also keen to hear about your approach to user experience design and any specific...
...help me increase the traffic to some specific website using referral links. (, Viator, GetYourGuide). Key Requirements: - Reddit Expertise: The ideal candidate should have a proven track record of successfully increasing website traffic through Reddit. - Understanding Target Audience: Experience in engaging with and attracting travelers on Reddit is a must. Specific Tasks: - Subreddit Targeting: You should be able to identify and engage with the relevant travel subreddits. - Traffic Generation: Your main task will be to be active on the subreddits, giving advices of hotels and travel activities using a specific referral link ( , Viator, GetYourGuide) through Reddit. This may involve creating engaging posts, participating in discussions, or any o...
As an entrepreneur, I’m looking to put my company out there with an informational website. I am looking to showcase: - Company Overview - Product/Service Information - Contact Information I do not have a specific color scheme or branding in mind and would appreciate assistance in choosing a suitable scheme that aligns with the nature of my business. I am seeking a creative and experienced web designer with excellent understanding of color theory, user-interface design and up-to-date with the latest web trends, techniques and technologies.
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data im...
