Excel vba sheet name variable jobs
I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .
I'm seeking a compelling name for my new agency. We specialize in design thinking, providing top-tier UX expertise for enterprises across the EU, all from our beautiful base in Greece. Our advantages is speed of work with great quality, by utilizing best in class processes and experienced specialists Key Attributes: - The name should convey a sense of innovation. We're not just about keeping up with the trends; we're about setting them. - It should also subtly reflect our Greek roots. A hint of elegance and trustworthiness from our heritage wouldn't hurt, but the primary focus is on conveying our innovative spirit. Ideal Skills and Experience: - Exceptional creativity and linguistic skills. - Experience in branding and naming agencies. - A strong unders...
We are Company, an AI-driven EdTech company based in India, seeking a talented freelance video creator to produce an engaging, high-quality product/company video for Company. Company is an innovative AI-powered solution designed to revolutionize the education sector through: AI Evaluation of Manual Answer Scripts Digital Answer Sheet Evaluation AI-Generated Question Papers with Bloom’s Taxonomy Mapping to CO & PO Our product also explores applications in healthcare, including scanning prescriptions, generating personalized reports, and managing patient files. Key Objectives: Highlight Company core features and benefits Showcase real-world applications in education and healthcare Create a compelling narrative that appeals to universities, government bodies, ed-tech firm...
I am in need of a Google Sheets expert who can assist with creating custom functions and formulas to facilitate conditional formatting and dynamic updates within the sheet. Key Responsibilities: - Develop and implement custom functions and formulas in Google Sheets - Automate various processes using scripts - Ensure effective use of conditional formatting for data visualization and monitoring - Ensure data security and privacy compliance The ideal freelancer will have a deep understanding of Google Sheets and a proven track record of developing complex scripts. Experience with integrating data from Interakt WhatsApp will be an added advantage. Please provide examples of similar projects you have completed in your proposal.
I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.
I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...
I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency
I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.
I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID
I'm looking for a talented video ...short 2 min videos,, we will need more than 500 such a video work, so I hope you can be working for a long-term with us. The explainer video should be 2-20 minutes long.. Budget is not negotiable, until we get enough customers to our website and/or monetized our YouTube channel by that mean I will need at least 1M subs and/or 1M views in our Chanels of the video ---- Please check in this google sheet, send me draft version of video 24 edited video according to the step in tab 'Standard Guideline', if you can do it accordingly, then I will send award to you for the rest of the other videos : ; ----------
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.
I need 20 thousand companies name and Email. This should be only from CHINA region and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department..
I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics shou...percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start propos...
I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, cons...businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be h...
I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.
I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.
I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.
Hi there I'm seeking a professional who can help me gather data from 100 UK websites. This data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. Budget: Flat rate 5 NZD per...
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...
I have numerous Excel workbooks containing sales data that need to be cleansed and transformed into a single table. This project requires expertise in data processing and analysis. Key Tasks: - Cleanse the data from individual workbooks to a single workbook table - Transform the cleansed data into a single comprehensive table -there are approximately 300 workbooks, that each have about 8 sheets of similar data that is not tabled -extracting "amount paid to installer" sheet information is not part of this scope, but could be added at additional cost if it make since to extract that data at the same time. Do not include this in your price, but if interested chat message about details. The final table should include: - Date of sale - Customer details - Budget costs -...
I'm in need of a professional who can create detailed 2D DWG drawings of roller shapes for a sheet metal forming machine. These rollers are essential for a cold rolling mill process, which typically involves 10 to 12 stages for each section. The drawings need to be comprehensive, with dimensions incorporated to ensure precision. Ideal skills and experience: - Proficiency in producing 2D DWG drawings - Prior experience with machinery design is highly advantageous - Attention to detail and ability to incorporate precise dimensions in the drawings - Understanding of the cold rolling mill process would be beneficial.
I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of science. The analysis should specifically c...presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demonstrate experience in analyzing academic papers and their experi...
I need a cross-platform (iOS and Android) AppSheet application. The main functionality involves scanning a QR code, which contains a URL leading to different forms based on the code's parameters. Key Requirements: - The app should be able to interpret a QR code and, depending on the URL it contains, direct the user to the appropriate form (form 1, form 2, etc.). within the app sheet - The forms need to be interactive and allow users to fill them out before submission. Ideal Skills: - Proficiency in AppSheet - Skills in creating interactive forms within an app Your proposal should highlight similar projects you've worked on, and please provide examples of your cross-platform apps.
...Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Create jobs to automatically update campaign data (e.g.: every 5 minutes). Store metrics history for temporal analysis. Automatic Insights Calculation: Develop algorithms to identify trends (e.g.: "CPA increased by 20% in the last week"). Report Export: Generate PDF/Excel with filtered data (e.g.: performance by period, platform). 3. AI System AI Integration in Chat: Connect to an NLP API . Train the model to answer technical marketing questions (e.g.: "How to improve ROAS?"). Automatic Insights Generation: Develop scripts for predictive analysis (e.g.: Python with Pandas/Scikit-learn). Example: "Suggest a 15% increas...
I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.
I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.
...Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition Logic: The flow should...
...incorporate multiple real-world factors affecting demand. ✅ We have an in-house API that will provide real-time data – you need to work with our developers to connect the forecasting model to this API. ✅ High accuracy needed – the forecast should help improve inventory planning, supplier management, and backorder handling. Ideal Solution ML Models: XGBoost, LightGBM, Random Forest for multi-variable forecasting DL Models: LSTM, Transformer-based models for handling complex dependencies Hybrid Approach: Combining traditional statistical models + AI-driven approaches Nuera Link: (If applicable, let us know how you can integrate it into forecasting) Available Data Reports for Forecasting We have a comprehensive dataset that captures everyday inventory, sales, in-t...
I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail
I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.
...Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition Logic: The flow should...
I'm looking for an expert in and Bannerbear to create a full scenario that automates the design of a 300x250 banner ad for brand awareness. - The scenario should take inputs from a Google Sheet, including a logo, brand colors (primary, secondary, tertiary), font type and style, call to action, ad copy, ad style, and an image. - The design style should be adaptable, with options for modern, bold, or minimalistic, all selectable through the spreadsheet. - The final output should be a PNG file. Ideal candidates for this project should have extensive experience with and Bannerbear, and a strong understanding of banner ad design for brand awareness purposes. Please provide examples of similar projects you've completed in your bid.
I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe
I'm looking to have my bank statements for the year summarized. The statements are in PDF format. there are 2 accounts,. need a year end summary for each account for tax purposes. income and expense with sub categories per account year end. and a reconstitued balance sheet , statement fo cash flows, and income statement using only these statements, Requirements: - The summary should categorize transactions and provide monthly totals. - All transactions should be included, not just credit or debit transactions. Ideal Skills: - Proficiency in data analysis and financial summarization. - Experience with PDF data extraction and AI tools. - Attention to detail.
I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a fresh perspective is needed. 3. I don't need...
I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. I have added an explanation video and sample excel data sheet to the files. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills t...
I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.
Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Yearly Overview Section...
I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure
My website is currently down due to some recent changes I made to my DNS settings. I have modified various DNS records, including A, CNAME, and MX. I am in need of an experienced professional who can: - Identify the root cause of the website issues - Repair the DNS and name server settings - Ensure that the website is up and running smoothly - Provide insights to prevent similar issues in the future Ideal skills for this job would include a deep understanding of DNS settings and name server configurations, as well as experience in troubleshooting website issues.
I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.
I need 20 thousand companies name and Email. This should be only from CHINA region and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department..
...criteria and configurations. This enables flexible, customized loyalty programs to be set up for each company. What's more, a future update of the platform will facilitate payments via a QR code. Customers will then be able to pay for their purchases directly via the application, offering an even more fluid and modern experience. Pricing - Basic: $15/month - Loyalty: $15/month - Pay: Percentage (variable according to usage) - 1-year commitment Sales commissions 
Sales staff who sell the solution are paid on a commission basis, and receive 100% of the first two months for each sale made: - Base package sale: $30 ($15 * 2) - Basic + Loyalty package sales: $60 ($30 * 2) Development and expansion EcoBill manages the development of its platform in-house, and is working ...
Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel.
I have a spreadsheet that requires some help with data formatting, particularly with date and time entries. I need someone who can fix the incorrect date/time entries so that the spreadsheet is accurate and usable. Ideal skills for the job include: - Proficiency in Excel or similar spreadsheet software - Strong attention to detail - Experience with data formatting and troubleshooting
I'm seeking a professional who can craft a compelling financial presentation for institutional investors, primarily aimed at securing investments. The presentation, approximately 20 pages in length, will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business conte...