how to save new file based on autofliterd value

[rajrbr]

hi
i have sheet which cntains monthly inventry data.

col:- a has month ( viz... , apr08... ,may-08............. mar09)

i want to creat xls file depending on filter value and this file should contain only the filterd data ( 1-10 pages depending on filterd sheet data )

end result epected :-

apr-08.xls ( 2-3 PAGES DEPENDING UPON DATA SIZE)
may-08.xls