If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide row based on cell value
Colum C shows a date. If the date shown is older than 4 years I want the row
to be hidden. Is it possible to do this? |
#2
|
|||
|
|||
Hide row based on cell value
Here's one easy, effective play using a helper col & autofilter ..
Insert a new helper col D, if necessary, next to the dates col C (dates in col C are presumed real dates recognized by Excel) Put in D2: =IF(ISTEXT(C2),"",IF(C2=DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY())),"x","")) Copy D2 down to cover the max expected extent of data in col C. Col D flags directly the results that you're after ("x"), ie where the dates in col C are NOT older than 4 years (the other way around to look at it) Anytime that you want to exclude/hide dates in col C older than 4 years .. Just apply autofilter on col D, choose: x and that's your baby (the filtered results) ! Aloha? Celebrate it here, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Munchkin" wrote: Colum C shows a date. If the date shown is older than 4 years I want the row to be hidden. Is it possible to do this? |
#3
|
|||
|
|||
Hide row based on cell value
Try the below macro...
Sub HideRows() For lngRow = 1 To Cells(Rows.Count, 3).End(xlUp).Row If DateDiff("m", Range("c" & lngRow), Date) 48 And _ 0 + Range("c" & lngRow) 0 Then Rows(lngRow).Hidden = True Next End Sub If this post helps click Yes --------------- Jacob Skaria "Munchkin" wrote: Colum C shows a date. If the date shown is older than 4 years I want the row to be hidden. Is it possible to do this? |
Thread Tools | |
Display Modes | |
|
|