Excel vba function return blank cellproiecte

I'm looking for an experienced financial analyst to assist me with a project. I've started an Excel workbook with some financial numbers for a listed company, but I need help checking my work and incorporating cash flow data from a PDF. Need quick turnaround and urgent - The project requires a detailed breakdown of the financial analysis. - The cash flow statement will need to be updated with information from the PDF. - Knowledge of accounting standards is not necessary for this project. Ideal candidates should have: - Proficient Excel skills - Strong background in finance

I have a PDF that contains tables and I need someone to convert it to Excel. The output should be an exact match with the PDF but standardized to a simple Excel format. and extract specified data from pdf to excel. we need a tool or pabble type software. Ideal skills for this job: - Proficiency in Excel - Attention to detail - Experience in data conversion tasks

I need a data analyst proficient in Excel to help me with weekly analysis of my customer data. Primarily, I am interested in descriptive analysis. Ideal Skills: - Proficiency in Excel - Strong analytical skills - Experience with data interpretation and reporting Key Tasks: - Conduct descriptive analysis on customer data - Provide insights based on the analysis Please note, the focus will primarily be on customer data. Prior experience working with customer data is a plus.

...tree and stump removal, and fuels reduction. Core Elements to Include: Use the slogan: "Dig Deeper with a Trusted Trucking & Excavation Contractor!" Feature our logo prominently. Incorporate an engaging image of an excavator masticating a tree, targeted at private homeowners. Must include: Company Name (Sheets Trucking & Excavation LLC) Phone Number (leave blank and will send it privately upon finalization) Email Address (leave blank and will send it privately upon finalization) Service Areas (Josephine, Jackson, and Douglas counties) CCB# (238173) Highlight that we are "Licensed, Bonded & Insured." Design Requirements: The design should be visually compelling and clearly communicate our service offerings. It should be suitable for us...

...(screenshot 1). 2. I want to display the wholesale and retail prices on the product search possible location (screenshot 2) 3. I want when a sell return is made, the code to redirect the screen back to the previous screen or it can redirect to the sale list. 4. I want a modification to enable creation of a warehouse which would allow me to have a main store to move products from and have the report for transfers pick this up when it's run. The idea is this, I have a warehouse and a front store. I would like the warehouse to only be for receiving and dispatching goods to the store. Now from the system I do not have the capability of creating such a function where I setup a warehouse Ps: Please bid with finality. No side bids on chat. The system is based on Ultimate P...

I'm looking for an expert in QuickBooks to help me set up my accounts for a family building. Specific tasks include: - Setting up expense accounts - Setting up income accounts Ideal skills for this job: - Proficiency in QuickBooks. - Experience with small business accounting for real estate - Ability to set up different types of accounts -Ability to pull info from Excel spreadsheets to get historical data for Quickbooks

I'm looking for a motivated salesperson to sell my ebooks. The focus will primarily be on social media platforms, specifically Facebook, Instagram, and LinkedIn. Key Responsibilities: - Promote and sell ebooks targeting students. - Utilize effective sales techniques on social media. Ideal Skills: - Proven experience in socia...to sell my ebooks. The focus will primarily be on social media platforms, specifically Facebook, Instagram, and LinkedIn. Key Responsibilities: - Promote and sell ebooks targeting students. - Utilize effective sales techniques on social media. Ideal Skills: - Proven experience in social media marketing and sales. - Excellent communication skills. - Understanding of the students' market. In return for your hard work, I will offer a commission f...

I have an Excel sheet that requires modifications to its conditional logic formulas. The main purpose of these formulas is to facilitate automated decision-making. Specifically, I need the formulas to trigger specific actions based on set criteria. Ideal candidate should: - Be proficient with Excel and its formulae, especially conditional logic - Have experience with setting up automated decision-making systems - Be able to understand and modify existing formulas to meet specified requirements - Be detail-oriented to ensure accuracy and reliability of the modified formulas. -Electrical Engineer

