Excel vba function return blank cellcông việc

I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail

(Lowest bid with Highest rating will get project) I'm looking for a professional WordPress developer to create a static website for my home improvement business. Key Features: - The website's primary function will be to showcase our services, which include kitchen remodeling, roof repairs, and other related offerings. - It should be visually appealing, easy to navigate, and responsive to different devices. Ideal Skills and Experience: - Extensive experience in WordPress development - Strong understanding of website design principles - Previous work with similar service-oriented websites is a plus.

I'm Ms. Hòa, a psychologist with two years of experience wanting to develop a mobile app for my counseling services. Key Features Required: - A live chat function for real-time communication with clients - Integration with Zalo for voice calls Ideal Skills for the Job: - Mobile app development expertise - Experience with integrating live chat and voice call functionalities - Understanding of user-friendly interface design - Knowledge of mental health service requirements - Experience with Zalo API integration would be a plus. Having a passion for mental health support and a desire to help those facing life's difficulties will greatly enhance the alignment with my project's goals. Please, only apply if you have the relevant experience and skills.

I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling

I'm looking for a web developer to help me finish my website, which is intended for a blog/informational. Key Project Requirements: - Expertise in website development - Experience with creating blog platforms - Ability to integrate a search function - Knowledge of best practices for user-friendly design

... Email Creatives: - Creating engaging visuals and layouts for email campaigns. - Ensuring designs align with brand identity and resonate with our target audience. E-commerce Listings: - Assisting in creating and updating product listings with optimized visuals. - Ensuring images and descriptions are consistent across platforms (e.g., WooCommerce, eBay, and Google Shopping). Requirements: To excel in this role, you’ll need: - Proficiency in Photoshop or similar design tools. - A strong portfolio showcasing creative design skills, particularly in e-commerce or digital marketing. - Familiarity with social media ad design best practices (especially Facebook/Instagram). - Experience with e-commerce platforms (WooCommerce, eBay) is a plus. - Excellent attention to detail and t...

...It must also include a Payment Gateway for Stripe so that the user pays the service fee before selecting the appointment on the calendar. The option of payment on delivery will also be given in order to complete the process of filling out the forms. The Dealer user will have the same permissions but can register more than 1 vehicle regardless of the quantity. The Technical user will have the function of checking the Appointment calendar and when entering the Personal or Delaer user details, he/she will be able to print the previously filled out forms to be able to carry out the physical inspection of the vehicle and upon finishing the inspection, he/she will be able to process that inspection request. Then he/she will proceed with the next one. This user will be able to generate...

I'm seeking a freelancer with robust XLS and data analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to i...analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to identify trends in customer satisfaction. - Pinpoint the most common complaints from the feedback. - Extract suggestions for improvement from the customer feedback. - Create a compelling and clear presentation from the analysis. Ideal Skills: - Proficient in Excel for data analysis. - Experienced in creating presentations in PowerPoint. - Strong analytical skills to interpret customer feedback data. - Ability to present data in a clear and e...

I'm looking for a skilled app developer to create a mobile application focused on field management for tractor farms. The primary function of this app will be field mapping. Key Features: - Field Mapping: The app should enable users to map out their fields efficiently, tracking various aspects of their farm's layout. The application will be primarily accessed via mobile devices, so experience in mobile app development is crucial. Understanding of agricultural processes and needs would be a significant advantage. Please provide examples of similar projects you've worked on in your proposal.

I'm in need of a skilled developer to scrape phone numbers from www.yellowpages.com.au. The data should be categorized into Plumbers, Electricians, HVAC companies, Roofers, and other trades. Key Requirements: - Delivering the data in an Excel spreadsheet - Including the Company name and Website URL along with the phone numbers - Formatting the phone numbers in International format for easy dialing Ideal Skills: - Proficient in web scraping and data collection - Experienced in using Excel for data organization - Knowledgeable in categorizing trade-related companies

I am in need of an experienced Excel specialist who can create a financial modeling matrix for me. The matrix should be capable of performing ROI calculations and Net Present Value (NPV) calculations. Ideal skills and experience for the job: - Proficiency in Excel, particularly in creating complex models - Experience in financial modeling - Ability to incorporate specific financial formulas into the matrix - Understanding of ROI and NPV calculations. I WILL PAY $30 TO FULLY COMPLETE MY MATRIX AFTER YOU SUCCEED THE FIRST STAGE PLUS A BONUS WHEN I GET PERSONAL GUARANTEE PLUS UNLIMITED REVISIONS

