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.
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.
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.)?
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!
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.
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
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.
in that scenario, you can loop through each cell. to take help on looping through each cell on the sheet, you can watch following tutorial : th-cam.com/video/Nv7z-iprosQ/w-d-xo.html
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.
Thanks for watching! There is another tutorial for searching partial match. I hope that will help you. Link for that tutorial is : th-cam.com/video/_cemX-Yz2TY/w-d-xo.html
yes it is possible. logic will be loop through sheets and on each sheet loop through data then use if condition if data matches then save the sheet name in a variable.
@@ExcelDestination Actually we are processing 3 years incident and problem record data , We have imported the data into excel sheet now, Here we need to find data related to particular server or configuration item .
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 ? Worksheets("MasterSheet").Cells(lastrow + 1, 1).Value = Worksheets(i).Name Worksheets("MasterSheet").Cells(lastrow + 1, 2).Value = Worksheets(i).Cells(j, 2).Value
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.
This is exactly what I was looking for - after searching and making many mistakes. You, sir, are a God send!! Thank you!!
Glad I could help!
Very effective, just what I was looking for, THANK YOU!
Glad it helped!
Thank you very much for this great video and for this simple and cool method.
You just made my day!
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?
Thank you. This video is very helpful.
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.
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.
thanks man you are great keep it up
I would suggest please copy the VBA code and past it in the video description so that users can copy and past it.
Actually video description length is limited.
Nice one info sir tnq so much
Thank you very much
You are welcome
You are welcome
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.)?
Glad it helped!
Thanks! Find it helpful.
Thank you very much
How to write the msgbox code if I can't find what I'm search for in all the sheets
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!
you can take some help from following tutorial :
th-cam.com/video/LvaCpIa5shE/w-d-xo.html
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.
for any excel vba support, you can write to exceldestination@gmail.com.
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
this is doable. you can share your task at exceldestination@gmail.com
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.
Thank you so much.
WHAT IF YOU WANT TO DO THAT WITH CELLS AND TABLES INSIDE THE SHEETS
in that scenario, you can loop through each cell. to take help on looping through each cell on the sheet, you can watch following tutorial :
th-cam.com/video/Nv7z-iprosQ/w-d-xo.html
Is it possible to do this method with multiple key words?
Yes, additional code would be required.
can u write the source code hare ?
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
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.
send me email at exceldestination@gmail.com. I will check your task and let you know.
I need put index match to across sheets in Excel to get value I need vba
How can I apply this to search for a value within a cell (e.g. 3,4,5)? partial matching.
Thanks for watching! There is another tutorial for searching partial match. I hope that will help you. Link for that tutorial is :
th-cam.com/video/_cemX-Yz2TY/w-d-xo.html
Can you help us search more columns
you need to modify this code a little bit
@@ExcelDestination
Can you show us how on your next video. Thank you very much.
@@ExcelDestination how do you do you modify it
Bro,
Is there way to find only the name of the sheet where i am missing my keyword
yes it is possible. logic will be loop through sheets and on each sheet loop through data then use if condition if data matches then save the sheet name in a variable.
@@ExcelDestination Thank you for the reply Bro , I am working on this solution and update you
I am working on a huge data set where i have to identify where and in which sheet my data is missing , Kindly help bro , Thank you
when data is huge, normally speed of VBA gets slow. However, we can think of some innovative solutions.
@@ExcelDestination Actually we are processing 3 years incident and problem record data , We have imported the data into excel sheet now, Here we need to find data related to particular server or configuration item .
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 ?
Worksheets("MasterSheet").Cells(lastrow + 1, 1).Value = Worksheets(i).Name
Worksheets("MasterSheet").Cells(lastrow + 1, 2).Value = Worksheets(i).Cells(j, 2).Value
Need project file for practice...
let me check,
@@ExcelDestination
Ok brother, waiting...
awesome!
This code didn't work in my wotksheet please help
Sir please make in userform
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.
Ok. Please send me your conditions at Exceldestination@gmail.com , I will try to create tutorial for that.