Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Select Row Based On Cell Criteria

  1. #1
    Join Date
    15th February 2007
    Posts
    6

    Select Row Based On Cell Criteria

    I am trying to create a macro that selects an entire row based on a date criteria. The explanation is as follows:

    I have fields in an excel sheet such as : Name, Date, Place, Time, Country etc…..

    There are many rows with data in them….

    I require a prompt box that asks for a date range and then selects all the contents matching that criteria and copies into another excel sheet called Export.xls.

    Thanks so much

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    Re: Select Row Based On Cell Criteria

    Hi

    welcome to ozgrid

    See here for some code, especially the part: Copy filtered rows.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  3. #3
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,541

    Re: Select Row Based On Cell Criteria

    Take a look at this post to see if it helps...

    http://www.ozgrid.com/forum/showthread.php?t=31461

    Ger
    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

  4. #4
    Join Date
    15th February 2007
    Posts
    6

    Re: Select Row Based On Cell Criteria

    Thanks Guys.

    However my concern is that i need a pop up box or a prompt box to ask the user to enter a start date and an end date to select the date ranges....depending on the search criteria, corresponding rows will be selected and the values pasted in another excel work sheet.

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,541

    Re: Select Row Based On Cell Criteria

    Maybe this might help...

    http://www.ozgrid.com/forum/showthread.php?t=54192


    Sorry, I dont have time right now to write code...

    Ger
    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

  6. #6
    Join Date
    15th February 2007
    Posts
    6

    Re: Select Row Based On Cell Criteria

    Hi,

    To give a better idea as to what i am looking at, following are the excel sheets attached.

    Sheet one - A.xls

    Sheet two - B.xls

    Sheet three - output.xls

    When the user runs the macro, it must prompt the user a start date field where in the user would type 2/5/2007 and another prompt for an end date for which the user would enter key 2/9/2007. Both these dates are sample dates any date values could be entered.

    The macro would then copy all rows corresponding to the start date and end date from Sheet A and Sheet B and paste them in sheet output.xls...

    Please check the output sheet to see the out put.

    Thanks so much for your help.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by tchwhy; February 15th, 2007 at 18:11.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Select Rows Based On Column Fitting Criteria
    By tenbuhorin in forum EXCEL HELP
    Replies: 2
    Last Post: August 16th, 2008, 09:19
  2. Replies: 5
    Last Post: March 18th, 2006, 14:42
  3. select row based on multicolumn criteria
    By timjea in forum EXCEL HELP
    Replies: 5
    Last Post: January 9th, 2006, 16:41
  4. Select and Arrange Data based on Criteria
    By sinembagci in forum EXCEL HELP
    Replies: 9
    Last Post: December 1st, 2004, 09:07
  5. Macro to select sheet based on criteria
    By Steelinadje in forum EXCEL HELP
    Replies: 1
    Last Post: August 25th, 2004, 21:34

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
  •  
porno