Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Select Row Based On Cell Criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.com ==> English articles ==> Excel memes

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

    Comment


    • #3
      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

      Check out our new reputation system. Click on the "star" under the post!
      _______________________________________________

      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

      _______________________________________________

      Comment


      • #4
        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

        Comment


        • #5
          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

          Check out our new reputation system. Click on the "star" under the post!
          _______________________________________________

          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

          _______________________________________________

          Comment


          • #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
            Last edited by tchwhy; February 15th, 2007, 19:11.

            Comment

            Trending

            Collapse

            There are no results that meet this criteria.

            Working...
            X