Search Data using VBA

How to search for data in 'Data' worksheet and display it in 'Results' worksheet based on 2 conditions with VBA.
Details of VBA code available at this link:

[bhawirai]

Dear Sir, Thankyou very much for this session. You make it very easy. Thankyou again.

[HabiburRahman-uwir]

Exactly the example I needed. Thanks a lot

[osalmaag_o-S]

This aided me for a college proyect, thank you very much

[vishalsharma]

Hi Sir,
I have to two workbooks wb1 and wb2 now I want to copy the data from sheet1 of wb1 by searching the particular column by its "name" and then pasting in sheet1 of wb2 by again finding that particular column by its "name" then pasting the wb1 sheet1 data in sheet1 of wb2. I have multiple columns in the sheet1 of wb1. I want to loop through all columns that I want in sheet1 of wb1 and repeat above task for them. And While finding column it should find by column "name" and not by column number, since my sheets column position keeps changing.

Please help on this....!!

[paraglide]

Thank you sir for your good video's and nice manner of teaching. I have learned a lot from your video's.

[dilipsanadhya]

I have questions....
One excel file have header in first row and we need to upade the file from different files using find and index and matching pleased suggest

[Nainagrh]

Can you tell me the coding to connect mainframe with excel vba

[chanmonanrie]

Hello, there! I got a compile error: end if without block if. How should I fix this?

[pietrogazzera]

Great and clear as usual! Thanks Prof!

[kresuz]

Thank you so much! So helpful videos. I hope next video will be about searching and showing total charges for two different criteria. Kind regards!

[ssrao]

sir i need search function in user form with multiple sheets and results displayed that form in list box.

[jelanmarzona]

Sir, i follow your video and error;


lastrow = Sheets("Data").Cells(Rows.Count, 1).End(xlUp).Row


Run-time error '9'
Subscript out of range

[MsSmontero]

Hi Dinesh, here i am from Costa rica, I like your videos and they are very useful, I have a query. I need to search a data from a column, that the number begin with (17) for example. if a have data in this columns, I need the macro stop with the number 170010.(the first). Now I use "Find (17)*" but it does not work. thanks

[buddy]

Hi Sir. If there are multiple records in the Results Sheet.. Still will this code work? If not.. Can u please post that video to search data if there are multiple records. THANKS

[mohdatique]

sir i want to take a coaching in South Delhi can you tell me a best institute in South Delhi to Learn VBA, MAcro and SAP

[juliuslaurella]

good day sir..Please help..I want to display also in a cell what i type in textbook in VBA..and also erase if i erase it in the text box of VBA..hope you can help me on this

[henrikijonkoping]

Good video, but what happens if you have two charges for a Name and for a destination?

[krish]

Hi Sir, In this video vba code... if condition may be false... then how to give a message.. to user

[LoveYouHR]

Sir, if data is not found, then how to add msgbox "no data found" in for next loop

[khaledembouazza]

Thank you very much, I would like some help to apply this search on a userform, Instead of doing the search in a sheet, I want to do it in a userform. Thank you in advance.
Love and respect from Algeria