Forum

Ok, here is what i think: analyzing a trend in the source data is a bit unusual, trending towards failure is not a strong KPI, because I guess that...

ok, so we cannot rely on date time to identify previous readings, as they are the same for all sub tests? Only sub test ID we can use to clearly ident...

Hi Dave, An easy way is to add a formula in your data source to compare the reading with the previous readings of the same test, the formula should...

Have you checked if there is something in that array? What gets printed if you add this line before adding the validation: Debug.Print Join(Obje...

Hi, Instead of .Body, you can use .HTMLBody, then you'll be able to use HTML markup: here is a link with an example: You might also need to...

Not following... .[Date (Year)].&["&D8&"]") In that cell D8, you can put any formula or dropdown with your year values, you need hel...

Hi Patt, The structure is not right, all the problems described come from structural design issues. A way to do it can use 2 tables, one with Ac...

Hi, Have you tried: =CUBEVALUE("ThisWorkbookDataModel",$B$5,$C8,D$6,"[Data].[Date (Year)].&["&D8&"]") Change D8 to your cell wher...

Hi Amanda, Your code creates the emailitem BEFORE the loop. After the first email is sent, the emailitem does not exist anymore, you cannot refe...

Hi, Try this code for filtering: Dim StartDate As Date, EndDate As Date StartDate = ThisWorkbook.Worksheets("T").Cells(4, "C").Value2 EndDat...

Hi Sherry, The code is properly placed now, but I made a small mistake: I referred to ThisWorkbook, where the code is, not to the NewWb, where t...

Sorry, the place for the code is wrong, my mistake. Please move the code just above End Sub line.

Why would you remove those sheets? I mentioned to make sure you HAVE those sheets in your workbook, or update the code to your sheet code names. Is...

Before this line: If MasterDict.Count > 0 Then The following code should be added: Dim Wks as worksheet Application.DisplayAlerts=F...

Hi Jose, It's an excel code, not outlook. Make sure that you have in your excel file the sheets mentioned in code: Sheet1, Sheet2 (these are cod...