Macro to Split Data Into Worksheets based on the Filter Selection

Wed, 06 May 2015 10:28:03 GMT

Hi All,

I am working on the macro where I have a pivot table with some calculations.

	Agent1	Agent2	Agent3	Agent4	Agent5	Agent6
KPI 1
KPI 2
KPI 3
KPI 4
KPI 5
KPI 6
KPI 7
KPI 8
KPI 9
KPI 10

Filters -

User can select either Product or Software House Code (Always one Selected Value).

My requirement is I need to show the data in above table in different sheets based on the filters selected. Below is the illustration of the same.

Filter Values
Product	Software House code
ABCD	XER45
ABBB	WES67
ACCC	XCV90
ADDD
AEEE

For example if user selects Product as filter the data to be split in 5 different sheets i.e. for each product. If user selects Software House Code macro required to split the data in three sheets i.e. for each Software House Code.

Can some one help me with the VBscript or let me know in case any details required.

Regards,

Re: Macro to Split Data Into Worksheets based on the Filter Selection

marcus_sommer — Wed, 06 May 2015 10:39:32 GMT

Have a look here: VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Value

- Marcus

topic Re: Macro to Split Data Into Worksheets based on the Filter Selection in QlikView

Macro to Split Data Into Worksheets based on the Filter Selection

Re: Macro to Split Data Into Worksheets based on the Filter Selection