View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Michael.Ray.Pennington@gmail.com is offline
external usenet poster
 
Posts: 2
Default Move data to new sheet - rename sheet based on criteria ?

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.