...Calendar Booking & Automation Setup Description: I am looking for a highly proficient and experienced GoHighLevel (GHL) specialist to assist with setting up the functionality of the platform for my business. This is a technical setup-focused role, and I need someone who is deeply familiar with the features and customization options within GoHighLevel. Scope of Work: Calendar Function Setup: Configure the calendar function to manage bookings for group dance classes. Set up recurring schedules, class categories, and proper time-slot management. Ensure seamless integration with my existing workflows and ensure clients can book and manage their appointments easily. Automation Funnels for Booking Confirmations: Create a fully automated system for sending: Text message...

...working because the version was built back in the early 2000s and support was not kept. There are source files on that website that you might find useful to copy as well as UI elements that might make this project make more sense. Another option that you can replicate: Things you need to know: I expect you to test this tool yourself and provide proof of function before receiving any payment. You will need to download the game and client, create an account, and develop a tutorial on how to install and use the tool. I will pay for any additional quality of life changes made to the tool that I ask for after a working software is made. We will use discord to communicate, please make sure you PM me with your discord name so we can discuss the project and

I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. I am attempting to create and fill a WORD template by completing a form in Microsoft Lists....am attempting to create and fill a WORD template by completing a form in Microsoft Lists. The form must then be changed to a PDF and emailed. I am presently using a Plumsail action but would like to get rid of it. One of the flows is the same as previously stated but fills an Excel template instead. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and recti...

I aim to create a...voice features in ChatGPT. Chat gpt's advanced voice feature is accessable for free but with limited time directly through their website Attached is a reference avatar, we are looking for one aged 35-40 Key requirements: - The AI needs to be capable of holding unscripted, life-like conversations. - The avatar should be human-like, able to convincingly simulate a person. - The primary function of the AI will be conducting interviews. Ideal skills and experience: - Strong understanding of AI and machine learning. - Experience with API integration. - Familiarity with creating content for YouTube and TikTok. - Knowledge of voice synthesis technologies, particularly those used in ChatGPT. - Experience with human-like avatar technologies like Emot...

Step 1: Key Variables Include the following inputs and calculations: Dates: Check-Out and Check-In Pricing: Daily, Weekly, Monthly, 3-Month Rates Charges: Fuel Surcharge, Damages, Cancellation Fee Mileage: Allowance, Actual Mileage, Excess Mileage Charge Payment: Deposit, Payment Amount, Card Fee Outputs: Total Cost, Refund/Outstanding Amount Step 2: Excel Layout Design an Excel sheet with the following structure: Description Input Formula/Explanation Check-Out Date 01/10/2025 User input Check-In Date 01/25/2025 User input Rental Duration (Days) =B3-B2 Rental Type Daily/Weekly/Monthly/3-Month Dropdown using Data Validation Daily Rate $50 User input Weekly Rate $300 User input Monthly Rate $1,000 User input 3-Month Rate $2,800 User input Rental Cost Formula depends on rent...

I'm seeking a C# developer to create an application that interfaces with Power BI via external tools. The primary function of this app is to optimize my Power BI reports by identifying and removing unused columns and tables, and generating optimized DAX code for measures. Key Features: - Compiling a list of open Power BI report queries. - Generating M code with unused columns filtered out. - Identifying unused tables. - Listing all measures in the project. - Providing optimized DAX code for selected measures. The app should highlight in red all queries and measures that can be optimized. Ideal Skills: - Proficient in C# and Power BI. - Prior experience with creating optimization tools for Power BI. - Strong understanding of M code and DAX. Please note, I want all identifie...

I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

Project Overview Create a Python module that calculates NBA player statistics using the balldontlie API. The module should fetch and process player game statistics across multiple seasons, providing both rolling averages and game-by-game totals in specific formats. Key Requirements Data Source Use the ball...played fewer games than requested Test with players who span multiple seasons Test filtering of games where player did not log minutes Test handling of DNP (Did Not Play) games Test handling of missing/null values in game data Test error handling for API failures Deliverables Python module implementing the specified functionality Documentation including: Installation instructions Usage examples Function documentation Basic test suite demonstrating functionality file

Found the Selected Data from One Excel file on the Other File. Both files are provided for reference. "Scores" sheet, find the same song on the

I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of employee shifts.

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.

...(provided) to replace MFC classes and update look and feel of windows/frames/borders and to enable tabbed windows • Activate track map window and plot GPS track bitmap • Allow mixing of y-axis for channels with same scaling • Add function to change plot order • Fix X-Y plot conditioning • Fix bug when some channels are not plotted  • Save/open desktop layout  • Fix maths wizard • Add sort by name/date etc. to open file dialog • Add bit masking to show bit status for on/off values • Add drag of y-axis to change size • Allocate colours to channels automatically • Add function to choose speed channel for distance calculation The current software can be installed, it is attached to the project so that it ca...

