have a worksheet that contains multiple records that need to be grouped and
exported to a new workbook. Values to group by are in column a, so for
example all of the records in column a with a value of 2011 need to go to a
workbook named "2011.xls", all of the reocrds in column a with a value 3535
need to go to a new workbook named "3535.xls" etc. etc.

I will be receiving this data weekly and need an automated way to split it
up into distinct workbooks by value in column A

Thank you in advance for your help. Regards, R-