Is the second column a Text string or is it actually a date. If it is a
date, you can use an autofilter and use a custom criteria such as Creater
than 31 December 2002. If it is a string, you could use an autofilter with
a custom criteria of contains 2003.

In any event, this will hide all the rows you don't want. You then select
all the data and copy it to the new sheet - only the visible rows, the data
you want, will be copied. This is so simple, it would be a waste of time to
create a macro to do a one time action like this. It would take less than a
minute to so this.

The Autofilter is found under the Data menu, then filter, then Autofilter.

--
Regards,
Tom Ogilvy

"Harish Mohanbabu" wrote in message
...
Hi,

I have got an excel sheet with 2 columns. The columns are -

1 2
Customer Name Invoice date

Invoice date column is strored in the format of 'Month Year' (ex January
2003)

Now what I want to do is -

1. Create a separate sheet in the same document
2. Display all the customers who have invoice date after 'December 2002'
to till date and save it as 2003
3. Similarly create a separate sheet and display customers who have
invoice date after 'December 2001' but
before 'January 2003' and save this sheet as 2002 and so on for the
rest of the year.

I want to do it programatically because the excel sheet I received
contains more than 2000 records with mixed date range.

Can someone help me please ....

Thanks in advance,

Harish Mohanbabu