hide row automatically

[shital]

i have filed like

Date, party name, amt,
startdt,proddt,proccdt,finesdt,dispdt,

i want when i fill data in all last 5 filed it should
automatically hide that row.

how to do that? any help plz.
Thanks in advance.

 

[Tom Ogilvy]

Right click on the sheet tab and select view code. Paste in code similar to
this:


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Application.CountA(cells(Target.Row,4).Resize(,5)) = 5 Then
Target.EntireRow.Hidden = True
End If
End Sub

Regards,
Tom Ogilvy