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...
D2<C2 format this as green
=(D2-2)=C2 format this as yellow
Your third condition is similar to the first one. Please confirm if this is what you wanted to ask.
I believe your formula should be as follows:
Variance = (Actual-Projected)/Actual
(-2888-(-2241))/-2888 = 22%
Let me know if you need any clarification on this.
Luke I am trying to start a new topic but not being able to do so.
can you help me find the error in this code.
Sub FillInternetForm()
Dim objIE As Object
Set objIE = CreateObject("InternetExplorer.Application")
objIE.Navigate "http://www.cvent.com/RFP/NewSupplierRequest.aspx?
vtt=1"...
Hi I am applying COUNTIF(range,) without any criteria to a range which has reference to other cells in the sheet.
Why this formuala is counting only cells where I have 0 in my range?
Hi Experts,
I need your help to find conditional average for my data. Here is link to the file http://kvisit.com/SyIu7AQ , I am looking to find the average of column3 based on data from column1 & column2. Average should be for the month of Feb & June while the for a, b, c and d.
Hope I made...
I want to give an enter inside a cell containing text. The text inside cell should look like
"Prakash is the name of the Person
Singh is his middle name
Gusain is his last name"
All three line inside a cell as they are appearing above.
Thanks in advance for looking into this.