I need a quick turnaround for changes to my Laravel system. I need the following: 1. I want to display both the wholesale and retail prices of the product when they are displayed, possible location (screenshot 1). 2. I want to display the wholesale and retail prices on the product search possible location (screenshot 2) 3. I want when a sell return is made, the code to redirect the screen back to the previous screen or it can redirect to the sale list. 4. I want a modification to enable creation of a warehouse which would allow me to have a main store to move products from and have the report for transfers pick this up when it's run. Ps: Please bid with finality. No side bids on chat. The system is based on Ultimate POS System from Codecanyon

I'm looking for an experienced Android developer to create an application for the jewelry sector. This app should primarily function as a platform for users to interact with various monthly schemes related to jewelry. Key Features: - Monthly Schemes: The app should have a dedicated section where users can explore different monthly schemes. These schemes could be related to discounts, special offers, or exclusive products. Ideal Skills: - Android App Development: Proficiency in Android SDK and Java/Kotlin is a must. - E-commerce App Development: Prior experience in developing e-commerce applications would be advantageous. - UI/UX Design: The app should be user-friendly and visually appealing, reflecting the elegance of the jewelry sector. Please note, the scope of the projec...

I have an existing C# .Net Windows Form App for inventory RFID software. I need a developer to enhance this software with a billing generation feature and a function to save invoices as PDF files. Key Requirements: - The billing feature should have a dynamic UI generation option. This allows for the billing template details to be saved. - The itemized list in the billing template should include: Product description, Price per unit - Product details should be fetched from the SQL server database automatically based on product ID. Ideal Skills and Experience: - Prior experience with billing software is a must. Please provide relevant work as reference. - Proficient in C# and .Net. - Familiar with Windows Form App development. - Experience with SQL server database integration.

Our PHP mail script has encountered an issue which needs immediate attention. It has stopped sending order confirmation emails to us, although it continues to redirect customers to the success page. We are currently using the PHP mail() function to send our emails. We need someone with - solid experience with PHP and server-side scripting. - experience troubleshooting mail script issues. - you have to be ready to work on it & resolve it today Thank you

I am in need of a diligent and detail-oriented freelancer for remote data entry work. The task primarily involves inputting customer data from scanned documents into Excel spreadsheets. Your keen eye for detail and ability to work independently are crucial for maintaining data accuracy. Ideal skills and experience for this job: - Proficiency in data entry and Excel - Experience handling customer data - Ability to work with scanned documents - Excellent attention to detail - Ability to maintain confidentiality and handle sensitive data responsibly

I need a Microsoft Bookings plugin integrated into my WordPress website. The primary function I want from this integration is appointment scheduling. The plugin is to be applied to the 'book an appointment' tabs throughout the site. Ideal Skills: - Proficiency in WordPress - Experience with Microsoft Bookings plugin - Knowledge in appointment scheduling systems - HTML/CSS/JavaScript understanding for potential customizations. Please ensure to provide examples of previous relevant work in your proposal.

I'm looking for an Excel expert who can create a dynamic infographic based on an income statement. This infographic will adjust as I input new data. The project will be based on a JPEG/PNG image I will provide. Key Requirements: - The infographic should be able to handle detailed sections of data. - The design should closely resemble the reference image provided. Ideal Skills: - Proficiency in Excel, particularly with data visualization tools - Experience in creating dynamic infographics in Excel - Ability to closely replicate a provided design - Good understanding of income statements and financial data.

We are industrial spares and supplies trading company. We need an erp system to do our order management, track our order shipping, receiving and accounting. Out process is have about 10...receive the ordered items and consolidate the customer orders and then ship the orders to the customer and then invoice them out. We don’t maintain inventory. We only order the items when we get the to track pricing, profitability by order/customer, track shipping and recieving. .we are less than 5 employees and a very small company. All this while we were managing things via outlook and excel and now the volumes have exceeded so now becoming a little difficult to get full visibility. Have seen erpnext…is there anything else that I can look into…..let me know what you guys sug...

Seeking a VBA expert to enhance my current macro. The primary focus is on data scraping from a sports betting website, specifically targeting league names and the current year for the season. Requirements: - Proficiency in Excel and VBA - Familiarity with soccer fixtures and betting odds - Experience in data scraping Please note that this project is only for VBA no other programming languages. Thanks

