Macro to copy rows from one sheet to another based on selected date range

**kmahesh** · 12-15-2014, 03:02 AM

Hello experts
I am attaching herewith an Excel file which contains 5 sheets.

It contains a sheet called Periodic Data. In this i am entering From & To dates and click on the command button.
It copies the rows from MAST sheet where the Left Port is >=From Date and <=To date.

The code is working , but the problem is of speed.

The date range can be of 1 week , 2 week , 1 month , 6 months & so on.
The problem is greater the period, the more number of rows are to be copied and more time it takes to run the code.

Please have a look and suggest something to improve the speed.

Kmahesh

**:) Sixthsense :)** · 12-15-2014, 03:41 AM

Try this...

Please Login or Register  to view this content.

**kmahesh** · 12-15-2014, 04:12 AM

Sixthsense ,
Its not working.
After I click the command button it is not showing even a single record.

**romperstomper** · 12-15-2014, 05:09 AM

Ahh, VBA and dates.

Change this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

**kmahesh** · 12-15-2014, 05:29 AM

Thank You romperstomper
it works perfect , will u please explain what is CDb1 ?

**romperstomper** · 12-15-2014, 05:43 AM

CDbl converts a value to the data type Double (see data type descriptions here).

It's necessary here because VBA will interpret a date string using US format if it can - so it would interpret your 1/4/2014 as 4th Jan 2014, not 1st April 2014. Since Excel stores dates as numbers (the number of days from 1/1/1900), using CDbl converts the date value into the number 41730 which cannot be misinterpreted.

Macro to copy rows from one sheet to another based on selected date range

LinkBack

Thread Tools

Rate This Thread

Display

Macro to copy rows from one sheet to another based on selected date range

Re: Macro to copy rows from one sheet to another based on selected date range

Re: Macro to copy rows from one sheet to another based on selected date range

Re: Macro to copy rows from one sheet to another based on selected date range

Re: Macro to copy rows from one sheet to another based on selected date range

Re: Macro to copy rows from one sheet to another based on selected date range

Thread Information

Users Browsing this Thread

Similar Threads

Macro to copy rows based on moving date and paste the rows into an identical sheet

[SOLVED] Copy Rows To Predefined Sheet Based on Date Range Using Form or Message Box

Copy rows to new sheet based on date range selected on a form

Copy Rows from selected Sheet to New Sheet based on Cell Value

Copy Rows In New Sheet Based On Date Range Criteria

Bookmarks

Bookmarks

Posting Permissions