• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Combine 2 Modules for search function

Hi Experts,

I would like to request Experts help to combine Module 1 and 2 code. This is to allow data search result displayed at the SearchData (A5 and E11) sheet simultaneously based on search value at cell F2. I have attached the workbook together with the anticipated sample result at SearchData sheet for Experts perusal. Hope Experts will help me to combine these 2 modules.



SearchData.xls
0
Cartillo
Asked:
Cartillo
  • 6
  • 5
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi Cartillo,
Please see attached spreadsheet. I have combined the two SearchData macros together. can you please test this and see if this works?

thanks,
Ardhendu
SearchData.xls
0
 
CartilloAuthor Commented:
Hi,

Thanks for the file. I have tested, its not showing the right result. Column A5 to D needs to show data from Total sheet and cell E11:F displayed result from sheet Validation. Hope you will help me to fix this.
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Sorry about that. Let me try to fix this for you...
0
Industry Leaders: 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!

 
CartilloAuthor Commented:
Hi Pari,

Hope you'll re-look this Q.
0
 
Ardhendu SarangiSr. Project ManagerCommented:
hi,

i have this question in the list. i will post a response soon...
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi,
Please see the following file. Let me know if this works?

SearchData.xls
0
 
CartilloAuthor Commented:
Hi Pari123,

Thanks for the file. Have tested, the search function only return for Validation sheet (E11:F11), but not  for the Total sheet (A5:D).
0
 
Ardhendu SarangiSr. Project ManagerCommented:
hi Cartillo,

i apologize for the trouble. can you please explain what the macro is doing? I tried running the macro and for the 2nd code i got a message - "item not found".


thanks,
Ardhendu
0
 
CartilloAuthor Commented:
Hi Ardhendu,

The macro will look for the matched first 5 alphabets  at Total and Validation sheet if we entered search value at Cell F2 . e.g. if we type "AYDCC", all data at Total sheet will be displayed at (E11:F11) and at the same time matched data at (A5:D). If we type "Number", the result will show the data which is matched with the typed number at cell F2. Sorry for the confusion.
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi Cartillo,
I think I have got this to work right now.

1. I have changed the code to accept two search strings - One for Total and one for Validation.
2. I also fixed the error where the validation was not returning values for the Totals sheet too.

This worked for me, can you please test this once?

Thank you for your patience,

Regards,
Ardhendu


SearchData.xls
0
 
CartilloAuthor Commented:
Hi Ardhendu,

Thanks a lot for the solution.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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