This is excellent. Thank you. How does one edit the code to search through a range and then search though another range to find a match. For example, loop and entire work sheet and find a state postal code that is contained in a range of several state postal codes. Let us say five of the 51 state posts codes. Thank you.
Dear sir, I want to know how to solution the three criteria index match function in Visual basic excel file ? Can i shear a excel file this related problem.
Hi Thanks for the video. This is excellent. but sometimes I am getting 'Run time error 1004 .Application Defined or object defined error' on range(myRng).select Please suggest any solution.
The range property's first parameter is limited to a 255 character limit on a string of range addresses. So depending on your search range you'll be limited to finding 22 to 85 matches before your program throws an error using this approach. To avoid this limitation you can change the code to the following to allow for 1000s of matches: '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' For Each taco In Range("a1:b6") If IsEmpty(myRng) And taco = Range("c1") Then Set myRng = taco ElseIf taco = Range("c1") Then Set myRng = Union(myRng, taco) End If next taco If IsEmpty(myRng) Then Exit Sub myRng.Select ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Hello, I find your video interesting, can you now use the same formula to retrieve data and put it next to the "name, so suppose that column B contains data and would like to place it next to the name you're looking for, is that possible?
Thanks always enjoy your videos. I have two tables column A is names and row heads are months (12 months) the two tables are identical to this point. The data in one table is persons total sales for each of the 12 months. The second table is their target for the month. I need to be able to create a chart combining for each record from the tables. Example: First record from each table is Bob Jones need a chart show a sales in column and target as line (dashes). Need a chart for each person. Need your VBA expertise to automate this process. Thank you. God Bless!!!
How do I select multiple cells with this macro that are either highlighted a certain color or not highlighted? I've been trying If myRng =.Interior.ColorIndex = xlNone then... but have not been able to get it to work. Thanks for your help.
How can I extract data from a range of cells if it meets a certain criteria through VBA. Eg. I have a range of cells as below Number Hello / 10023 aw-11 10024 hello / 233 Hello / hello-1003 ghh Now I want to extract all the data from the range where the number starts with 100 and consits of 5 digits only. Expected output Number 10023 10024
I want VBA code for copy past data from sheet 1 to another sheet Condition is .. 1) If Column Q have bank value then copy that to another sheet and delete rows ctrl - 2) If column c have 0,00 and E column have bank value then I want to copy this to another sheet and delete this rows (clt - ) and column E 00 and column c for blank copy past in another sheet and again delete this rows
![🔴 ฟุตบอลแชมป์กีฬา 7HD แชมเปียน คัพ 2024 [รอบ 8 ทีมสุดท้าย] - ช่วงเช้า](http://i.ytimg.com/vi/bXFWzzy4UJw/mqdefault.jpg)
Helpful
Cool, thanks Dan. How did your thing go?
krn14242 It went well. Got the job with a very amazing company, not that my current company isn't amazing. Very blessed sir. Thanks!!!
Thanks for the video!!!!
thank you for everything Excelisfun you are so helpful to so many. We all appreciate you a lot!!
This is excellent. Thank you. How does one edit the code to search through a range and then search though another range to find a match. For example, loop and entire work sheet and find a state postal code that is contained in a range of several state postal codes. Let us say five of the 51 state posts codes. Thank you.
Dear sir,
I want to know how to solution the three criteria index match function in Visual basic excel file ? Can i shear a excel file this related problem.
Hi Thanks for the video. This is excellent. but sometimes I am getting 'Run time error 1004 .Application Defined or object defined error' on range(myRng).select
Please suggest any solution.
The range property's first parameter is limited to a 255 character limit on a string of range addresses. So depending on your search range you'll be limited to finding 22 to 85 matches before your program throws an error using this approach.
To avoid this limitation you can change the code to the following to allow for 1000s of matches:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
For Each taco In Range("a1:b6")
If IsEmpty(myRng) And taco = Range("c1") Then
Set myRng = taco
ElseIf taco = Range("c1") Then
Set myRng = Union(myRng, taco)
End If
next taco
If IsEmpty(myRng) Then Exit Sub
myRng.Select
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Great, Conditional Formating/Highligh Cells Rules/Text that contains can also do the trick
Laza Lazarevic thanks Laza!!
ExcelVbaIsFun But of course this way you can not learn VBA.
Thank you for great videos
God bless
Hello, I find your video interesting, can you now use the same formula to retrieve data and put it next to the "name, so suppose that column B contains data and would like to place it next to the name you're looking for, is that possible?
How to select an entire row of data if criteria for a certain column matches?
Thanks always enjoy your videos. I have two tables column A is names and row heads are months (12 months) the two tables are identical to this point. The data in one table is persons total sales for each of the 12 months. The second table is their target for the month. I need to be able to create a chart combining for each record from the tables. Example: First record from each table is Bob Jones need a chart show a sales in column and target as line (dashes). Need a chart for each person. Need your VBA expertise to automate this process. Thank you. God Bless!!!
Thanks mate, you saved me! :)
thank you again
Is there a way to remove or delete the ones that don't match
How do I select multiple cells with this macro that are either highlighted a certain color or not highlighted? I've been trying If myRng =.Interior.ColorIndex = xlNone then...
but have not been able to get it to work. Thanks for your help.
What if what you are searching through has commas?
Wonderful!
I have a question? I just have started messing with excel a few weeks ago. I had no idea it could do so much.
I'll send a PM....
How can I extract data from a range of cells if it meets a certain criteria through VBA.
Eg. I have a range of cells as below
Number
Hello / 10023 aw-11
10024 hello / 233
Hello / hello-1003 ghh
Now I want to extract all the data from the range where the number starts with 100 and consits of 5 digits only.
Expected output
Number
10023
10024
I want VBA code for copy past data from sheet 1 to another sheet
Condition is ..
1) If Column Q have bank value then copy that to another sheet and delete rows ctrl -
2) If column c have 0,00 and E column have bank value then I want to copy this to another sheet and delete this rows (clt - ) and column E 00 and column c for blank copy past in another sheet and again delete this rows