Find Jobs
Hire Freelancers

Excel Macro Project that Extracts Make and Model from Text and compares to Table of Values with Aliases

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
I need someone to code a macro to look at a Field with information --and figure out the manufacturer and subsequent Model...both manufacturer and models have different names and aliases that will need to be read from a table. The table will need to be able to be updated -- a normal vlookup or match function will not work as logic is : Search text for manufacturer -- or manufacturer alias(example General Motors or GMC) and once present look for exact match to model or model alias..some of the models are similar-- example : Citation II or CItation III -- current logic is stopping at Citation II. Once make and model are done then will need a simple lookup of table to show category. I am also willing to have this completed in access but would prefer excel. Data is based on aircraft types.. send me your bid and skills and I will send sample data for you to review. I am really looking for a VBA and excel guru -- if you do a good job I will give great review and also will have more projects.
Project ID: 16048327

About the project

37 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
Hi I am good at Excel VBA to verify the data between text and excel files. I can transfer the data both ways. Please provide me the sample data to review inline with the description to get a better understanding of the work scope to estimate better. Looking forward to discussing in the chat and work on the project. -Chandra
$100 USD in 1 day
5.0 (979 reviews)
8.1
8.1
37 freelancers are bidding on average $122 USD for this job
User Avatar
Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
$200 USD in 3 days
5.0 (815 reviews)
8.7
8.7
User Avatar
Greeting, I have understood your Excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps
$150 USD in 2 days
4.9 (413 reviews)
8.2
8.2
User Avatar
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
4.9 (455 reviews)
7.8
7.8
User Avatar
VBA guru is here! I love excel automation, am great at understanding instructions, and promise to code it perfectly, so it searches partial matches, and does the requested. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
$150 USD in 3 days
4.9 (308 reviews)
7.7
7.7
User Avatar
I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$250 USD in 3 days
5.0 (211 reviews)
7.1
7.1
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy
$150 USD in 3 days
4.9 (437 reviews)
7.2
7.2
User Avatar
Hi Are you interested in a PHP solution that takes the spreadsheet as input? The logic and matching can be done in PHP and an output excel file can be generated. Looking forward to seeing your reply. Thanks. Regards Ahsan
$120 USD in 3 days
4.9 (75 reviews)
6.7
6.7
User Avatar
Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel, working with multiple files. Regards.
$100 USD in 2 days
5.0 (144 reviews)
6.6
6.6
User Avatar
Nice to know your requirement. I have delivered couple of VBA tasks recently, and I am a expert VB programmer. It would be ideal for me to do create a function to get your requirement done. Thank you, Regards.
$222 USD in 3 days
5.0 (146 reviews)
6.7
6.7
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$80 USD in 0 day
5.0 (265 reviews)
6.5
6.5
User Avatar
I'm excelent at doing VBA Macros. I'm willing to do yours, at this very momment without you awarding me, just to prove you that I can. I'll asume the risk, no problem, you wont have any commitment with me, and you can choose any bidder at any time no questions ask. Just give me your excel file, and I'll start right away Thanks, Felice
$111 USD in 1 day
5.0 (14 reviews)
6.4
6.4
User Avatar
MPhil in computer science and expert in Excel macros.
$150 USD in 1 day
4.8 (91 reviews)
6.4
6.4
User Avatar
Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several excel/vba projects and can help you with optimal solution that have features or lookup or similar to serve your purpose. Waiting for your response for detailed discussion. Thanks.
$72 USD in 3 days
4.8 (115 reviews)
5.9
5.9
User Avatar
Greeting, I have understood your Excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps
$200 USD in 2 days
4.8 (13 reviews)
5.3
5.3
User Avatar
Hello, I went thru the des. This can be done within 2 days with 100% accurate. Kindly send me the file to have a look, then will feedback you Once i read the des, feels it can be done by using macro, array maybe Today can start. Looking forward to hearing from you Thanks Regards Thushara
$100 USD in 2 days
5.0 (31 reviews)
4.9
4.9
User Avatar
Hi, I'm really feel challenged with your project. I'm interested to create a logic that you want. Could you please send me your file and let me find way to solve your "alias" problem. I'm waiting your reply, Thanks
$61 USD in 3 days
5.0 (46 reviews)
4.7
4.7
User Avatar
I read through the job details and I am absolutely sure that I can do the project very well. I'v good command on Office tools like (Excel, Word, Excel Vba, Macro, Spreadsheet). I will make macro to search info compare data to table as per your requirement. Let's chat for short discussion. Thank You
$138 USD in 5 days
4.9 (32 reviews)
4.6
4.6
User Avatar
"look at a Field with information --and figure out the manufacturer and subsequent Model" can't be done with macro as it needs user intervention. It could be done by showing the nearest possibilities and allow user to choose the correct ones. hope to have your consideration.
$130 USD in 2 days
5.0 (7 reviews)
3.8
3.8
User Avatar
Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . I have complited many data analytical work high quality and accuracy last five year. using microsoft word,microsoft excel perfectly. i can start now your project according to the your guide line with Confirmation.
$40 USD in 1 day
4.9 (12 reviews)
3.6
3.6
User Avatar
I worked with Excel that include macros in many projects, some of them for web scrapping, form and dashboards.
$77 USD in 5 days
4.8 (11 reviews)
3.7
3.7

About the client

Flag of UNITED STATES
Houston, United States
5.0
28
Payment method verified
Member since Jul 10, 2015

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.