...using the Walk Score API. The goal is to obtain the Walk Score of approximately 586 properties, which are georeferenced (latitude and longitude) in an Excel file. Requirements and responsibilities: Technical skills: programming experience (e.g. Python, JavaScript or other suitable language), handling REST APIs and reading/processing Excel files. Tasks to be performed: Connect and authenticate the application with the Walk Score API. Read and process the Excel file to extract the coordinates (latitude and longitude) of each property. Make the necessary calls to the API to obtain the Walk Score of each property. Save the results (ideally in an Excel or CSV file) in an organized way. Deliverable: Functional and documented code that allows the extraction of t...

...depending on selected answers. ✅ Professional Formatting & Design – Ensure a clean, polished, and user-friendly layout that is locked and aligns with branding. ✅ Template Locking – Protect the core content while allowing users to complete necessary fields without altering the structure. Ideal Skills & Experience: ✔ Strong experience in Word document automation (macros, content controls, forms, and VBA if needed) ✔ Understanding of conditional formatting and interactive document features ✔ Attention to detail in document design and usability ✔ Ability to provide guidance on best practices for a smart, user-friendly template If you have experience in Word document programming and automation, I’d love to hear from you! Please share examples of similar pro...

I'm seeking a skilled Excel developer who can create a user interface for a desktop application. This interface will pull data from a VLOOKUP on a separate tab and utilize three dropdowns to determine the result. Key Requirements: - Proficient in Excel and its advanced features - Experience in developing user interfaces within Excel - Able to implement VLOOKUP functions effectively - Capable of creating interactive dropdowns - Familiar with handling text data within Excel The application will be filtering or selecting from text data using the dropdowns. If you have a strong background in Excel and are able to deliver an engaging and functional desktop application, I would love to hear from you.

I'm in need of a bespoke Excel template aimed at analyzing 'Build Selections Data'. The primary focus of this template will be to facilitate comprehensive data analysis, with a particular emphasis on the use of pivot tables that consolidates data to separate worksheets labelled by Locations Key Project Requirements: - Creation of an Excel template geared towards data analysis - Incorporation of pivot tables within the template for enhanced data manipulation - Expertise in handling 'Build Selections Data' is a plus Ideal candidates for this project should be proficient in Excel, with a strong understanding of data analysis techniques and tools. Experience in creating custom Excel templates is highly desirable.

Hi there, I'm in need of a web scraping expert to collect data from USA and Canada locations on a Maps locator. I require text data for Business Name, Address, Email, Phone, Website, and Business Description:. Key Tasks: Collect the text associated with each location and put it in a corresponding cell in a spreadsheet or Google sheets Collect all locations for USA and Canada Ideal Skills and Experience: Proficiency in web scraping and data extraction. Budget: 5 NZD To Apply: Please start your bid with "5 NZD" and briefly outline your approach to this task. Thank you,

I'm looking for a professional who can create a FFmpeg 7.1 static build with the --enable-libopencv option, alo...configuration option - Ability to troubleshoot and resolve any build issues that may arise Please only bid if you meet these requirements and can deliver high-quality work. Looking forward to your proposals. i need docker file #!/bin/bash SCRIPT_REPO="" SCRIPT_COMMIT="4.x.x" OPENCV_VERSION="4.x.x" ffbuild_enabled() { [[ $TARGET == linux* ]] && return 0 return 1 } ffbuild_dockerdl() { } ffbuild_dockerbuild() { } ffbuild_configure() { echo --enable-libopencv } ffbuild_unconfigure() { echo --disable-libopencv } ffbuild_cflags() { } ffbuild_ldflags() { } this system we can use and ffmpeg 7.1 ...

One is new and the other is aged but both are blank. You must get 1000 post karma and 200 comment karma So send me a message with the time you expect to accomplish this task

I'd like a comprehensive Excel sheet that can help me track my stock investments. Key Features: - Tracking of purchase price, current value, and dividend payments - Monthly updates of the data Ideal Skills: - Excel expertise - Experience in financial tracking - Knowledge about stock investments Please provide a sample of similar work if available.