...SEO-friendly, mobile-compatible. PLEASE ADD the following product lookup code on the home page: Add In home page: <iframe id="iframeTB" class="plugin" src="" title="Iframe E-commerce"></iframe> Add in search for Tires Page: <iframe id="iframeTB" class="plugin" src="" title="Iframe TB E-commerce"></iframe><script> = function() {const iframe = ('iframeTB');const parentQueries = (1); = `${parentQueries}`};</script> You can utilize either a template from Envato or reference some specified admired sites. Websites to admire: - - - https://tireoutletus

...market trends, pricing, yields, growth potential, and more. 2. Data Cleaning and Processing: • Clean and process the data to ensure it’s ready for analysis and reporting. 3. Property Rating Calculation: • Calculate property ratings using multiple factors (e.g., price, yield, demand, growth potential, etc.). • Customize ratings based on individual client preferences (e.g., focusing more on return on investment or potential for growth). 4. CRM Integration: • Integrate the system with an existing CRM to display ratings and help the sales team make informed decisions quickly. 5. Maintenance: • Implement a solution that allows for regular updates to ensure data is always current and accurate. What We Need From You: • Build the system to i...

...be professional and corporate, not overly flashy but still engaging. - The website must include detailed investment plans, a contact form for inquiries, and a section for customer testimonials. Investment Plan and Reward for Investor Target Reward +Incentive for sales advisor also Dashboard with sign/ signup option for investor and Sales Team Dashboard profile/ amount investment / Return / expected Return / for investors Sales team , Portfolio , client name / amount / APR / locking / Referral Link also need add payment Gateway Ideal Skills and Experience: - Proven experience in corporate website design. - Ability to create engaging, investor-focused content. - Experience in designing websites with detailed investment plans. - Knowledge of implementing customer te...

...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple table - The project is in E...

I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.

Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and cata...looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research an...

I need assistance in filing my individual income tax return. The income to be reported primarily consists of salaries and wages.

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

...interface and primarily display a list of words. - The words need to be sorted into categories, rather than being shown in alphabetical order or at random. App should have the following mandatory features: 1. App should be written in Kotlin 2. Search bar on top with an x button on the right to clear the search (please see video). 3. After search is pressed a method from C++ is called - this will return mocked data 4. Top bar has a settings button on the right, this will trigger a settings screen where he will be able to select two categories: games and language. All UI and images will be provided. 5. Every time the user taps search or settings or selectd the games or language categories a counter will e incresed. When this counter will reach the number 8, an interstitial ad w...

...Android versions and iOS. Key Responsibilities: - Investigate and fix the issue where the custom adhan sound does not work in the foreground, background, and locked state on Android. - Test the push notifications and adhan sound on iOS, ensuring no bugs are created during the testing process. - Evaluate the manual push for 'silent', 'notification', and 'adhan+notification' options, ensuring they function correctly when scheduled for prayer time. - Fix the issue on Android where clicking on a scheduled push notification does not redirect to the intended page, while it works fine on iOS. - Test the Qibla functionality on both Android and iOS on all devices. Ideal candidates for this project should have: - Extensive experience in app testing on both ...

... 4. POS Screen Configuration o Design and configure the Point of Sale (POS) screen layout to enhance user experience. o Tailor the interface to match the client’s operational flow. 5. Data Import o Migrate the inventory list and customer list from QuickBooks Point of Sales Desktop into Dynamics 365 Commerce. 6. Testing o Conduct thorough system testing to ensure all configurations and imports function as expected. o Validate the POS system's performance and usability. 7. Training o Provide training sessions for administrative users to ensure they are proficient in using the system. o Cover key functionalities, including inventory management, sales operations, and basic troubleshooting. 8. Go-Live Support o Offer support during the go-live phase to address any immediate...

I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!

...verification, Abandoned cart notification, order notification and payment gateway integration Note 99.9% website has to be managed through Dashboard, like editing pricing, bulk import,export,bulk move with-in pages, bulk edit, bulk delete, Hide category, in page pages or multiple pages, Edit in one page or multiple pages, though coded the website has to act plug and play Ecommerce Website USP - We give return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secure login with pin code (as an example shown in myntra), • Coupons creation in admin panel with expiry date and with a condition which will be discussed later • Gift page which works on multiple conditions but ...

