Dear Experts,
Attached File There is Pivot Sheet Contains a PivotTable, Whose Source Data from NPD De-Commitment Sheet.
The Source Data Gets updated by Every Day 09:30AM; Once the Source Data gets updated, within 30 Minutes of Time; The Respective owner (Refer Column D) expected to update their Remarks in Column F Respectively!
The Support which I am looking here is: -
From 10:00AM Onwards Every Thirty Minutes the Pivot Data must get Auto Refreshed. After Refreshing;
If the Cell J1 Value is a Text or 0, Then No Action Required!
If the Cell J1 Value is >0, Then the Following Action to Be Processed!
@ Each Time Zone How the E-Mail Draft to be send Details are available in “Pivot” Worksheet K16:O19 Range Table
Note: If the E-Mail can be triggered automatically even when the file is closed also; That would be really an great additional Feature!
Looking forward your valuable inputs!
Thanks & Regards,
Rajeshkumar R
Bookmarks