I need a Scrapy tool setup on my website to extract names and phone numbers from visitors. Currently, I don't collect any data from my website visitors, and I'm interested in capturing this information for future engagement. What I need is to get Scrapy installed on my website to extract name and phone number from visitors on a Excel Spread sheet. Ideal Skills: - Expertise in Python and web scraping - Experience with Scrapy framework - Knowledge of data privacy laws and ethical scraping Freelancers bidding on this project should provide examples of similar projects they've completed, and ideally, have a strong understanding of ethical data scraping.

Hi there, I'm in need of a web scraping expert to collect data from USA and Canada locations on a Maps locator. I require text data for Business Name, Address, Email, Phone, Website, and Business Description:. Key Tasks: Collect the text associated with each location and put it in a corresponding cell in a spreadsheet or Google sheets Collect all locations for USA and Canada Ideal Skills and Experience: Proficiency in web scraping and data extraction. Budget: 5 NZD To Apply: Please start your bid with "5 NZD" and briefly outline your approach to this task. Thank you,

I have a spreadsheet with a single column of zip codes that I need to be concatenated into a single cell, separated by a space and "or".

I need help with an Excel project. The task involves inserting a column with basic formulae in a tab. This column will return the total costs from another tab based on two criteria. Key Requirements: - Insert a column with IF or nested IF formulas to calculate total costs. - Experience in Excel data manipulation and formula application is essential. - Ability to understand and implement basic data filtering. Please note that some questions were skipped, but your expertise in Excel will help in navigating through the project.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I need a comprehensive daily resort log in a spreadsheet format (Excel) to record and track various issues. This log should capture: - Issues from the Front Office - Food & Beverage concerns - Reservations problems - Group-related matters - Housekeeping issues - Day Spa incidents - Miscellaneous (MISC) occurrences It's essential that the log is accessible and can be updated by all departments: Front Office, Food & Beverage, Reservations, Groups, Housekeeping, Day Spa, and MISC. Ideal skills for this project include: - Proficiency in Excel - Understanding of resort operations - Good organizational skills - Ability to create user-friendly spreadsheets Experience in resort management or with creating similar logs would be highly advantageous.

I'm seeking assistance with my Excel spreadsheet, primarily focused on financial calculations and budget planning. Key Requirements: - Enhancing current formulae to improve functionality - Ensuring accuracy for budget planning Ideal Skills: - Advanced Excel skills - Experience with financial calculations and budget planning - Attention to detail Please note, the project does not require the creation of graphs, charts, or custom reports. Your primary task will be to refine the existing spreadsheet for optimal use.

...setting up an API Gateway, Lambda function integration, and deployment for an orchestration platform. This will be the initial step before we begin connecting and managing APIs on the platform. Your expertise will be critical in ensuring the foundational infrastructure is set up correctly. Once the setup is complete, I will take over the API connection process myself. Key Responsibilities: API Gateway Setup: Create and configure an API Gateway to handle incoming requests. Define and configure routes for the API to handle requests for the platform. Ensure that the API Gateway is set up to handle HTTP methods (GET, POST, etc.). Lambda Function Configuration: Create a Lambda function that will be used to process requests from the API Gateway. Ensure Lambda funct...

...arrangement (type of modification) are recorded and associated with the garment. - Internal Arrangement: The internal arrangement subtype must not be blocked when entering a part (it is not in returns blocking) - Blocking returns: If at any time an attempt is made to return a product that has already been fixed, the system must automatically block it. (aspects of internal arrangements). - Unlocking returns by authorized user: Only a user with special privileges will be able to disable this restriction and allow the return, if necessary. - Assignment: Assign the seller who owns the sale and detail it on the printout (Must be on screen) - Order: Write the details of the order on a form to send it to the tailor, thus facilitating the organization and execution of the arr...

We are a dental clinic looking to expand our patient base, specifically targeting 50 to 100 new patients each month. This includes general dental services as well as specialized treatments like dental implants. We are seeking an experienced marketing team or freelancer who can develop a comprehensive marketing strategy to help us achieve this goal. Project Goals: Acquire...into appointments. Targeted Campaigns for Implants: Specifically tailor ads and content for dental implant patients, emphasizing benefits, trust, and affordability. Website Optimization: Ensure the website is user-friendly, optimized for conversions, and able to handle new leads effectively. Tracking & Reporting: Provide monthly performance reports, with a focus on the number of new patients and return on in...

