Excel vba extract cell commentsJobs
...should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the given fr...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I'm in search of a Professional Engineer or an Architect who can review a set of drawings I've completed for a residential building project in Pennsylvania, and provi...Skills/Experience Required: - Licensed Professional Engineer (PE) or Architect - Familiarity with residential building projects - Understanding of Pennsylvania building codes and regulations - Responsibilities: - Review of the project drawings - Provide professional sign-off once satisfied with the review - Support in addressing any feedback/comments regarding code compliance issues from the city. After reviewing, if you have any comments or found code compliance issues, I'm open to picking up those to rectify them before the sign-off. I'm looking forward to successfully nav...
As a business, I'm looking for a skilled freelancer to help me create an extractor for past paper content from multiple different exam boards/papers from different subjects. This will be from PDF files and organize it into a JSON format. This will help in creating a structured database for our educational materials. Key Requirements: - Extract data from PDF files: The freelancer should have experience in data extraction from PDFs. The goal is to extract content like questions, answers, and any other relevant details. This extractor should be able to be used for different exam boards - Organize data by year, subject, and difficulty level: The extracted data should be categorized based on these parameters. This is crucial for our business as it will help us create a user-...
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
...artist's social media accounts and generating creative, engaging content to captivate our audience. Key Responsibilities: - Develop a social media strategy to increase the artist's online presence and fan base - Create and curate captivating video content that aligns with the artist's brand - Schedule and post content across various platforms - Engage with the artist's audience and respond to comments and messages in a timely manner - Analyze performance metrics and make data-driven decisions to optimize content Ideal Candidate: - Extensive experience in social media management and marketing - Proven track record of creating and implementing successful social media campaigns - Proficiency in video content creation, with a keen eye for detail and storytellin...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I'm on the lookout for a skilled freelancer who can expertly scrape old leads from multiple sources. These sources include social media platforms, business directories, and various websites. Unfortunately, the purpose of this project hasn't been specified, but the successful freelancer must be capable of performing high-quality data scr...experience and samples of past work - A detailed project proposal outlining your approach. Your proficiency in using software and tools for data scraping, knowledge of data protection laws, and understanding of various databases will make you a top contender for this project. Time management skills and meticulous attention to detail are also crucial. The goal is to efficiently and accurately extract as many old leads as possible from the...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
2 excel files with VBA macro as per customer requirement
...jump to a web landing page. Local news and stories Experience in 2D and 3D animations, as well as motion graphics, is highly desirable. A background in short-form social media content creation will set you apart. Creativity, attentiveness, and a high level of organisation, speed are also crucial for this task. We run 3 big social media sites, and a web site so the core job is to engage and get comments, reach and shares AND jumps from social media out to tge web site. You must be able to research stories, scrape sites with permission if needed, use Ai big time, report on your videos performance. We dont want a lazy person that just makes content that doesnt know how effective it is. We need a person that wants to win and if you win we will share the $$ We need 4 short snack ...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm looking for an expert to assist with an important aspect of my Autocad project - calculating the material needed for ducts from drawing to excel sheet. Your main task will be to extract the dimensions and quantify each type of duct in the drawing. Key Responsibilities: - Extracting precise information from Autocad drawings - Accurately entering data in Excel for duct types and dimensions Skills and Experience: - Proficiency in Autocad and Excel - Strong understanding and experience in drafting and design - Excellent attention to detail - Experience with duct design or HVAC systems would be advantageous. Please note, material types are not specified for the ducts. This project primarily focuses on quantity and dimensions.
As a client, I am looking ...should limit voting to one time per institutional email address. If an invalid email is entered, the interface should display an error message. 2. Voting Display: The voting results should be displayed in real time using bar graphs. It's crucial for the freelancer to have experience in creating such an interactive visual display. 3. Commenting Feature: I want users to be able to create notes as comments under the poll. This gives people a space to share thoughts or elaborate on their vote. The ideal freelancer for this job will have a strong background in web development, with specific experience in real time data visualization and email validation techniques. Knowledge about implementing commenting functionalities on a webpage will also be highl...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I'm seeking a talented designer who can create an eye-catching and engaging professional bio for my new prosthetist, Stephen Deaton. Stephen is networking in our local community and trying to establish business referrals. Key Requirements: The bio should designed in a friendly and approachable tone, making it easy for Stephen to connect with various professionals and pot...for a designer who can present Stephen's professional achievements with a matching professional layout. I have included several attachments that include the written content of his bio, three pictures of Stephen and our company logo. The address and phone numbers of our company must be included in the layout: 1389 West Main Street, Lexington, KY 40508. Tel: 1-859-266-5500. Fax: 1-859-266-5523 Cell...
I'm in need of a proficient Tiktok Account Manager to focus exclusively on my Tiktok platform. Key tasks will include: - Creating and posting engaging content: You should have a knack for understanding what type of content will drive engagement on Tiktok specifically. The posting frequency will be every other day. - Engaging with followers: This will comprise of replying to comments, direct messages, and other forms of fan engagement to solidify community. - Running ad campaigns: This includes campaign creation, monitoring, and tweaking as necessary for optimal performance. - Managing the Tiktok Shop The ideal candidate should have a proven track record in Tiktok management including content creation, follower engagement and running successful ad campaigns and managing the t...
I'm seeking a skilled professional to help me with a research project. The specific deliverable is to find and provide 1,000 email addresses from Apollo. Key Requirements...professional to help me with a research project. The specific deliverable is to find and provide 1,000 email addresses from Apollo. Key Requirements: - Industry: The contacts should pertain to the industry I'll list for you. - Freshness: Email addresses need to be less than 3 months old. Ideal Skills: - Strong research skills: the ability to efficiently navigate through Apollo's platform to extract relevant email addresses. - Attention to detail: ensuring that the email addresses are recent and accurate. - Good understanding of various industries: to assist in collecting contacts aligned wit...
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep k...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a skilled developer to create an automation bot for Telegram Channels. This bot will have the essential functions of: - Auto-joining channels - Extracting basic channel information including the description and links I want the bot to be able to extract the following specific information from the channels it joins: - Channel Name - Channel Description - Channel Links - Member Count The frequency of this extraction should be set to a weekly basis. Ideal skills and experience for this job would include proficiency in Python or a similar programming language, previous experience with Telegram's API, and prior experience creating chatbots or automation bots. Expertise in web scraping technologies is also a must.
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
...objective is to grow the social channels, increase engagement and drive more traffic to our website. Crafting engaging and relevant content tailored to each platform is super important. Automating tasks would be a big advantage although not necessary. You will need to keep track of posts in a spreadsheet that will include: time of post, length of content (text/video), number of views, likes, comments, shares after 1 day. We are open for more ideas! If you BREATH social media, this job is for you! You will be paid weekly milestones. In your proposal please include a weekly price for your work. Thanks and good luck!...
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
...handling sales inquiries and tracking orders. * **Chatbot Features** - The chatbot should be capable of handling customer support tasks, answering sales inquiries and tracking orders seamlessly. * **User Interaction** - The chatbot needs to be user-friendly for both Stone Crusher Owners and customers. * **Database Interaction** - The bot should interact with our MySQL database to extract data when needed. It doesn't need to update the database, just fetch necessary information when required. * **Skills and Experience** - Strong background in AI chatbot development. - Experience with Gen-AI platforms. - Proficiency in working with MySQL databases. - Knowledge about Stone Crusher operations would be a bonus. * **Sample QA** User: What is Address o...
I'm in need of a detailed CAD model of a semi-truck, emphasizing the under-the-hood engine components along w...in need of a detailed CAD model of a semi-truck, emphasizing the under-the-hood engine components along with a comprehensive solid oxide fuel cell, including its full design with individual cells. Requirements include: - Detailed modeling of a semi-truck's engine components - Comprehensive fuel cell design with individual cells The ideal freelancer for this project would have substantial experience in CAD modeling, particularly in the automotive sector which includes the understanding and ability to depict the complexity of semi-truck engines and fuel cells. Knowledge of the latest semi-truck specifications and an understanding of detailed fuel cell...
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...
Proofread and edit a 975 word article. Audience is a senior level executives in the fintech and banking sector. Change wording liberally as you see fit to make the article more sophisticated, avoiding cliches and unnecessary wording. Some comments are already added with track changes. The article could even be shortened. Seeking a final document without any track changes.
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
Cher Freelancer, Je suis à la recherche d'une personne femme/homme s'exprimant parfaitement en français dans le but de pouvoir appeler des casinos français d'une liste excel avec les numéros de téléphone. Votre mission sera la suivante : - Appeler chaque casino - Obtenir les informations demandées dans le fichier excel - Mettre à jour le fichier - Rappeler les casinos qui n'ont pas pu vous répondre au 1er appel - Répéter l'opération mensuellement ou à convenir Les appels peuvent être effectués en semaine comme en week-end. Cependant, ceux-ci devront être fait le soir dès 20h30. Je recherche une personne avec collaboration sur le long...
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
...using CloudQuery. Our project involves extracting and integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualificati...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
...specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Ability to work independently and meet deadlines Duration and Budget: This mini-project is expected to require approximately 15 to 20 hours. The budget for the task is 200 EUR. How to Apply: Please submit examples of previously created financial models along with your applica...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
