Dear Nob,

Thanks .we dont use Ms-Access for taking these kind of reports.It's i need to do with excel vba macro only.Is it not possible in excel?