Excel - want to copy data falling between 2 dates from one sheet to another

Hello all.

Any help on this one (for someone who is well and truly out of his depth here) greatly appreciated.

I have played around with this one for ages and I think I am just way to much of an excel noob to even begin to understand how to do it properly.

I need to be able to somehow copy the data from a specific row of sheet 1 and paste it to sheet 2 if it the date falls in between the range I specify (eg 1 April 2012 - 30 April 2012).

Any ideas?

See attached demo

Cheers.

trevor.

See: Yousetouse_demo.xlsm

Run: Run_CopyRowsBetweenDates

StevenM,

Thanks for that mate. Much Appreciated.

How would I now extend this to copy data across to column p? (giuven that in my example sheet i only had data across to column E).

Trevor.