send to excel and split sheets

[#1]

I want to export a qlikview object (table box) to an excel sheet and then split it into multiple sheets based on the first column of the table box. My table would be something like below. I would want to export ID with value 1 in Sheet1, ID-2 in sheet2 etc.

Any suggestions? Thanks in advance.

ID	average	count
1	900	100
1	901	101
1	902	102
1	903	103
2	904	104
2	905	105
2	906	106
2	907	107
3	908	108
3	909	109
3	910	110
3	911	111

[Gysbert_Wassenaar]

Perhaps this document helps: Loop Charts and Field Values - Excel Export Macro