Bond Yields & Portfolio Diversification Essay I need an essay of 2,500 words on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yi...practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understanding of the time value of money and the nature of interest rates is vital. - The essay should reflect knowledge of different sources of finance. - Accurate calculations of the fair value of bonds and shares are necessary. - The relationship between risk and return should be understood. - The essay should illustrate how appropriate diversification reduces risk. Please ensure to add some references that are formatted in AU ...

I need an essay of 2,500 words in total on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yield of a bond, and discuss the likely...practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understanding of the time value of money and the nature of interest rates is vital. - The essay should reflect knowledge of different sources of finance. - Accurate calculations of the fair value of bonds and shares are necessary. - The relationship between risk and return should be understood. - The essay should illustrate how appropriate diversification reduces risk. Please ensure to add some references that are formatted in AU Harv...

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

...inconsistencies in the trends and quality of banners depending on the person in charge. 3. System Functionality Details (a) Based on the above, this system provides the following functions to solve the current issues. (b) Automatic template selection function ① Past banner production data is normalized and used for fine-tuning ChatGPT. ② When product information (product image, price, description, catchphrase, target, brand color, etc.) is entered, the optimal Canva template ID is estimated based on past selection trends. (c) Automatic element setting function ① Automatic image size setting: Automatically selects the appropriate image size for each product information. ② Automatic text size adjustment: Adjusts to the optimal size while maintaining readability according to...

I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.

I need a C# developer to add a simple function to my Illustrator plugin. The task is to incorporate the "Send to Winplot" feature as per the attached PDF file. All other functions have already been implemented. Key Requirements: - The plugin should open Winplot with the file loaded. - The file should not be saved in a specific location before opening in Winplot, it should just open directly. - There are no special conditions or checks needed before sending the file to Winplot. Ideal Skills: - Proficient in C#. - Experienced in developing Illustrator plugins. - Familiar with Winplot software. I look forward to seeing your bids.

I'm seeking an expert to assist with converting my Excel tables and data into HTML. This project will also require the conversion of my Excel charts and graphs into static images for HTML display. Skills needed: - Proficient in Excel and HTML - Experience in data conversion - Ability to create static images from Excel charts and graphs - Attention to detail to ensure all tables and data are accurately converted

I need help with my WordPress-based Woocommerce site. I want to modify the script that sends out the 'order completed' emails to include delivery information. I have the script written already however if the product does not have shipping, then I get error: Call to a member function get_method_id() on bool Script is similar to this and there's a solution to the problem however I can't do this work Looking for immediate help please

I'm seeking a web developer to create a small-scale HR management system. The application should allow the addition of new employees, inc...mark their own attendance. - Salary Management: The system should allow employees to download their salary slips. - Data Upload: There should be an option to upload employee data in bulk via Excel. - Email Integration: The system should be configured to send offer letters through Gmail. Ideal Skills: - Web Development: Proficiency in creating interactive and user-friendly web applications. - HR Software Knowledge: Prior experience with HR management systems would be beneficial. - Email Service Integration: Experience with Gmail's API for automated email sending. - Data Handling: Skills in setting up Excel data uploads for large...

I am seeking an AI-based solution for summarizing and editing my business reports. The AI should be able to: - Generate concise summaries of the reports. - Identify and correct grammatical errors. - Function as an editor, enhancing the overall quality of the text. The ideal candidate for this project should have a strong background in AI development, particularly in natural language processing. Experience with business-related content is a plus. Please provide examples of similar projects you've completed in your bid.

... Home Page: A visually appealing and responsive landing page that dynamically displays content. 2. Contact Us Page: A functional and dynamic contact form where user inputs are saved to a database and can be accessed via an admin panel. 3. Blog Page: A blog section where I can add, edit, and delete posts dynamically using an admin panel. The blog should support categories, tags, and a search function. Key Features Required: • Fully responsive design (desktop, tablet, and mobile). • Admin panel/dashboard for managing content (blog posts, contact form submissions, etc.). • Backend development with database integration (MySQL or similar). • Framework/Platform: [Specify your preferred framework, e.g., Laravel, Django, Node.js, or WordPress if dynamic feature...

I'm a beginner in Power Queries, seeking a tutor to guide me through data transformation and merging queries. Together, we'll improve an existing Excel file for better data organization. Sessions will be over Zoom, which will be recorded for future reference. Ideal skills and experience include: - Proficiency in Excel, particularly Power Queries - Prior experience in online tutoring or teaching - Ability to simplify complex concepts - Strong communication skills - Patience and understanding towards beginners