Vba excel optimizing codeงาน
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
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required Strong emotional intelligence (EQ) and interpersonal skills required Experience with workflow design required Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel: Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements: This role frequently communicates with others, must be able to exchange accurate information in these situations This role routinely uses standard office equipment such as computers, p...
...in creating a seamless navigation for a diverse product portfolio will be highly considered. Key highlights for this project: - Proficiency in Shopify & WordPress: You will utilize both platforms in arranges items, allowing customers to shop easily. - Physical goods eCommerce experience: Insight into managing a diverse range of products would be advantageous. Your knowledge would be key in optimizing the user shopping experience and ensuring a smooth buying process for shoppers. - Minimalistic Design Expertise: I prefer a less is more approach. Translate my vision of a clean, clutter-free and intuitive interface that enhances buyer's experience. Combine your technical skills with a keen sense of aesthetic, and let's create a user-friendly eCommerce hub togeth...
I'm looking for a developer who can update the Godiva viewer to be compatible with the Copernicus WTMS service. Your objectives are: - Updating the viewer to access and display data from the Copernicus WTMS service - Enhancing its functionality to better display Copernicus data Key Features Needed: - Interactive time-series analysis, for better data interpretation - Dynamic layer ordering, to enrich data visualization The ideal freelancer for this project is one who is proficient in the WTMS system, has a good grasp of Godiva viewer operation, and can provide these specific updates. An understanding of the functions and usage of a geospatial portal viewer is a plus. You should also be a creative thinker, with an eye for improving interface usability while upholding technology...
Notes----- Please stay away from those who first say something else in the budget and then increase it. We are looking for a skilled Flutter developer and PHP backend developer to make updates to our existing matrimonial app and integrate new functionality using APIs Implementing new functionalities on the server-side to support ...matrimonial app and integrate new functionality using APIs Implementing new functionalities on the server-side to support app updates. Enhancing database structure for improved data management and efficiency. Improving security measures to safeguard user data and privacy UI enhancements and improvements for a better user experience. Integration of new screens and features as per requirements. Optimizing app performance and responsiveness across differ...
I'm seeking a virtual assistant with a strong understanding of Excel. Your primary tasks will be managing and updating inventory data on a daily basis. Key Responsibilities: - Data Entry: Regularly update the Excel sheet with the latest inventory data. - Data Analysis: Analyze the inventory data to provide insights and trends. - Formula Creation: Develop and implement custom Excel formulas as needed to improve efficiency. Ideal Profile: - Proficient in Excel data entry, data analysis, and formula creation. - Experience with inventory management. - Able to deliver regular updates daily. - Careful attention to detail, as the handled data will be related to inventory. Your role is crucial for maintaining up-to-date inventory records and generating daily ...
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in your ...
I'm looking for a skilled digital marketer who can manage a Google Search Ads campaign with a focus on lead generation. The campaign should be targeted at a national level. Key deliverables and requirements include: - Crafting and implementing a strategy aimed at generating leads - Monitoring and optimizing the campaign for maximum results - Regular reporting on campaign performance Ideal candidates should have: - Proven experience in Google Search Ads, with a focus on lead generation - A solid understanding of national-level targeting - Strong analytical skills to measure and improve campaign performance the target country is India., I'm open to suggestions and recommendations based on industry best practices.
I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous...
I need a professional who's capable of modifying an existing Lua code. The successful candidate should be able to: - Understand and work with existing codes - Add an unincorporated parameter, specifically the 'tool tip radius coefficient,' into the current Lua code - Develop a method for analyzing gear size data to determine the aforementioned parameter Demonstrable experience in working with Lua language and proficiency in data analysis, specifically in gear size data, would be extremely beneficial in executing this task successfully. Strong understanding of gear parameters and a knack for intuitive problem-solving are greatly preferred.
I'm looking for an experienced professional capable of optimizing my website's on-page SEO, specifically focusing on content development and keyword optimization. Mastery of Google's search algorithms is crucial. Key tasks include: - Developing relevant and engaging content with optimized keywords - Conducting detailed keyword research The ideal candidate would have proven experience with on-page SEO and an understanding of how to apply these techniques effectively to climb Google's search rankings. Resourcefulness, creativity, and an in-depth understanding of SEO best practices are essential to perform well in this project.
Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconcil...
I'm looking for a talented web designer to help me revamp my publishing website. - The main purpose of the website is to cater to the general public. As such, the new design should be user-friendly and appealing to a wide audience. - Since the current design is outdated and not attracting enough visitors, I'm looking for a fresh and modern design that can help boost engag...visitors, I'm looking for a fresh and modern design that can help boost engagement. - The website should be easy to navigate, with a clear structure and intuitive layout. Ideal skills and experience: - Proven track record of modern, engaging website design - Understanding of user experience and user interface design - Proficiency in relevant design software - Experience in website redesign and opti...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.
As part of our camera club, we are in need of a talented individual who can help us set up a Facebook profile and page. We are looking for someone with a knack for social media management, particularly in creating and optimizing Facebook profiles and pages. Key Requirements: - Experience in setting up and optimizing Facebook profiles and pages - Proficiency in social media management Primary Goal: Our main focus for the Facebook profile and page is to promote our club's events and activities. Content Strategy: We intend to post a variety of content, including: - Photographs captured by our club members - Information regarding upcoming club events - Tips and tutorials on photography We are open to suggestions and recommendations regarding content strategy. A deep und...
...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I'm looking for an experienced Excel whiz to help me organize a sizable amount of data. Specifically, you'll be dealing with multiple data categories that need to be sorted and structured. This calls for a high level of attention to detail and accuracy. Key deliverables include: - Sorting and categorizing the data efficiently - Utilizing conditional formatting and logic functions to make the sheet user-friendly - Ensuring all data is accurately placed Ideal skills for this project include: - Proficiency in Excel, especially with organizing and structuring data - Previous experience dealing with multiple data categories - A good eye for detail to ensure accuracy - Knowledge of conditional formatting and logic functions to make the sheet user-friendly If you hav...
...functionality to facilitate quicker and more efficient loan approval processes. - Developing a feature that provides real-time loan approval notifications for both the agents and customers, ensuring transparency and timeliness. Currently, our loan documentation and verification processes are a combination of manual and digital. Therefore, it would be ideal if the selected freelancer has experience in optimizing such processes. The ideal candidate should have: - Experience in designing and implementing agent platforms in the financial sector, particularly in MSME lending. - Technical skills in automated credit scoring systems and real-time notification features. - A good understanding of digital transformation in the lending sector, with a focus on balancing manual and digital...
I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
I'm looking for an experienced individual who excels at listing products on eBay. Since I skipped the questions on product types and the extent of listing required, you must be versatile in handling a wide range of product categories. Whether it's electronics, fash...you should know how to present them effectively to attract, engage and retain potential buyers. Ideal skills and experience: - Prior experience with eBay product listing - The ability to write appealing product descriptions - Understand the eBay listing process - Excellent time management skills - Flexibility in handling a variety of products. Whether you will be starting from scratch or optimizing existing listings will be clarified later. Let's connect and discuss more about this opportunity. Your ...
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
I'm seeking a skilled programmer adept at OfficeScript coding to undertake a simple to moderate project focused on data manipulation. The task will involve crafting a script dedicated to dynamically copying and pasting data from one worksheet to another with efficiency and accuracy. The ideal freelancer should possess the following skills and experience: - Expertise in data handling & manipulation utilizing OfficeScript - Proven experience in dynamic data processing between worksheets - Familiarity with the generation of customized scripts for specific tasks The goal is to streamline our internal data manipulation procedures, ensuring data integrity and reducing manual efforts. If you have the skills and experience to deliver, I'd love to hear your proposal.
Um Trabalho, que foi nescessario fazer uma contagem de pessoas e lugares influentes, e Tambem somar e totalizar, contagem de votos e estimativa de média e total de pessoas e votos. Dando atratividade a alguns nomes mais influentes
As I step into the world of dropshipp...experience in setting up and managing Shopify stores is a must. - Product Range: I plan to sell a variety of products, ranging from electronics to fashion and home and garden items. Therefore, you should be comfortable working across multiple product categories. - Shipping Strategy: While I aim to offer free shipping, I also want to provide a standard shipping option. Your expertise in setting up and optimizing these shipping strategies will be crucial for my store's success. Your role will encompass setting up the store, integrating essential apps, and guiding me on best practices in product selection and shipping strategies. I'm seeking someone who is proactive, has a good eye for detail, and is able to communicate effectively thr...
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this...
