Code for data extraction

[jemohkush]

Dear All,

Kindly assist a friend.

I have a master workbook. Column 'G' has dates in the format 'dd/mm,yyyy.
I regularly extract data from the master sheet using dates; say filtering data between 1/11/2014 and 30/11/2014 and copy it to a new sheet. I know I can use a formular but since this is a routine task, a macro will do.
Kindly assist me.

[alansidman]

Try this:

Please Login or Register  to view this content.

[jemohkush]

Thanks Alan,

The code is working but as I indicated the data is in more than 200,000 raws hence it returns data out of range. Kindly assist.

[alansidman]

I don't understand. Are you getting an error message when you run the code? If so, provide the full error message and the line of code that is highlighted when you click on debug.

[cory0789]

I am with alan... his code should do exactly what you are asking if you have 80000000000000000 rows it will still find the last row of the data and copy and paste it where you want it....