Vlookup excel vba jobs
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring data from PDF to Excel.
As the project manager for this task, I am urgently in search of an Excel expert who can impeccably execute logical formulas within spreadsheets. Key Responsibilities: -Primarily, your main task would be to construct logical formulas, with a particular emphasis on IF, AND/OR, and NOT statements. -Your role would also involve troubleshooting any formula-related issues that might arise during the process. Ideal Skills and Experience: -The ideal candidate should possess a high level of proficiency in Excel, especially in creating and implementing logical formulas. -Proactive problem-solving abilities and a high level of attention to detail would also be beneficial. ** Project is requiring rate spead sheets to communicate with each other. Buy to sell rate sheets, if file n...
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I am in need of a skilled bookkeeper, proficient in using Excel. The main task will be daily upkeep of our financial records. Key Responsibilities: - Maintaining daily bookkeeping and financial transactions Ideal Skills and Experience: - Strong knowledge in Excel - Prior experience in bookkeeping Please note, I require daily updates on progress and status. If you're detail-oriented and are comfortable with Excel, you're the perfect candidate for this task!
I'm in need of an expert in Power Bi for data analysis revolving around investment performance. The specific data in focus will be return on investment (ROI), portfolio performance, and risk analysis. Ideal applicants should possess: - Expertise in Power Bi and data visualization - Experience in presenting complex data in a clear, concise manner Your primary task will be the transformation of these raw metrics into a digestible format that can guide crucial investment decisions.
I'm seeking an experienced PHP Laravel developer well-versed in PHP 7.4 for my project. The main task is: - Data Manipulation and Storage - Convert Selling Package, Gimmick Out, and all of Selling Out row can be inserted to the database and connected with selling_reports id from each row. It's essential ...Manipulation and Storage - Convert Selling Package, Gimmick Out, and all of Selling Out row can be inserted to the database and connected with selling_reports id from each row. It's essential that the developer had a deep understanding and hands-on experience with: - PHP 7.4 - MySQL database for efficient data manipulation and storage I need anyone who can convert data from Excel in Laravel, I need who can restructuring from Excel into the database I pro...
I'm looking for an expert who can summarize and visually represent my data using bar charts. The data is currently in an Excel spreadsheet format. Your tasks: * Derive insightful summaries from the given data to help me understand it better. * Create engaging and understandable data visualization using bar charts. Skills & Experience: * Proficient in Excel and data analysis. * Excellent command of statistical analysis. * Should have a good eye for design as well. * Proficient in creating bar charts and data visualization using other appropriate tools. *Identify and explain why statistical method(s) was/were chosen *Summarized data provide relevancy for research paper publication- identifying P factor etc * Color correct chart/data to maximize presentation Stud...
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and can deliv...
I'm in need of an experienced Excel professional who can help me write some basic excel reports. These reports will consolidate information from several sources into one cohesive view, bringing an understanding of non complex data sets at a glance. The required Excel operations include: - Averaging data - Merging information from multiple reports into one Types of information to be processed: - Dates - Names - Current month's dues The reports should be formatted as tables. Ideal candidates should have extensive experience with advanced Excel functions and calculations, and a keen eye for detail in data consolidation. Strong understanding of data layout in Excel table format is essential.
...com/about/ ) - This search engine will use specific Dorks to search if these words exist on some of the sites previously selected by me and added in the Profile of my own Google search engine; - Then the links to the pages of the preselected websites that my Google search engine said that these words exist will be placed in an Excel in Google Drive; 2nd Stage (2nd software) - Then whenever I click on a button in the software, the software will look for the links in Excel from Google Drive and open these sites/pages; - There will be many sites (potentially more than 1000 in the short term); - As there will be many websites, I think they should be opened in a lightweight browser (Lynx or headless); - Some of these sites required a proxy to open; - Then whenever I click on...
Seeking a dynamic advertising strategist who can amplify our presence on Facebook, Google Ads, Instagram, and LinkedIn. With a focus on Home Services (electrical services), your campaigns should drive quality leads and build efficient sales funnels targeting homeowners, property managers, and B2B audience. Ideal skills and experience: - Proven track...platforms - Deep understanding of the Home Services industry and our target groups - Expert in formulating strategies for lead generation and sales funnel optimization - Ability to provide actionable insights from campaign data Your role will be instrumental in positioning our services to the right audience, increasing our reach, and driving sales. If you have the experience and the drive to excel in this role, we would like to hear...
More details: What type of information is included in each listing? Business name, Address, Phone number Is there any additional information that needs to be included in each listing? Website URL, Description How would you like the listings to be organized on your website? By location
I'm seeking a professional who excels in creating user-friendly Excel spreadsheets. Your task will be to incorporate a Comprehensive Home Loan Repayment Calculator, a Detailed Monthly Expense Tracker and a Proactive Savings Planner into one efficient tool. Key Features: - Home loan repayment calculator that dynamically updates as variables change - A monthly expense tracker with features such as: * Tracking of income and a range of expenses * System built on the principles of a flexible budget - A savings planner to help set and track savings goals Ideal experience and skills: - In-depth understanding of Excel functionalities and formulas - Prior experience in creating personal finance trackers and calculators - Knowledge in financial budgeting principles, particu...
Application should optimize cost of transportation for the company employees. Based on demand for a specific date which departments of company are working, it should provide the list of people who are most cost-effective to transport to destination. There are predefined bus routes with addresses of employees. Based on this in... There are predefined bus routes with addresses of employees. Based on this information application should provide list of names, which employees should be working on that day and provide, which lanes should be active, keeping in mind the cost effectiveness. Cost-effectiveness can be calculated based on mileage on the route and the number of routes (buses). At the moment all that is present in excel, but it can be modified and delivered in whatever format it ...
...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...
As the project owner, I'm looking for a proficient freelancer who can demonstrate competence in statistical data analysis using Excel. While I didn't specify the exact tasks in the questionnaire, the freelancer should be versatile in performing: - Descriptive statistics - Hypothesis testing - Regression analysis The purpose of this analysis is also open-ended. It could be for decision-making, identifying trends, or forecasting future outcomes. Ideal candidates should possess: - Robust knowledge of Excel and data analysis tools of the software - Previous experience with statistical data analysis projects - Ability to understand and respond effectively to project needs In your application, even though I didn't specify what you should include, it would be ...
I'm looking for an Excel specialist with intermediate proficiency to assist with data analysis, forecasting, and supply chain management tasks. Here’s a summary of the key responsibilities: - Perform extensive data analysis - Develop forecasts - Manage supply chain operations Key tasks will also include: - Data cleaning and preparation - Creating intuitive, effective data visualizations and statistical analysis Although I don't have an explicit preference for the types of data visualizations, I expect the chosen freelancer to make recommendations and create charts/graphs that best represent the data in a clear and comprehensive manner. For this project, experience in forecasting and supply chain management is crucial. Freelancers who can demonstrate prior expe...
Just need someone to transfer data from provided PDF to provided Excel Template
I require data entry services to extract mixed numeric and text data from one unstructured PDF file, and input it into an Excel file. The project requires attention to detail to ensure accuracy of inputted information. I am preferably seeking someone with experience in data entry, with the ability to interpret unstructured data, and proficiency in Excel.
I have here an Excel document with adresses from our donors (391) and a donor system. We used the document for many years, however, we want to have this digitally. You need to change each name in the donor system into “Yes, by mail”. First: Go to “Daily Work” - “Contacts” and then 1. search for the name 2. pop up open contact 3. go to tab communication and 1. change “magazine” from no into “yes, by mail”.
I am seeking a highly meticulous individual for extensive text-based data entry. Key Responsibilities: - Enter all information provided into an Excel spreadsheet. - Ensure data is alphabetical. Ideal Candidate: - Proficient in Microsoft Excel. - Reliable and strong attention to detail. - Excellent organization skills to sort data alphabetically. - Prior experience in data entry tasks. The successful candidate must be accurate in their work and follow the designated order strictly. It is imperative to keep the project organized and easy-to-read.
...assigned to each batch in order to maintain traceability both in terms of cost and material origin Pouching Department This Department has two types of machines. 2 head and 4 head. Depending on the SKU the supervisor chooses which type to Pouch the batti in. Currently there are 8 machines 4 - four head, 4- two head. These are counting and packing machines. A sample manual report being maintained in excel format will be shared. Each Worker is paid on the pouched quantity in RB quantity ( not dipped quantity ) one worker per machine. Wage is calculated on a contractual rate decided as per SKU, if workers dont reach a minimum wage it is supervisor decision to give minimum daily wage or not. Stock of pouched batti is required. In kgs. The amount of batti pouched is deducted from d...
I'm on the lookout for an adept React developer to create a specific React component. - Design: The design for this component is already decided, so you'll need to be able to accurately transl...Design: The design for this component is already decided, so you'll need to be able to accurately translate my target aesthetic into functional code. - Libraries: For this project, experience with MUI is essential as I'd prefer that the developer work with this particular library. - Functionality: The principal functionality that this React component should have is a collapsible layout. To excel in this job, the ideal candidate will have a proven track record working with React, MUI, and implementing complex user interfaces. Let's work together to bring this ...
I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bonus.
I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the databa...after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...
I'm looking for a proficient Excel expert who can incorporate specific types of filters into my workbook. The applicant must be skilled in applying the following filters: - Filter by Value: This will separate data based on specific criterion I provide. - Filter by Color: Assist in classifying certain data points using different colors. - Filter by Date: Help in organizing data chronologically. Specifically, these filters must be applied to specific columns of the worksheet, improving data management and analysis. In addition to the filters, I also require the following features: - Highlight Filtered Results: Highlight specific extracted information for easy identification. - Sort the Filtered Data: Arrange the outcomes in a particular order for better examination. - Searc...
I am in need of a proficient Data Analyst skilled in Data Visualization and Descriptive...this project is understanding and interpreting data from various sources. Key Project Requirements: - Proven experience in delivering data interpretation through Visualization techniques. - Proficiency with Descriptive Statistics, adept at summarizing the main features of the collected data. - Experienced in working with multiple data sources. Data in the following formats will be utilized: - Excel Spreadsheets - CSV Files - Online Databases Ideal candidate should be detailed-oriented and able to accurately interpret and present complex data sets. Your role would significantly influence important business decisions and strategies, so it’s crucial that information is accurately and clea...
I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirme...
Excel sheet data typing Im a hard work person and i know how to work in excel sheel im a CA (Computer Application) student i will do my best for this job
I'm in need of an individual expert in Excel who can perform some simple calculations on my attached spreadsheet. The details of the task are shown in the spreadsheet, it won't take an expert too long to finish.
Hello, I am looking for a talented and affordable video editor to assist with editing 2 hours of content. This is a continuous project, and I am seeking someone who can de...rate for the initial 2 hours of content editing. As this is a continuous project, we can discuss long-term rates and payment terms once the initial project is successfully completed. Application: If you are interested, please send your portfolio or examples of your previous video editing work. Include a brief description of your experience with video editing and any specific skills or tools you excel in. If you have experience with Kannada language content, please highlight that in your application. I look forward to finding a reliable and skilled video editor to collaborate with on this and future projects. ...
I require expert assistance in analyzing financial transaction data using Excel. The project's primary goal is quantitative data analysis. Through this project, I aim to draw valuable inferences and insights. Key responsibilities: • Analyzing large datasets related to financial transactions • Applying advanced Excel formulas and functions to dissect data Ideal Candidate: • Proven experience in data analysis, specifically within financial sectors • Proficiency in Excel for data management and analysis • An excellent understanding of quantitative data analysis methods.
I need an expert in Excel to build a robust calculator capable of handling complex mathematical equations and statistical analyses. This tool should be designed to deal with less than 100 distinct variables or data points. Key Requirements: - Excel proficiency with in-depth knowledge of mathematical and statistical functions. - Prior experience in building sophisticated Excel calculators. - Ability to create a tool that imports data from external sources automatically. The ideal candidate would have a strong statistics background and be capable of understanding the mathematical formulas I'll provide. The automation of data importing is crucial as it will streamline the usability of this calculator. The project is to calculate drivers pay and fuel consumption...
You need to collect local business details out of Facebook groups and put them in an excel file. Data fields are: Source (posting url) Kind of business (like “painter” for instance) Name of business Contact Person Name (optional) Phone if available Email if available Phone is preferred but if not possible then email is ok. Please make your offer for 100 data rows aka 100 businesses and mention the word Australia at the beginning of your application so I know you have been reading the instructions. We will provide the local Facebook groups where the businesses post. Some of them you need to join first, others are open.
...planning a similar project there: Domestic News A regional online magazine was to be created and reproduced in a franchise. Each franchisee will fill the contents themselves. The website appears under a subdomain, for example www.domestic-news/manila I need: - An easy-to-use CMS with login for every franchisee o Customer data (company, name, address, email, web, telephone) o Customer data – export to Excel o Rubrics prepared according to template - Deactivation of categories without content - Expansion of categories by franchisees - Frontend design is already sketched (in the appendix) - All images in 3:2 format automatically cropped - Home page with selection of regions/locations - Version for screen, tablet and mobile phone - Backend language: English Design template, a...
Need an expert to clean up my textual data currently stored in an excel spreadsheet. This includes: - Fixing the formatting issues present in the dataset - Removing any blank cells to create a more organized and streamlined data view Please note that while the project does not require any specific end format for the text data, I'm looking for someone with a keen eye for detail who can make suggestions to improve the data readability and utility. Success in this project would involve achieving a tighter, cleaner dataset, hence your experience and familiarity with Excel and data cleaning techniques will be crucial.
This business intelligence project requires creating a comprehensive database of all the flooring manufacturers across the USA and Canada. I specifically need information about companies producing hardwood, laminate, and vinyl flooring. Key tasks includ...identifying marketing contacts in each company, complete with their contact information. - Companies can be of any size, from large corporations, medium-sized businesses to smaller local operations. Ideal Skills: - Exceptional research skills - Experience in lead generation and data mining - Familiarity with the flooring industry, specifically hardwood, laminate, and vinyl - Proficient in Excel or similar database management tools This project is great for freelancers with an instinct for detail and diligent data search ...
I am looking for an expert in Excel especially well-versed in the Norwegian language to assist me in data entry and creating database leads for marketing purposes. The focus is on signage companies in Norway. The ideal candidate should be proficient: - In Excel data entry and organization - Skilled in designing and managing databases - Must have an understanding and fluency in Norwegian language. -this project requires phone calls and web searching The main task will revolve around generating leads through database creation for targeted marketing campaigns (Signage companies in Norway). This project requires a good grasp of lead generation strategies in addition to the aforementioned skills. Please place your bid keeping in mind all the requirements stated.
Objective: To set up and configure Microsoft Office applications for a small business in New Delhi, India, to modernize operations and enhance productivity. Key Requirements: Primary MS Office Applications: Excel: For managing data, performing calculations, and creating reports. Outlook: For email communication, scheduling, and task management. SharePoint: For document management and collaboration among team members. Installation Scope: The MS Office suite will be installed on 1-5 devices to accommodate the needs of the small business. User Proficiency: The users of the MS Office suite are beginners. Therefore, the setup will include basic configuration and user-friendly customization to ensure ease of use.
I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, continge...
More details: What type of data do you need to type into the Excel sheet? Numbers How many columns and rows are there in the Excel sheet? 10-20 Would you like me to create any specific formulas or functions within the Excel sheet? Summation formulas, Average formulas, Lookup and reference formulas
I'm searching for an experienced Excel Macros Specialist to help me edit my document. Quick easy job. Won't take more than 10 minute.
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...
I'm seeking a skilled data analyst to create a comprehensive KPI dashboard for our digital transformation project. This will involve various data sources such as sales, marketing, and financial data. Key Responsibilities: - Integrating KPI performance from diverse data sources into the dashboard. - Tracking specific indicators like project progress, performance indictor and department ...departments viz. Operations and Customer service. Ideal Skills and Experience: - Proven experience in KPI dashboard creation and data integration. - Strong analytical skills to track vital performance indicators effectively. - Proficiency in Business Intelligence and Analytical tools for data processing. - Familiarity with project progress tracking and departmental performance analysis. Arabic ...
...problem-solving skills, effective communication abilities, exceptional attention to detail, and the ability to work cordially with a diverse group of people. - Usage of vivid colors to enhance audience attention. Preferred colors include Red, Pink, Black, Purple, and White. - Creative use of fonts for improved readability and uniqueness. Please empathize that I am skilled in Microsoft Office, Excel, Word, Teams Outlook, SQL, Voya, and ADP Ideal candidate: The ideal candidate for this job would have a great eye for design, experience in creating engaging PowerPoint presentations, and an understanding of how to present personal and professional attributes in a visually appealing manner. Fluency in English is a must. This is not just about translating skills into bullet points ...
I need a skilled editor to take on the task of content editing for my range of videos. This includes, but is not limited to, vlogs, promotional videos, and educational videos. Ideal Skills for the role: - Proficient in video editing software - Prior experience in editing different ...the role: - Proficient in video editing software - Prior experience in editing different types of video content - Adaptable and creative in the editing process - Attention to detail and sensitivity to the purpose of each video This project will require a versatile content editor with a knack for molding video footage into engaging narratives tailored for various video formats. Apply if you excel in understanding the subtleties of video content and are able to enhance them through your editing ...
...spreadsheet below 3 times now and 3 times a week after that. I will pay (escrow and release) your $5 FL fee as soon as I hire you. Then I will pay $10 for each spreadsheet that you fill in. Attachments: JPEG: Snapshot_5 is one JPEG from the zip file attachments. Excel Spreadsheet: Time Speed Bottom Left - 1 zip files: Snapshots Part 1 and Part 2 contain 516 JPEGs. WHAT NEEDS TO BE DONE: Look at JPEG Snapshot_5. There are 3 numbers: Time: 3000 Speed: 1.5 Bottom Left: 70 (Ignore the number 000 at the bottom right.) Look at the Excel Spreadsheet and the zip file Snapshots Part 1. Two of the rows are filled in with the numbers on the first two jpegs in the zip file. Your job is to fill in all rows of the spreadsheet using the 2 zip files of jpegs. (There is also an extra...
