Vba excel initial formงาน
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. มีระบบ...
ทำ 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 professional for initial basic whitelabeling on Axelor ERP system before we dive furthur into it with intense whitelabeling. This first task project will mainly require two modifications: - Rebrand the login page, including the Axelor logo and description underneath it. (check attached images) - Adjust the 'axelor' word in the postgreSQL db whereever it exists as a data to another word of my choosing. The ideal candidate for this task must have a strong familiarity with postgreSQL. Also an understanding for JSand Java can be essential for the login page whitelabeling.
...Flowchart Expansion: As outlined in the appendix, I have already developed a part of the Neo4j file. Could you please use the existing flowchart as a base and add more nodes and relationships? Focus particularly on expanding more design guidelines under "Forward" and "Defects". These new elements should include "Description" among other properties. (Attached) Node Property Adjustment: In my initial setup, I mistakenly placed each node's name in the 'type' field; however, it appears they would be better served as properties to ensure names are displayed automatically upon accessing them. Please adjust the configuration so each node includes a property named "a", with the value set as the node's name. Documentation of ...
7 unique character sprites in the style of games like Octopath Traveler, Sea of Stars, Chrono Trigger - can supply original pixel art concepts/animations that I have created for reference. Looking to get a more detailed style and one closer to the example games mentioned above Each character would need a sprite sheet to include the following animations: 1. 4 direction walk...art concepts/animations that I have created for reference. Looking to get a more detailed style and one closer to the example games mentioned above Each character would need a sprite sheet to include the following animations: 1. 4 direction walk (top down rpg view) - 12 frames total 2. 1 battle scene sprite (reference image attached) - 1 frame total A lot more sprite work will follow if this initial project...
...communication alongside timely delivery are also important for successful collaboration. The ideal freelancer should have: * Proficiency in Adobe Photoshop, Illustrator, and other design software * Extensive experience with 3D animation techniques * Strong portfolio demonstrating solid visual design skills * Good grasp of aesthetic trends and branding techniques Your tasks will include: * Converting initial concepts into a functional and aesthetically pleasing animated 3D logo * Refining and iterating on designs based on feedback * Providing the final output in various formats and sizes suitably optimized for web and print. I look forward to working with a resourceful and creative designer who can give life to a logo idea that stands out and echoes the distinctive vision o...
...a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong und...
I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic f...
I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in mergers...
...manage their positions by accessing the "Manage Positions" menu. The platform offers curated data to assist traders in making informed decisions, including recent price history to understand trends. Key metrics displayed include current profit (both percentage and absolute), current value in USD and Sol, market cap of the token, price changes in various timeframes, net profit after deducting fees, initial value, token balance, profit with slippage, and wallet balance. Selling Tokens: Selling tokens is as fast and straightforward as buying them. Users can view their account on Solscan and the token's chart on Birdeye from the "Manage Positions" menu. If users hold multiple positions, they can cycle through them with arrows and choose to buy more or sell ...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of ...
We are a well-established furniture manufacturer with an active online store hosted on Shopify. We are looking for a skilled Shopify web developer who can integrate fabric descriptions and specifications from our vendor's website into our online cata...product management and content updates. - Ability to write clean, efficient, and maintainable code. - Strong attention to detail and a keen eye for aesthetics. - Excellent problem-solving skills and the ability to work independently. - Experience with HTML, CSS, JavaScript, and Shopify's Liquid code. - Good communication skills and the ability to follow instructions accurately. Duration: The initial setup is expected to be completed within 3-4 weeks from the start date. Periodic updates on the fabric will be required quarte...
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
My Drupal site is a single module site that has a single form page. it requires the module to be upgraded to Drupal 10. I also envision minor design updates on the aesthetics, but not an entire makeover. The site only has ONE custom module that is a form which requires porting over to the new drupal 10 site. The form updates a db table, but that table will remain the same and the same existing queries can be used. The theme can the default one. -**Design Updates**: A few enhancements to the website's look are needed, making it simple yet appealing. Full understanding of Drupal 6 and 10 is crucial. The freelancer should also have prior experience in site upgrades. you must have a good understanding of english. I am expecting a reasonable quote for the simple ...
...IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programmi...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
I'm seeking a skilled app developer to create a VPN service app for both Android and Apple phones. The app should primarily function by offering multiple server locations to our users. Here are some key requirements: - User Interface: - The app should have a minimal and intuitive interface. The user login screen s...experience in cross-platform app development, preferably with VPN related applications. - Strong UI/UX design skills to create an intuitive interface. - Familiarity with server management and back-end development to facilitate multiple server locations for the VPN service. - Proficient in ensuring the app meets the stringent standards of both Google Play and Apple's App Store. "These are the initial requirements, and we plan to further enhance the ap...
I'm looking for a seasoned writer who can collaborate with me to pen a comprehensive and pristine biography that spans more than 350 pages. The tone should be professional and formal, where personal life and family will be the focal point. Ideal Writer Skills: - P...Skills: - Proven experience in biography writing - Excellent formal writing style - Ability to encapsulate personal and family stories effectively Responsibilities: - Ensuring a comprehensive, well-structured, and engaging biography - Incorporating personal and family stories skillfully - Delivering within an agreed upon timeline Preference will be given to those who have previously written long-form biographies/memoirs. Please provide relevant samples. Do also indicate the estimated time you'll need to co...
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
I need a skilled professional to copy an order form from an existing website. The task involves: - Replicating the design and layout of the existing form - Ensuring that all are copied accurately - Making sure the form is functioning as it should - Identifying the backend technology used in the original form (if possible) Here is the site: Use google translate if you not can read it We need exact the same design, functions, etc. Exactly same technology and functions. If can't give us that, we have no interest and you waste our time and your own. THANKS
...entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work: - Creating invoices: You will be responsible for creatin...
I'm in need of a professional who can use AutoCAD to create a simple form in DXF..
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.
As the founder of DigitSathi, I am in search of an expert designer to craft a strong and reliable image through a compelling logo. Your vision and creative skills will help bolden our image, uniting our brand message and visual identity. Applicants should be prepared to provide: - Detailed project proposals: your initial idea, how you plan to design and implement it - Evidence of your understanding about logo design and brand identity. This project will require a designer who has: - Excellent design capabilities with attention to detail - A proven track record in creating unique and memorable logos - Experience in brand identity design - The ability to understand our brand message and translate that into visual design I look forward to seeing your amazing proposals and working ...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...
I need a skilled React designer/developer to cre...you to work on and a reference for the design style I have in mind. Key Requirements: - Design a token distribution chart for the tokenomics section - The style should be minimalistic and modern Please note that the chart should be created based on the existing functionality that is already integrated. Furthermore, the token distribution chart should illustrate the following: - Total supply - Initial token sale - Team allocation - Reserve fund - Community rewards Ideal skills and experience for this job include: - Proficient in React - Experience in designing charts, particularly tokenomics charts - A good eye for visual design with a minimalistic and modern touch - Ability to work with existing codebase Looking forward to your ...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll have...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your d...
I need a Gujarati dataset prepared for training the Llama 2 model, in order to later perform fine-tuning on it for language-specific tasks. Essential Requirements: - Curate a sizeable Gujarati dataset suitable for training NLP models, ideally around 5 GB - Utilize the Llama 2 model for the Gujarati fine-tuning, optimizing it for the specific task Key Skills: - Proficiency in NL...training NLP models, ideally around 5 GB - Utilize the Llama 2 model for the Gujarati fine-tuning, optimizing it for the specific task Key Skills: - Proficiency in NLP techniques and methodologies - Experience in curating or working with large datasets - Proficient in fine-tuning Llama 2 or similar models - Gujarati language proficiency is a plus Deadline: 2 days for the dataset curation and initial fi...
We are in the initial stages of launching an exciting e-commerce project aimed at enhance the online shopping experience. Technical Aspects of the Project: - Development of a browser plugin that interacts with various e-commerce platforms. - Integration of AI technology to extract data and analyze shopping cart contents. (Text extraction) - Implementation of APIs to collect and compare product data in real-time. - Creation of algorithms to identify and recommend similar products. (Might not be needed) - Development of a scalable backend to support real-time data tools and user analytics. Requested Technical Skills: - Experience creating sustainable Data modells - Experience in browser-extension development with JavaScript, HTML, CSS, and modern frameworks (React, Angular, Vue...
