VBA to Search Value on Multiple Sheets

This Excel VBA example explains how to search specific text or cell value on multiple sheet and get the data on main sheet. We can understand VBA code for copying sheet name and required values from all sheets basis on matching text or string.

[joanstoner]

This is exactly what I was looking for - after searching and making many mistakes. You, sir, are a God send!! Thank you!!

[MohAboAbdo]

Thank you very much for this great video and for this simple and cool method.

[kevinmccarthy]

Very effective, just what I was looking for, THANK YOU!

[benb]

Thank you. This video is very helpful.

[milimohamoonga]

Thank you so much for the insight. How do I write my vba code to be selecting data among several sheets based on dates, for example today()+30 and compile it together.

[anniedomini]

Thank you for the tutorial. I feel I am almost there. How do I make this macro to search in multiple columns or for example just in column number 9?

[calrichcraft]

Thank you so much for this! Ive made a few alterations to pull extra data from each sheet (as you did for column B on each sheet). Is there a way to make the searched results appear in the form of a table? So it can be easily filtered? And add hyperlinks to each sheet (jan, feb, etc.)?

[yoibnju]

This is GREAT!. How do I change to have sheetnames overwrite cells in column A when new search is done? Currently it adds below last result of previous search.

[OopsyApple]

Hi, is there any chance you could show how to do this with partial match please? So it would also display if the cell contained "China and India", because India is still in the cell, for example. I saw your other video about partial match, but don't know how to get the results to display like in this example (a list with specific datat entered, from multiple sheets - not just highlighting on one sheet). Thanks!

[gurmindersingh]

In the line below it gives me only Column 2 values in the mastersheet, , I need the complete row(record) displayed in the master sheet, How can I do that ?
+ 1, 1).Value = Worksheets(i).Name
+ 1, 2).Value = Worksheets(i).Cells(j, 2).Value

[MMA]

Thank you very much
How to write the msgbox code if I can't find what I'm search for in all the sheets

[ashtanwar]

I am looking to find each value of Column E from master sheet into next all available sheets in workbook. if value matched in any sheet then sheet name paste in column F against the search value. Please help me

[praveenshrinivas]

I need put index match to across sheets in Excel to get value I need vba

[PrasanthPrasanth-uewq]

need one urgent help!!!
I have master sheet and reference sheet.
I want to check the master sheet's column values are exist or not in reference sheet's column. searching by column name as a key,
if not exist means need to be highlighted in master sheet's cell.

[HT-rhbm]

How can I apply this to search for a value within a cell (e.g. 3, 4, 5)? partial matching.

[ggpipsr]

I keep getting complile error: variable not defined. starts with totalsheets so I dim but then it goes on to mykeyword and on and on. please help

[ranjanram]

Dear sir pls give some tips or publish a video that when we want to transfer some data to a specific sheet of a specific workbook in other specific folder by using via code. Other conditions also if workbook nane not match our name in which we want to transfer then data should automatically transfer in a new workbook in same folder.

[ipsitachakraborty]

Hi, I am very new to VBA and the task I am trying to do is...
1.from a sheet called "checkheader" a particular column check has 12 values
So I need to search for those values individually in another sheet "sample" and paste that corresponding columns data into the master sheet.

[gowripadasala]

I would suggest please copy the VBA code and past it in the video description so that users can copy and past it.

[chanteldevitt]

Is it possible to do this method with multiple key words?