+ Reply to Thread
Results 1 to 5 of 5

Macro Find Date

  1. #1
    Registered User
    Join Date
    11-08-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    28

    Macro Find Date

    Hi everyone,

    I am creating my first ever Macro and am just understanding concepts. If someone could help me with the following I would be really grateful. I need to create a macro that looks for a range of dates (Today´s Date - last 15 days) selects the columns and rows that are in that range and deletes them. I haven´t quite understood the find function yet.

    Thanks a lot

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro Find Date

    attach a sample file with comments
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    11-08-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Macro Find Date

    I attach the sample file. Hope you understand what I´m trying to do.

    Thanks a lot!!
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    123

    Re: Macro Find Date

    Hi,

    Please help me conditional formatting for the below results. When cell is zero should not displayed/blank cell, if more than zero should be reported.


    Apple 1 3 1 0 0
    Mango 1 3 0 0 0
    Orange 0 0 0 0 0


    jagadeesh.rt@gmail.com

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro Find Date

    hi lorena.tgarza, option to make it, press the button

    @jagadeesh.rt
    You can not post your request in the thread of another user. Under the Forum rules you need to start your own thread to get replies.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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