Forum

Yes, just add that in as another criterion like the first section of the SUMPRODUCT formula.

I think this: ActiveSheet.ExportAsFixedFormat xlTypePFD, FileName should be: ActiveSheet.ExportAsFixedFormat xlTypePDF, NewFile

If they are always in the same order, this would do Pico in E3: =SUMPRODUCT(--($C$12:$C$119=$D3),E$12:E$119,E$120:E$227) I'm not clear on whethe...

I'd make your data source into a table, called say SourceData, then use a formula like: =IF(SUMPRODUCT(SUMIFS(SourceData[Grad_Proj],SourceData...

For Requirement and Graduates, you only want the numeric cells so you can use COUNT: =OFFSET(Visuals!$D$6,0,0,COUNT(Visuals!$D$6:$D$31),1) =OFFS...

You could use a small tweak: =COUNT(SEARCH($J$1,$H$2:$H$7)*SEARCH(M5,$H$2:$H$7)/($I$2:$I$7=1)) Note: may need array entering depending on your v...

FYI, cross-posted here:

Here's one way. It creates a query for just the null date rows, groups by the Custom field and then converts the Explanation data into a comma separat...

A Word document isn't particularly helpful for testing purposes - any chance of an Excel workbook?

I amended the code you had in the Worksheet_Deactivate event to simply refresh the pivot.

The attachment didn't make it. Also, which version of Excel are you using?

Make it a connection only query, then use that as the source (choose external data) for the pivot table. Something like the attached (you have...

Do you actually need the table on a worksheet?

You're welcome! 🙂

I'm not seeing what you are seeing. In what way are the values incorrect?