Loop selected field value and >selected field value in a report and export using macro

[#1]

Hi All,

I have a requirement to export report to excel. I found the below link in qlikview community.

VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Field Value

But my requirement is not to loop all the values in the selected field. I should control the values in the field.

Example: month field contains jan to dec values and year : 2017,2018.

Now when I select 2017 July, exported excel should contain data from 2017 July to 2018 Dec in each tab in excel.

Thank you in advance for your help!!.

[tamilarasu]

Hi Krishna,

Please provide us some sample file.