Find Jobs
Hire Freelancers

Vlookup on another workbook using VBA

$8-15 USD / hour

Closed
Posted over 3 years ago

$8-15 USD / hour

I am working on an automation script in VBA. The script filters the data in the first workbook. Then, perform regular expression operations on a column to strip the values which are to be lookup in another workbook. How to perform the lookup operation in another workbook? [login to view URL]
Project ID: 26866480

About the project

30 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $14 USD/hour for this job
User Avatar
Hi, Greetings! ✅checked your project details: Vlookup on another workbook using VBA ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$15 USD in 40 days
4.9 (406 reviews)
8.2
8.2
User Avatar
Hi, As I understand you need Vlookup on another workbook using VBA. Keen to work on this project. Please suggest suitable time to discuss further on this requirement. I am well versed with Excel and its various features like Userforms, Pivot tables, Slicers, HLookup, Vlookup, Countif, SUMIF, Countifs, Sumifs, Left, Right, Mid, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for. If need be I can also do automation using VBA/Macros. I have done good amount of work in Excel macro handling. It includes userform creation, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks
$13 USD in 40 days
4.9 (126 reviews)
6.3
6.3
User Avatar
---------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have reviewed your description and link. I can complete your project by maintaining 100% accuracy of your data absolutely as you want. -------VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain
$10 USD in 40 days
5.0 (188 reviews)
6.0
6.0
User Avatar
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THESE TASKS IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved programming, scripting, excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$8 USD in 40 days
4.8 (64 reviews)
6.0
6.0
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$12 USD in 40 days
4.8 (71 reviews)
5.8
5.8
User Avatar
Hi Several similar tasks I've coded using AD/SQL within Excel. So , send you Excel with detailed instructions and I can start immediately. Regards, Zurab
$12 USD in 40 days
4.7 (35 reviews)
5.8
5.8
User Avatar
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 2 hours
$15 USD in 2 days
4.9 (71 reviews)
5.6
5.6
User Avatar
Hi, Gone through your requirements and clearly understand what you want I am a Microsoft Certified Professional in Excel and VBA as an Expert. You can see my work in my profile or stackoverflow also. Awaiting your response to get started immediately Regards, Karthick Gunasekaran
$8 USD in 40 days
5.0 (30 reviews)
4.8
4.8
User Avatar
Hello, I can help you creating the code to filter on sheet2 depending the results of sheet1, please send me a message with more details (number of columns, type of data, etc) and if it's possible send me a file as an example so I can check it and will start working on it inmediately
$8 USD in 20 days
5.0 (37 reviews)
4.3
4.3
User Avatar
Hi, I have read your requirement :- Vlookup on another workbook using VBA I have 7+ years of experience in MIS. I am expert in Excel and have an excellent in VBA . If given a chance, I can do this work easily for you as per your deadlines and requirements. We can discuss the same in detail.
$12 USD in 1 day
4.9 (4 reviews)
3.3
3.3
User Avatar
Hello, Don't worry sir, I am an expert in Excel VBA. I can assist you in best way & I have done several projects in Google Sheets, MS Excel formulas like (Vlookup, Hlookup etc.) & VBA. It. It includes extracting information from text files, websites, transferring info in to excel, User forms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, Data analysis etc. Let's initiate quick chat and discuss together. I would be happy to answer any queries that you may have Thanks, MBY
$8 USD in 40 days
5.0 (16 reviews)
3.3
3.3
User Avatar
Hi I have experience In vba macro development like apply filter, based on filtered row do other functions so on. I can able to develop your application regards B. Purushothaman
$11 USD in 30 days
5.0 (1 review)
2.2
2.2
User Avatar
Hi I am a Accountant (Bank) having expertise in finance and excel. I read your description of project and confident that I can do it. Please add me to your chat to discuss in detail.
$12 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested in this project. I have done various certification courses in advance to excel from that I have good knowledge of Excel and VBA. Recently I have created an excel sheet for an organisation meeting all their requirements and made it dynamic and user friendly.
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have gone through the requirements you need. I will help u in work. I am a data entry expert and have very nice experience in this field. I will assure u the best quality work and deliver the work on time. Don't look at price I am charging actually I am starting on freelancer that's why. I hope u will give this opportunity to me. I will not disappoint u and would be happy to work with you. Thanks
$8 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Proficient typing skills. Computer skills and a knowledge of relevant software packages. Relevant Skills and Experience Good communication skills, both written and verbal.
$13 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
15 $/hr 30 hrs/week. Dear Sir/Madam, I have gone through your requirement. I am advance Excel expert with 8+yrs of experience. Give me a chance i will not let you down and give my best. Thanks Mili Shah
$17 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am here to help u. By doing any type of data entry work. Please alow me to prove that I actually helps u.
$13 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, let's start from this time …… It is very simple work …… and I can do it because you have read your requirement: - If given the chance, I can do this job easily according to your time frame and requirements Can do with We can discuss the same in detail.
$12 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I will summarize all the lectures and provide you with clear, concise notes. I am an IT professional with 5 years of experience. Data Entry, Excel, Data Processing, Logistics, IT Sector, Finance, Banking have worked on several similar and can deliver quality notes to tight deadlines.
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ROMANIA
Băilești, Romania
5.0
1
Member since Mar 8, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.