Find Jobs
Hire Freelancers

Excel Batch Search Database Extract Cells to create Report

$10-30 USD

Completed
Posted almost 4 years ago

$10-30 USD

Paid on delivery
I have an excel spreadsheet with three tabs. 1) Database, 2) Batch Query Input and 3) Report. The information on the database wont change, but i will be inserting all new data into the Batch Query Input tab on a regular basis. The First Column with data on each tab is "Owner". I need to batch search all Owners in the Batch Query Input tab to see which ones are found in the Database tab. For each Owner found I need to extract all of the data in that row from the Database and insert it into the Report tab starting in Column "Q" through "AE". I also need the data from the matching Row in the Batch Query Input row to be inserted in Columns "B" through "P" in the Report Tab. I want a search button so i can input data in the Batch Query Input row and generate a report. Lastly, the Owner names in column "B" of the Database contain business names, trust names, spouses names, Initials, etc. whereas the Owner names in column "B" of the Batch Query Input tab are Last Name and First Name only. I need a solution that matches the last name and the first name on the Batch Query Input tab with the owner name in the Database tab, even if it is a partial match. Many of these names will have multiple rows in the Database tab. I need the solution to extract each row in the Database tab and put it in the Report with the corresponding owner and information in the Batch Query Input tab.
Project ID: 24820716

About the project

19 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
Awarded to:
User Avatar
Hi, i am excel expert having used it and its features for over 15 years. I can meet your expectation and do a neat solution.
$30 USD in 3 days
5.0 (6 reviews)
2.3
2.3
19 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$50 USD in 1 day
4.9 (704 reviews)
8.7
8.7
User Avatar
Hello, I am 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.
$50 USD in 1 day
5.0 (510 reviews)
8.1
8.1
User Avatar
Dear client I understand the scope of work involved in the project. I can do this using macro. Please mention if you are using windows OS. Kindly contact me for further details and discussion. Roy
$50 USD in 2 days
5.0 (509 reviews)
7.8
7.8
User Avatar
Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.
$30 USD in 1 day
4.9 (178 reviews)
6.9
6.9
User Avatar
Hi, 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, HLookup, Vlookup, Countif, SUMIF, Left, Right, 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 have also handled various Excel tasks. I have more than 15 years of working experience to my credit. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks
$30 USD in 1 day
4.8 (309 reviews)
7.2
7.2
User Avatar
Hi, Greetings! I would like to work on your project. I have a 5+ years of experience in excel macros / vba ,formulas and MS Access I can start working immediately on this project if needed. I have gone through the job description and understand your requirements.I can complete this work with high quality. Kindly share me the input excel. If interested,Kindly contact me via chat for further details and discussion. Regards Kannan
$20 USD in 1 day
5.0 (3 reviews)
1.5
1.5
User Avatar
Hi There, Hope you're doing fine. I can assure the given task of Creating an excel spreadsheet with all the required details will be done in due time. Something about me : I'm currently working as Team Leader in Expedia which is an online travel agency, cause of which my job profile is highly data-intensive as I need to keep a close check on my team data performance and create intensive Excel data for the same, at the same time I also need to scrap out data from the competitive website to keep a close check on the ongoing scenario.I've a strong belief that this project requires the same level of skill and ill be more than happy to complete it in due time with no margin of error. I have a total experience of 4+ Years in CRM entry, Data Entry, Data Scrapping, Extracting Excel Data. Let's Discuss further over chat. Wish you well. Vaibhav
$30 USD in 3 days
5.0 (2 reviews)
1.4
1.4
User Avatar
Hello i am interest with the project And i will do its right away Lets discuss about its the detail Thank you Relevant Skills and Experience Excel
$10 USD in 1 day
4.9 (3 reviews)
1.2
1.2
User Avatar
Hello there, I completed project free. I am not to take money I am highly interested in your project. I can do this job with 100% accuracy. I hope you will be satisfied. Thanks.
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, I'm Mousumi Garain from India. I'm a bsc graduate & have diploma in computer. I would love to work on this project as I like to handle new project & complete it with perfection. Relevant Skills and Experience Have knowledge & experience in Excel, work, power point & others computer related work. Good in English. Love to work with perfection
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
myself VIRAJ PATIL I read your requirements how you wanted to get your work done I can easily do it in the given time frame. inbox me we can get in contact
$12 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Basis your requirement, I can get this done in day. Please let me know if you are interested. Please find below a brief about us and our work ethics. Days of delivery shall depend upon the volume of data, please let us know of it and we can discuss over commercials. 1. A team of 10 members working 16*7 to close your work in 1/20th of stipulated time 2. We shall provide a one time discount of 10% on all projects with billable value over $200 3. Ability to ramp up our team to 20 members within 2 days notice 4. Delivery before timeline with the best quality is our mantra 5. We shall provide continuous updates on the project so that you don't have to worry about delivery 6. We are open to regular feedback sessions so that you are satisfied with the quality of delivery
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi Kalpesh rathore I am new in freelance working style but I am also 5 year in Excel explanation person in my own office work
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am a data entry operator since 2016 in globe fortune 500 company Reliance industries limited so i mane all work load and work quality given time so i am perfect for this work
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I am data entry person sir..I am interested for doing your project sir if you explain about your project I will early start my work and give you perfectly if you give a chance I will show my skill
$13 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, I am Excel VBA developer and work for automating Excel and various data entry jobs. I can perform this job efficiently and within required time span. Regards
$22 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Edmond, United States
5.0
2
Payment method verified
Member since Mar 27, 2019

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.