Hello, Here is the VBA code to match a string and print the result. [code] Sub sbMatchStringInColumn() lRow...
Hi Lora, Here is the vba code to rename all folders in root folder form existing name to new name. ...
Hello, Please see the below macro, it will clear the data in the B if they have more rows...
Hello Lora,Please check below procedures, I hope one of this will help to solve your query.You can get the Active...
You're welcome..You can delete this lineThen format it as you wishor replace the previous line with the proper format
You are awesome, it works perfectly. Only issue is that the Date format in the Output Sheet is coming in...
Hello Try this code [code] Sub Test() Dim a As Variant Dim b As Variant Dim i As Long Dim...
It is not totally clear for me ..
I have two types of data in two separate columns.One column have some results in it. I want to compare some specific words which are in column 1 with column 2 and want to get that result in another column. I am giving one example of it.
Column1 Column2 Column3
Senior secured loans percentage of senior secured loans SSL
I want to get the result “SSL” for all those data in the column 2 which consists senior secured.
Here is the VBA code to match a string and print the result.
lRow = 500 'This is your last row with data in the sheet/specific column
For iCntr = 1 To lRow
'This will check if column B values contains a sting and print in Column C
If InStr(1, Range("B" & iCntr), "senior secured") Then Range("C" & iCntr) = "SSL"
'If you want to check in both A & B Columns see the below statement
'If (InStr(1, Range("A" & iCntr), "senior secured") And InStr(1, Range("B" & iCntr), "senior secured")) Then Range("C" & iCntr) = "SSL"
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
Enter the destination URL
Or link to existing content