I have Excel report having 8 Master filters written below. User needs to choose "AreaName" like "Greater China" and so on...and click "Apply Filters. After clicking the "Apply Filters" button, sheet is connecting to the Database and data gets refreshed after few minutes. My goal to capture the exact time duration or you can say Performance for Data Refresh by writing Macros in another workbook. Can anyone advise me how can i achieve this.
AreaName
RegionName
SubregionName
SubsidiaryName
ServicePersonnel
SummarySegmentName
CurrencyCode
Previous Forecast Month