Only show the row for today’s date and hide all other rows

[oneyearsixmonths]

Hi

I would like to make my sheet only show the row for today’s date and hide all other rows?

e.g

01.01.2016
02.01.2016
03.01.2016
04.01.2016

And if the date today is 02.01.2016, it will only load all the data on that row?

This would also be for multiple people so there would be 5x todays dates on one sheet.

Thanks

 

[Joe4]

One easy way would be to use Filters.

Here is a guide on AutoFilters: https://www.timeatlas.com/excel-autofilter/
and one on Advanced Filters: http://www.contextures.com/xladvfilter01.html

 

[dchaney]

Try this

Sub HideNotToday()

Dim lastRow As Long


lastRow = Range("A" & Rows.Count).End(xlUp).Row


For Each c In Range("A1:A" & lastRow)


    If c.Value <> Format(Now(), "mm.dd.yyyy") Then Rows(c.Row).EntireRow.Hidden = True
    
Next


End Sub