+ Reply to Thread
Results 1 to 2 of 2

Hide Future Rows Containing Future Dates.

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Hide Future Rows Containing Future Dates.

    Hi,
    My Excel Spreadsheet is updated each month with that months' figures.

    I.E.
    In Cell Range D3-D75 Contains Dates (Jan 2010 - Dec 2015)
    Thus the Rows 3 - 75 have corresponding data for each month. It is updated with the next months' figures on a monthly basis.

    I want to create a Macro where I can UNHIDE the relevant Rows (all dates from Previous Months to the Present Month) and HIDE future months that havent been filled.

    I have created a drop-down list containing each month correspding to the Cells D3-D75 in A2.
    I was thinking of creating a loop in order for Cell A2 to lookup the Array Cells(D3-D75) until the dates correspond with eachother and thus hide the following future date rowsMonthly Reviews.xlsx.

  2. #2
    Registered User
    Join Date
    03-25-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Hide Future Rows Containing Future Dates.

    Please. I beg of someone to help me please.

+ 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