Search results

Is there any problem in the below code, its not moving to next sheet. Also please modify to exclude one tab and make the changes in all other active tabs. Its quite urgent. " Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets Range("D2").Select ActiveCell.FormulaR1C1 =...

Hello, I need some help in writing a VBA. Detail expanation - Have two drop down lists in excel. One has all the column headers and the other has ascending or descending option. I need a VBA to sort the entire range of data depending on the inputs provided in the above mentioned two drop down...

Hi Shrivallabha, Thanks for the formula. It works but not in all cases. Does it not work if comma is there in between and is it case sensitive? I found the above discrepancies in some rows. Regards Jayadev

Hi Debraj, Sorry for the confusion, let me explain clearly. Sheet1.A1 = Jay Sheet1.A2 = 2387984Jay12/21/2012-jdhfiuf Sheet2.A1 = Jay In your first Macro, it returns "Jay" where it's present in a string "2387984Jay12/21/2012-jdhfiuf" but not in case of "Jay". I want "Jay" wherever it's...

Hi Debraj, I am not able to attach file for some odd reasons, dont know what exactly the reason is. Meanwhile a quick help would be better. I need exact match and contains because the data set contains both type of data. May you help Regards Jay

Hi Debraj, Thanks for the modifications. But it is still not able to get the right match. Is it possible, if I can send some data so that you will have a better idea? Regards Jay

Thanks Debraj, just a modification to the above code, instead of having a exact match can we search for the contains match. for example, if in sheet2, I have Jayadev Sarangi, instead of Jay, it should take as Jayadev Sarangi but search by Jay only. Because the name may come in full or short...

Hello Debraj, Thanks for the help. I followed your instructions and it works perfectly fine. So everytime I just need to copy paste the formula for the entore range, right? I hope someday I will be able to write a VBA code like you. Thanks a ton :) Regards Jayadev

Hi Narayan, Thanks for the quick help. The VBA works but I have to update the same for a range of rows may be 30000 or 40000 rows. Kindly help. Regards Jayadev

Hello Debraj, Thanks a lot for the quick reply but I need something as per below. Sheet1 Cell A1 has "jfjhljafvl11/2/12Jay-ext kjdhj" Sheet2 Cell A1 has "Jay" I want "Jay" in Sheet1 Cell B1 next to "jfjhljafvl11/2/12Jay-ext kjdhj" I hope I explained it clearly. Regards Jayadev

Hello, I need some VBA help on the below requirement. I have two sheets. Sheet 1 has a name called "Jay" lets say. Sheet2 has a text string with Jay, lets say like " jfjhljafvl11/2/12Jay-ext kjdhj". My question is how to get the name "Jay" out of the string and put into next cell in next...