Search results

webmax, you need to put a file somewhere and update the link I gave in the code Const strFilePath As String = "C:\Users\Public\Documents\Excel\OutlookMailItemsDB.xlsx"

Hey, that's cool. I'll use this from now on. Thanks Luke.

webmax, the macro runs whenever there's a new mail coming to your inbox. you cannot just run it like calling any subroutine. I was under the impression that you are looking to capture data as and when you get mails in your outlook. Please clarify, and sorry for the confusion.

Use SUMPRODUCT instead OR (typing on the fly here, untested) =SUMIF('QTR 1 - Bonus Calc'!$A$3:$A$164,'Mthly Accr Sum'!A11,'QTR 1 - Bonus Calc'!$X$3:$X$164)

Appreciate the feedback, but in the same vein, I'd request using code tags whenever you post codes. It enhances readability.

Probably not the best substitute, but an asterisk might be better than a period. Well, I guess that also has it's limitations.

Thanks for explaining the method Luke. Saved me time. The Wingdings font can be changed back to the standard Arial (or any other regular font), and use a full-stop (period) in its stead. And increasing the font size a few notches will give the same feel as that of an icon.

actually, we could have used =COUNTIF('QTR 1 - Bonus Calc'!A2:A25,'Mthly Accr Sum'!A3) However, you said you only wanted to count those that had a YES in the adjacent column. And countif doesn't allow that. Another formula we could have used is COUNTIFS, but I thought SUMPRODUCT would be...

You could manage using conditional format. Try this. You can figure out the logic by looking that the conditional format. If you aren't able to, but still want to use it, let me know.

When you say 'turn', do you mean overwrite / replace? Or do you just want to use a formula to look-up the colors in one column, and in an other column, represent their corresponding number through a formula? If the latter, then you could use this B1=MATCH(A1,{"Red","Yellow","Green"},0)

I thought that's exactly what I proposed... only since I didn't know the sheet names and exact position of the columns, I posted the above formula Try this F3=SUMPRODUCT(('QTR 1 - Bonus Calc'!$A$2:$A$25='Mthly Accr Sum'!A3)*('QTR 1 - Bonus Calc'!$C$2:$C$25="YES")) and drag down

Sub P_4410() Dim i As Integer For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row Cells(i, 2).InsertIndent Cells(i, 1).Value - 1 Next i End Sub

If I understand you correctly, this should work =SUMPRODUCT((Sheet2!A1:A100=Sheet1!A2)*(Sheet2!B1:B100="Yes")) Where the first column in Sheet1 is the designators, and the first and second columns of Sheet2 are the designators and the Yes/No columns respectively

If you don't mind a VBA solution, this should suffice for a non-mac platform Function ExtractCAP() As String Dim objMatch As Object Dim var As Variant, lngLoop As Long, lngMatches As Long var = Range("A1:A5").Value2 With CreateObject("VBScript.RegExp")...

like i said, it should be in the OutlookSession module NOT a standard code module

Here's one way to do it. You need to paste this in the OutlookSession code module Const strFilePath As String = "C:\Users\Public\Documents\Excel\OutlookMailItemsDB.xlsx" Const strSubjectLineStartWith As String = "" Private Sub Application_NewMailEx(ByVal EntryIDCollection As String)...

Could you test this? Sub DoIt() Dim Cht As ChartObject Dim ser As Series Dim I As Long, J As Long, K As Long With Me For Each Cht In .ChartObjects On Error Resume Next With Cht.Chart For Each ser In .SeriesCollection...

Narayan, I just deduced that logic from this statement so yes, I agree that filtering it out as you say should give the answer OP is looking for, but I thought the requirement was that of a formula :)

For some reason, this seems to have an uncanny resemblance to the thread here (at least the attached files are the same) http://www.excelfox.com/forum/f2/superscripting-a-portion-of-text-in-data-label-of-a-chart-1412/

OK, so from your original query, I am assuming that you mentioned that the max and min for the second cycle is 8 and 5, and NOT 9 and 5, because you are only considering the values against the starting 1 and ending 1 for each cycle. Keeping that assumption as true, and assuming your data starts...

And speaking of which, Usman, any reason why a VBA solution will not suffice?

That seems to make sense Narayan. Let me try that out.

Surely, you've missed the attachment. Anyway, to format a series on a chart, one could select the chart, and click on the individual series using the cursor, and go to the format section on the ribbon tab, and select the format color.

Usman, apparently, your question has left everyone clueless. You might want to post a trimmed down version of your workbook with the input, and the expected output. That way, it might be easier for the volunteers here to try and provide a solution to your query.

Crystal. And I hope it's safe to assume that the unique IDs do not have any special characters that does not allow it to be used as a file name? Once you clarify that, I guess I've got all the information I need to create a macro. You have to excuse me as it's late here. Other developers who...