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.
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
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.
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
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.
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
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