I need a script or macro that runs on opening the file that hides any row with dates more than 7 days and more from the current date. Second, need a script or macro that runs on opening the file and will turn red any cell that matches both the following conditions: a date with text in bold, and the date is today’s date or before.

I need a freelancer to help me extract data from PDF files into new Excel documents. The data pertains to purchase orders, invoices, and shipping information. I need to be able to create reports from excel and also export data as well.

...and App (that was already built) with couple of features: 1. Allow Customers Choose their Preferred daily menus (we provide weekly and Monthly Subscription) and buy Break fast for 1 week or/and Lunch for 1 week or/and Dinner for 1 week. 2. We enforce customers to subscribe at least 3 days (make it configurable) before Subscription starts 3. CMS features - Admin (we) must have access to create blank pages that will have Product Name with "Add to Cart" feature so that we can provide Live Purchase Option (Trial meals, new special item, festival items..etc) to Customers 4. We will buy domain and manage hosting server. We must have access to move the packages (website/app) between servers and also must work under any domain that we will change often. Key Features: - The we...

I'm seeking a developer to create a Power BI plugin that can: - Detect all unused columns across all tables in a selected report from a list of open reports. - Provide an optimized M query focusing on enhancing query pe...Provide an optimized M query focusing on enhancing query performance. - Generate an optimized SQL query for SQL databases that includes only necessary columns, filtered rows, and indexed joins. - Create an optimized version of the DAX code for all measures in the selected report. I will share some progress I've made on this plugin after awarding the project. The plugin needs to support both Excel files and SQL databases. Ideal candidates should be proficient in Power BI, M language, SQL, and DAX. Prior experience in developing Power BI plugins will be...

I'm in search of a proficient Google Advertising Specialist to assist in generating leads through well-targeted and efficiently set up ad campaigns. Key Responsibilities: - Understand and leverage the Google advertising platform for optimal ad performance. - Develop targeted ad sets tailored to our national audience within the real estate sector. - Maximize our return on investment through strategic audience targeting and ad optimization. Ideal Skills: - Profound understanding of Google Ads. - Expertise in audience targeting strategies. - Proven track record in lead generation and ad performance optimization. - Experience within the real estate sector is a plus. If you're passionate about digital marketing and have the necessary skills and experience, I look forward to ...

I'm seeking a skilled Mautic marketing automation professional to enhance my email web form action. Currently, the system sends form results via email to the admin. I need to modify this function to also send SMS notifications to mobile phones using Twilio, which is already set up on my Mautic platform. Key Requirements: - SMS should include full content of the form submitted by a lead. - The system should be capable of sending SMS to multiple mobile numbers, not just a single one. - The SMS content should be sent to all form content, regardless of the number of fields in the form. Ideal Skills: - Proficient in Mautic marketing automation. - Experience with Twilio integration. - Familiarity with modifying email web form actions. Thanks for your help!

...Scalability: o Simple expansion of AI functions (e.g. new FAQ topics). - Monitoring: o Real-time statistics on response times and chat activities. - Hybrid model: o Escalation to human agents for complex or specific queries. Open questions/ideas for the discussion 1. should the bot support multilingualism (e.g. German/English)? Yes, simply switch language at the customer's request 2. is a voice-to-text function for voice messages desired? Yes but not a must have 3. how should complaints or unusual enquiries be dealt with in the chat? Escalation to us as platform owner via email or WhatsApp message 4. should workshops be able to make enquiries to customers via the bot (version 2)? Yes, but only in version 2.0 It should be possible for customers to query the current status....

I need a skilled electronics engineer to help design and implement a TFT display with Arduino project. The primary function of the TFT display in this project is to serve as a user interface for controls. Key Features: - Touchscreen Controls: The user interface will be based on a touchscreen, so experience with touchscreen calibration and integration with Arduino is critical. - Graphical Controls: The interface should incorporate graphical controls such as sliders and dials. Ideal Skills and Experience: - Proficiency in Arduino programming and electronics. - Experience with TFT displays and touchscreen interfaces. - Skills in designing user-friendly interfaces. - Familiarity with creating and integrating graphical controls. Please provide examples of similar projects you'...

