Hello
Can anyone help me with a macro for the following problem.
I have a master sheet with hundreds of rows. When the category in column A (department name) changes, I want to export these rows into a new workbook which will be called after that department.
eg. SALES.XLS
I have seen some great posts already on this site which shows me how to do this.(e.g. http://www.excelforum.com/excel-prog...e-in-data.html)
However I have another requirement which complicates this.
There is another column in the master sheet which lists dates in dd/mm/yy format. Once the rows are exported to the new workbooks, I need these rows to further separate into four different worksheets, one for each quarter.
Q1,Q2,Q3,Q4
There are perhaps a dozen differnt departments in the master sheet (HR, IT, Sales, etc)
Once the macro is run, the master sheet should still exist, but now there will be 12 new workbooks named after the department they contain, all with four worksheets, one for each quarter.
Finally, if possible, they should all be saved to a new location within a folder called after the department
e.g. S:\\MIS data\Sales\Sales.xls
Any help would be much appreciated.
Martin
Bookmarks