Hello Faseeh,
I think, I got it.
Sub test()
Dim Text As String
Dim Index1 As Long
Dim Index2 As Long
Dim i As Integer
For i = 1 To 100
Text = Cells(i, 3).Text
Index2 = 1
Do
Index1 = InStr(Index2, Text, "(")
If Index1 = 0 Then Exit Do...
Hello Faseeh,
Thank you for your prompt response. But this is useful only when I am manually adding text and brackets in a cell. My problem is I am copy pasting information from multiples sheet to a summary tab. Where I want to highlight text / number within bracket.
I hope I am making...
Hello All,
I need your help to create / Find any code which can turn any text / Number within bracket to Red.
Ex.
I have emails copied to (Turn me Red): Email Owners (Turn me Red) Name
Excel - Move (Turn me Red) Data In A Cell (Turn me Red) To Another Cell
Remove Text With (Turn me Red)...
Hi All,
Attached file has two tabs (Raw Data & OutCome). What I am trying to achieve is transposing column F & G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab.
If in the list we have more than open person with similar...
Hi Smallman,
I need VBA because, the above code is a part of big program used for calculating various forecast and pipeline. Hence the formula doesn't work as the program itself insert the column between D & E.
Now since I don't know how to tweak the code, need help in this regard.
I have the following code, which was working fine until now. The problems which I am facing is due to the change in condition. Now I'm required to add a column between D & E due to which my formula (Fm1 should change from "D7-E7" to "D7-F7").
Need you help to automate this, the code should...
Hi All,
I am working with three workbooks. My aim is to open two workbooks from cell values provided in my first workbook.
Alternatively activate workbook 2 and workbook 3 to copy paste data from wb2 to wb3.
I am using the below code but not able to do that. Please let me know what am I...
Hi Narayan,
First and foremost, Thanks for looking into the problem. Now the back to your concerns.
Row 2 is following the logic, If you see the dates in F2, G2 and K2 are from 2013 followed by NA until cell R2 where a future date coming. Hence till that point all cells are green and Pink...
Hello All,
Attached file has sample data in sheet 1 and desired output in another sheet.
I need to color cell based on certain conditions;
If date in the row is less than or equal to today, It should change color of all the cell prior to it as Green. Example Cell O3 has today's date. All...