Hi,

I have 2 sheets in a workbook.
1st sheet has 1st 4 columns biz, region, city, customer
2nd sheet is the data sheet running to 14000 rows having same 1st four
columns, but data is not in sort order, data has been appended as
received/analysed)
Now If I choose one biz and click a button I should get rows of that biz
copied to new workbook with the first 5 rows (headers in sheet2) and save the
file as the biz choosen with ddmmm (date & month) example: if I choose biz :
auto, the outfile should be "auto24mar.xls".
Similarly for Region : "North24mar.xls" (if north is selected)
Similarly for City : "Dubai24mar.xls" (if dubai is selected)
Similarly for Customer: "Team24mar.xls" (customer should be by 1st word)

Now I am doing by Pivot table, copy & paste as value so on, time consuming
as I have to do all formatting.

Thanks in advance.