Fire up the macro recorder and see what you get.

You will get a macro you can run.

Fully automatic would need some type of event to trigger the macro.


Gord Dibben MS Excel MVP

On Thu, 11 Jun 2009 15:56:02 -0700, Marysam67
wrote:

Is there a way to sort by date range and copy data to another workbook
automatically?