Results 1 to 6 of 6

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

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

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

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to copy rows based on moving date and paste the rows into an identical sheet
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 11:59 AM
  2. [SOLVED] Copy Rows To Predefined Sheet Based on Date Range Using Form or Message Box
    By Isacc in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-06-2013, 09:25 AM
  3. Copy rows to new sheet based on date range selected on a form
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2009, 11:40 AM
  4. Copy Rows from selected Sheet to New Sheet based on Cell Value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-03-2008, 03:44 PM
  5. Copy Rows In New Sheet Based On Date Range Criteria
    By ahmedwaseem2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2006, 05:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1