[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Search and display unique data

Hi Experts,

I would like to request Experts help to add additional function for the search query at cell C2 (the code is copied at “sheet1” – SearchData workbook). The search value at this cell will return the query result from MainData workbook based on search field at column 4 and 5 (Private Const SEARCH_FIELDS = "4,5"). The new additional filter query is required when performing data search at column 5 from cell C2. The return value at Search Data workbook need to be unique and only data from column D,E and F are copied at  SearchData. I have manually copied few data at SearchData(end result) and MainData (source data) workbooks for Experts to get better view. Hope Experts will help me to add this new feature.



SearchData.xls
MainData.xls
0
Cartillo
Asked:
Cartillo
  • 7
  • 6
1 Solution
 
SiddharthRoutCommented:
Cartillo, what will Search Field Contain?

Sid
0
 
CartilloAuthor Commented:
Hi Sid,

The user will search number from column D and Status (in text ) from Column E which is resided at MainData workbook.
0
 
CartilloAuthor Commented:
Hi Sid,

I do believe my explanation could create confusion at your end. I’m using SearchData workbook to extract information from Maindata workbook by entering the search value at Cell C2. Mainly I’m looking for the box number (Column C at MainData workbook) and status of the Box at Column D (MainData workbook). If the type value (number “Column C” or text “Column D”) exist in MainData sheet, then the data will display at SearchData workbook. Hope I’m able to translate my intention here. Please let me know if you need more input.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SiddharthRoutCommented:
>>>Mainly I’m looking for the box number (Column C at MainData workbook) and status of the Box at Column D (MainData workbook). If the type value (number “Column C” or text “Column D”) exist in MainData sheet, then the data will display at SearchData workbook.

I believe you meant "D" and "E" instead of "C" and 'D" ?

Please give me an example of the Search value that you would be putting in C2.

Sid
0
 
CartilloAuthor Commented:
Hi Sid,

Sorry for the error, supposedly D and E. Here's the sample data that I'll use at Cell C2 for search:

00008888
00002144
00001247
Pending  
0
 
SiddharthRoutCommented:
Is this what you want. Sample file attached.

Also please change the path of MainData.xls in the Macro in Module1 before running the macro.

Sid
SearchData.xls
0
 
CartilloAuthor Commented:
Hi Sid,

Thanks for the file. When we query for “Pending” title is that possible to show only unique number?
0
 
SiddharthRoutCommented:
Like this?

Sid
SearchData.xls
0
 
SiddharthRoutCommented:
I am assuming that unique number is which have unique values in Col D and Col F.

Let me know if you want to only compare col D.

Sid
0
 
SiddharthRoutCommented:
If it is just Col D Unique numbers then try this file.

Sid
SearchData.xls
0
 
CartilloAuthor Commented:
Hi Sid,

This is the best (ID: 35490188), thanks for the WB. Whenever we search for new value, can we clear the old result before resume with new query. Currently its populate new with the old data. Hope you'll consider this.  
0
 
SiddharthRoutCommented:
>>>Hope you'll consider this.  

Here it is :)

Sid
SearchData.xls
0
 
CartilloAuthor Commented:
Thanks for the great help.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now