loop through and export to different excel

[gauthamchilled]

Hi,

I have a table and listbox. I want a macro to loop through possible values and export the table to different excel files for each values in the listbox.

any idea?

Gautham

[Siva_Sankar]

Attached an example. Do you need some thing like this?

Siva

[gauthamchilled]

It loop through sheets..i want to export to different excel not different sheets..

[gauthamchilled]

Any help?

[gauthamchilled]

Bump..