完了済み

Excel Batch Search Database Extract Cells to create Report

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.

スキル: エクセル, PHP, ビジュアルベーシック, ソフトウェアアーキテクチャ, 情報処理

さらに表示: retrieve a cell value from multiple files, how to pull the same cell from multiple workbooks, excel pull data from another sheet based on criteria, excel pull data from another worksheet, how do i pull data from one excel sheet to another?, extract data from multiple excel files into single file, how to get data from multiple excel files into one, extract data from multiple excel files vba, create search database business phone numbers, excel data access database, excel macro search cells, criteria database extract names vba excel, create customer ageing report excel, batch search results excel, excel template database extract data, create excel horse racing database, create retail sales report excel, excel database built links create mail merge pdfs, create daily sales report excel, create search database form using wordpress

採用者について:
( 2件のレビュー ) Edmond, United States

プロジェクトID: #24820716

アワード:

Prompty

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 3日以内
(5レビュー)
2.2

20人のフリーランサーが、このジョブに平均$26で入札しています

schoudhary1553

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. Pl もっと

$50 USD 1日以内
(423件のレビュー)
8.1
P0L

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 1日以内
(387件のレビュー)
7.5
TonmoyRoy111

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 2日以内
(396件のレビュー)
7.0
rinabuoy13

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 1日以内
(151件のレビュー)
6.6
finecodervw

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, SUM もっと

$30 USD 1日以内
(199件のレビュー)
6.5
amwazeindia

Hello, I can help you with adding a search button and then do actions based on the search result. This can be attained using VBA. In VBA there are options to compare the cell values using Instr command. It can look up もっと

$30 USD 2日以内
(9件のレビュー)
5.0
VirtualApes

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 Exped もっと

$30 USD 3日以内
(2件のレビュー)
1.5
yani73

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 1日以内
(3件のレビュー)
1.2
mousumi1996svc

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 Hav もっと

$10 USD 2日以内
(0件のレビュー)
0.0
Virajpatil2016

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 2日以内
(0件のレビュー)
0.0
fz2301

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 u もっと

$30 USD 1日以内
(0件のレビュー)
0.0
NJno1

sir connect me apko vahi bata dunga puri method so please connetc me just 1 change please sir me apko apne sare plens bata dunga

$20 USD 7日以内
(0件のレビュー)
0.0
RKS741953

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 3日以内
(0件のレビュー)
0.0
$25 USD 1日以内
(0件のレビュー)
0.0
Pparth68

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 2日以内
(0件のレビュー)
0.0
princepatel22132

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 2日以内
(0件のレビュー)
0.0
kabichandra112

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 1日以内
(0件のレビュー)
0.0
sambehappy36

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 7日以内
(0件のレビュー)
0.0
sskannan52

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 j もっと

$20 USD 1日以内
(レビュー1件)
0.0