Using VBA to search for keywords in data set and return results in another sheet

This is only guess due to unclear sheet layouts.

Please Login or Register  to view this content.

However, if you have heading in "Classification Requests" sheet, Advanced filter would be the best to apply.

Hi,

Thanks so much for trying.

Sheet1 = "Keyword search for a product" = worksheet in which I will enter a "keyword" and return a result in
Sheet2 = "Classification Requests" = data set in which the "keyword" I enter in sheet1 will look in.

I have tried the code you indicated above, but I could not get it to work. Few questions:

(1) will it give me more than 1 results? I am trying to get more than one search result.
(2) how would I be able to search in two columns. I see that the code above only searches in column "H:H" of sheet2

thanks again

OOps, it should be

Please Login or Register  to view this content.

Anyway, uploading sample workbook helps.

Hi,

I got it to work. Thanks a muillion. I am unable to upload the file for some reason.

Few more clarificaitons:

(1) hoow can I get pasted rows to show alterenating row colour?

(2) If I want the search to start at row 7 in sheet 2, then do I just change G:H --> "G7:H7"?

Thanks again,

1) You can apply conditional format. e.g
Select A11:F?
Formula : =AND($A11<>"",MOD(ROW(),2))

2) Try change to

Please Login or Register  to view this content.

Hey,

I have everything set up. Search and found is working, but there are two issues:

(1) format gets carried over -- which is something I do not want. I am trying to keep text only.
(2) the search is still not starting from row 7. it seems to still cover anything above row 7, e.g. row 6.

HTML Code: 

That's why I was keep saying "Upload a workbook".
No one can see your file and read your brain...

1) try change to

Please Login or Register  to view this content.

2) How could it be possible to find something in row 6 when search range is G7:H1048576 ?

Hi,

I was trying to attach a file and it was not letting me.

I think it finally worked.

I noticed that the search results repeat each match three times.

thanks,

Try

Please Login or Register  to view this content.

THi,

thanks again for trying. That code filters my original data set in sheet2 and then crashes.

Can you do a step debug and find out the reason for crash?

Or try this

Please Login or Register  to view this content.