You can install Easyfilter
http://www.rondebruin.nl/easyfilter.htm
Or you can adapt the code on this page
http://www.rondebruin.nl/copy5.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
wrote in message oups.com...
Hey guys, any help is appreciated. Here is my situation: I have a
spreadsheet with over 4000 rows of data. The data has the month end
date in column A, but there is an arbitrary number of rows for each
month end. Is there a way to move the rows of data that all have the
same month end date to a new sheet named for the corresponding date.
As there are over 10 years of month end data, this is quite arduous
without a macro.