Filtering & copying ranges

P

Peter

I have a spreadsheet of many rows. Column A is dates in the format 01/01/04
to 31/12/04. I wish to select only rows containing Oct (ie: 01/10/04 to
31/10/04) and copy them another worksheet for further analysis.
Can I do this automatically (that I could record a simple macro around).
With thanks
Peter
London, UK
 
D

Dave Peterson

You could record a macro when you applied data|Filter|autofilter.

Then use a custom filter between Oct 1, 2004 and Oct 31, 2004. Then copy those
visible cells.

Then copy those visible rows.

post back if you have trouble with your recorded code.

(Sometimes VBA and excel don't work nicely with dates. You may want to include
a helper column:
=text(a2,"yyyymm") and then filter on 200410.)
 
Top