...streamline operations and enhance customer experience. Required Skills and Qualifications: Proven experience as a Business Analyst, with a focus on the banking or financial services industry. Strong understanding of banking operations, regulations, and compliance requirements. Experience in process mapping, business process reengineering, and requirement gathering. Proficient in tools such as Microsoft Excel, Power BI, JIRA, and other project management or reporting tools. Excellent communication and interpersonal skills to work effectively with cross-functional teams. Ability to manage multiple priorities, meet deadlines, and work independently. Strong analytical, problem-solving, and critical-thinking skills. Knowledge of digital banking, fintech, or emerging banking technolog...

...professional who can perform sophisticated data manipulation tasks and generate various types of charts using VBA. The ideal candidate should be proficient in Excel and have substantial experience with VBA programming. Key Tasks: - Data Processing: This includes, but is not limited to, sorting, filtering, and the use of pivot tables. - Chart Generation: Create a range of charts including bar charts, line charts, and pie charts. Please note that specific data sources and the primary goal of the data processing are yet to be determined. Therefore, flexibility and adaptability are highly valued. Ideal Skills: - Proficiency in Excel, particularly with advanced features. - Extensive experience in VBA programming. - Strong analytical skills for potential ...

I'm in need of a skilled programmer who can help me retrieve content from Rednote (XiaoHongShu) and post it on my website using its official API. This should include a filtering or content review function before the content goes live. Key Responsibilities: - Extract and post content from Rednote to my website's homepage. - Implement a filter for images, text, and videos. - Use keywords and user ratings for content evaluation. Ideal Skills: - Proficient in programming and API integration. - Experience with content filtering systems. - Familiarity with XiaoHongShu/Rednote is a plus.

Dear Freelancers Please read carefully what we need We have a ticketing solution based on uhelp in Laravel We had an other dev that don't respond anymore Here is the bug you need to fix: -Mass Import user don't work -We still have a blank on customer ticket creation -You can't assign to self and also assign to other people at the same time (maybe not an issue for now) -Subcategory need to be related to the main category not just a custom field like you did -Announcements needs to be like a popup -We have some little bugs when switching english to french -And also the login page is in english it should be french We are also looking for long term partnership as you'll do further improvements, maintenance and support for us Write piano in your bid to show us th...

...Support History and Bookmarker - Support Mirror Screen on iPhone/Android Mobile - Virtual Remote Controller Search/Switch channels from STB on Mobile Phone for Box(TV) and touch board. - Edit Channels from STB, including Move, Rename, Delete, Lock,set favorite,sort. - Support SatFinder, APP shows the signal signal and beep while installing the dish. *Cast Supported STB: • All STB with Cast TV function • All Android Phone & Tablet compatible with the new app (Requires Android 5.0 and Above) • All iOS Phone compatible with the new app Ideal Skills and Experience: - Proficiency in cross-platform app development - Strong understanding of DLNA and other casting protocols - Experience with implementing screen mirroring and file sharing features - Past work with in...

You: Excellent English, Expert at Excel, Experience in Inventory Management I have approx 6 excel spreadsheets with inventory for a vintage jewellery brand (only 1 item for each piece), we currently use excel to manage the data and we are moving to airtable, the airtable space is being built but we need to ensure the data is uniform so we can easily import it into airtable. This data will be imported into Airtable, so it needs to be uniform and some of the data entered needs to be tidy so that it matches the drop down we have in Airtable. There is a specific template for the data that will need to be adhered to. We have one spreadsheet for each dealers jewellery we wish to list. We want to add the dealers data into one template so we can import it in one clean im...

I'm in need of a website for my EdTech application. The primary function of the website is facilitating content delivery and user interaction. Key Features: - Hosting and delivering video tutorials - Enabling 1-to-1 video calls, booked in advance The website needs to be optimized for desktop t use. It does not require mobile optimization at this time. Ideal Skills and Experience: - Strong web development background, specifically in creating interactive, content delivery websites - Experience with EdTech platforms preferred - Knowledge of optimizing websites for desktop and tablet - Understanding of integrating video hosting and conferencing tools into a website. I look forward to your proposals.