Excel macro to hide columns based on criteriaงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
PLEASE DON'T BID 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: - Proficie...
...proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreads...
...individual or team to handle the entire acquisition process for our real estate wholesaling business in Baltimore, MD, Cleveland, OH, and Memphis, TN. This includes sourcing both on and off-market properties, analyzing deals, making offers, and conducting skip tracing and cold calling. Additionally, we require assistance in finding cash buyers and gathering their buying criteria. Responsibilities: - Source on and off-market properties in Baltimore, Cleveland, and Memphis - Calculate ARV, repair costs, and MAO - Make offers and negotiate deals - Conduct skip tracing and cold calling - Record all calls for accountability - Assist in finding cash buyers and gathering their buying criteria Requirements: - Experience in real estate wholesaling or similar ...
...expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to...
I am looking for a consumer researcher to visit 3 stores in ROUEN. The project in a nutshell: -All information will be captured via our company's App that has to be downloaded by way of a link emailed to the successful candidate. -Visit 3 supermarkets in Rouen, addresses will be provided. -Around 42 products in total not per a store. – Assess packaging of products for our client, products include baby diapers, feminine hygiene products, kitchen paper and toilet paper. -10 samples per a product has to be assessed. E.g Product A is baby diapers, 10 of these will have to be looked at closely for defects. -If samples are good no photos are required, if samples have defects photos are required showing the defect clearly. -No products need to...
I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability...
I need a skilled developer to create a low volume candle detector for a web-based application. The detector will be used in indoor, outdoor, and also mixed environments. The key feature of this tool should be its ability to visibly mark the presence of low volume candles. Details of the project requirements include: - Capability to detect and mark low volume candles. - Visual indicator as a marking system for detected candles. - Full integration into a web-based application. The ideal candidate will have a strong background in web-based applications, preferably with some knowledge or interest in candle detection systems. Experience in graphical interface design is a plus as the visual indicator should be clear and noticeable.
I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting ...
I'm seeking a creative designer to develop a uniquely captivating, text-based logo design for a new project. My vision is firmly defined and I am in pursuit of a professional who can translate it into a crisp, unforgettable logo. Key Requirements: - Develop a text-based logo - Follow predefined color schemes and visual elements - Strong attention to detail to incorporate the specific elements I have in mind Ideal Skills & Experience: - Extensive experience in Logo Design - Ability to work with defined color schemes and visual elements - Excellent communication to ensure a firm understanding of project details I am excited to collaborate on this project and look forward to the creativity and expertise you wi...
...business on AmazonUK and currently conducts activities in the UK. As per the update by Amazon in 2024, we need to appoint a UK resident director to continue our operations on AmazonUK. This position will be purely nominal and the director will not be involved in active management. Job Details: Our company, operating wholesale trade on AmazonUK, is seeking a director residing in the UK. The director position will remain purely nominal, with no involvement in the active management of the company. A fixed monthly payment of $125 will be provided for serving as a visible director on behalf of the company. If company director want, our all returned products will be send director's return address monthly (we have global branded inventory) We ...
I'm looking for a skilled developer to design and build a website that will facilitate crypto funding rounds using the Solana network. This project involves creating a website that can transact with investors and distribute tokens at the end of all the funding rounds. Key elements of this project include: - Developing a site with the following features: Crypto funding rounds, Transaction capability, Token distribution - Using a Solana-based solution - Integrating the site with Crypto wallets - Writing secure Solana Smart Contracts Preferred Platform: ReactJS but open to suggestions Design: A design has already been prepared for the site as in Images and wording but the pages etc need to be setup. Ideal candidates for this project should have: - Profici...
IOT is being used a lot these days to provide functions that were being done before manually. We are also embarking on the same journey and looking for a potential person who can help us with our proposed system. Thank you
I'm looking for a skilled developer to create a basic matchmaking website. This website is intended to connect users based on specific criteria. Key Features: - **User Profiles**: User should be able to create profiles. These profiles must capture the user's name, age, specific pricing details for using and providing the service. - **Matching Algorithm**: This is the core functionality of the website. I need a matching algorithm that can match users based on the information they provide in their profiles. The algorithm should be efficient and accurate. - **Messaging System**: The website should have a messaging system that enables users to communicate. I'd like this system to include both chat messages an...
I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.
I need an experienced and reliable Java developer to build the backend for a user registration page. The functionalities and specific requirements include: - Implementing basic user registration features requesting name and email. There should not be any social media integrations or two-factor authentication involved. - Ensuring secure data handling and privacy of users' information. Ideal skills and experiences include: - Proficiency in Java and in building user registration modules. - Experience in ensuring data privacy and security. Your extensive experience in creating swift and secure registration processes is crucial for this project.
German Male only. We are looking for German Natives for a short voice recording project. You need to read and record 235 short sentences in our app and pay is 20$ When applying: Make sure you are a German native of Germany Have not participated in this project before You need to submit one ID proof that shows you are native German(you can hide sensitive information) Payment is 20$ for all 235 approved sentences and in checking it might take up to 4 weeks.
...estate program for my company's real estate agents. It is a program for internal use, that is, it will only be used by our real estate agents. Key Features: - Property management: the program should be able to efficiently manage a number of properties between 100 and 1000. - Advanced Property Search: An easy-to-use interface that allows real estate agents to search for properties seamlessly, filtering based on various criteria. - Sales Report Generation: The program should be able to generate complete sales reports for our properties. - CRM integrated with AI: the CRM component must be able to understand and address the client's property search needs through the use of Artificial Intelligence, providing personalized pro...
is a start up company Requirements: 1. Company name 'Zeena' so logo needed without .ai word 2. Need source files (SVG, Vector file format(illustrator), PSD) 4. High resolution image files are needed 5. Horizontal and vertical designs Additional requirements/nice to have: Letterhead with logo
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensat...
I am looking for a REMOTE personal trainer VIA ZOOM who can help me improve my overall fitness at h...can help me improve my overall fitness at home. I would like someone who can assist me 5 or more days a week. Preferred Skills and Experience: - Extensive experience in personal training, ideally with a focus on overall fitness improvement. - Knowledge in structuring comprehensive home-based workouts. - Ability to create diverse workout plans to avoid monotony. - Experience in motivating clients to attain their fitness goals. This is an excellent opportunity for trainers who have a knack for pushing their clients towards their best and are capable of providing a personalized approach to fitness-building. Please ensure your proposal details your a...
I'm in need of an experienced software developer to finish a web-based e-signature app already in progress. This app should offer all-inclusive features such as handwritten signature input, text-to-signature conversion, and the ability to upload images as signatures. A significant aspect of this project is ensuring that all e-signatures are secure, thus requiring advanced encryption with digital certificates. Here are the key points about the project: - Platform: Web - E-Signature Features: - Handwritten signature input - Text-to-signature conversion - Image upload as signature - Required Security Level: Advanced encryption with digital certificates The ideal applicant would be well versed in web-development and has expertise in building s...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to du...
...and a good understanding of TradingView's indicator functionalities. The main task is to build a custom indicator that includes Bollinger Bands, Exponential Moving Averages (EMA), and Relative Strength Index (RSI). Key Requirements: - Apply two EMA's within the main window. - Bollinger Bands should also be displayed in the main window. - Integrate Stochastic Oscillators with the above-mentioned two EMAs and RSI below main window This script should also allow specific customization aspects: - Setting the EMA period. - Modifying the Bollinger Bands period. - Adjusting the Bollinger Bands standard deviation. -adjusting %K&D,slowing,price field,method&level -adjusting RSI period,apply to weigh close HLCC/4 Ideal skills: - Proficient in c...
I'm seeking a top-notch freelancers with expertise in Laravel PHP to design my business-oriented payment gateway website. Ideal candidates should have a deep understanding of e-commerce platforms and a proven track record of delivering reliable and secure payment solutions. The final product should enable hassle-free transactions for businesses and ensure a seamless user experience. Key Requirements: - High proficiency in PHP, particularly Laravel - Familiarity with business-oriented platforms - Experience in integrating multi-currency support - Mobile wallet integration expertise - Proven ability in creating detailed transaction reporting systems - Deep understanding of security protocols - Excellence in UI/UX for a seamless user experience By evidenced past work, this task...
I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the results in a c...
As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital fo...
I am developing a Docker-based federated learning solution for industrial predictive maintenance to greatly enhance machine downtime prediction. The purpose of this system is to more accurately anticipate necessary maintenance and reduce unexpected downtime in industrial machinery by analysing operational data such as speed, temperature, equipment running time, and so on. Prospective freelancers must have skills and experience in the following areas: - Docker, for providing the backbone of our decentralized system - Federated Learning, to collectively improve our model's performance without sharing raw data - Working with and analyzing operational data - Implementing predictive models, in this case a 3-layer feed-forward neural network and stochasti...
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data ar...
I am looking for a professional and experienced Hindi voice artist for an audiobook project targeted towards Adults. Key Criteria: - The audiobook is extensive, more than 300 pages - Proficiency in Hindi and an understanding of teenage dialogue would be highly valued - Past experience with Hindi Audible or audiobook narration is necessary Required Skills: - Voice Acting - Audiobook Production - Audio Editing - Experience with teenage-targeted narratives Please provide samples of your previous work along with your bid. I look forward to hearing your captivating voices that can truly bring this story to life for our teenage audience.
As a client looking to develop a project centered on image recognition on Handwriting Character Recognition, I require a proficient Deep Learning Engineer who has expertise in Python programming. The core of the deployment involves: - The development of an effective image recognition system - Efficient use and application of PyTorch as the preferred platform The ideal candidate for this project exhibits the following skills and experiences: - Significant knowledge and experience in Python - Extensive understanding of PyTorch - Prior experience with image recognition projects Please ensure you have a strong grasp of the above-mentioned skills before bidding on this project. I look forward to meeting a dedicated professional who can deliver on...
