Forum Discussion
Vlookup
- A simple VLOOKUP like this in D38 is all you need:
=VLOOKUP(B38,
'Incoming Finance'!B$5:M$348,
5,0)
Note that the col_index_num argument of 5 is hard-coded because there is no identical column label in the Incoming Finance Sheet against which the corresponding column label in the Income Tracking Schedule Sheet may be matched.
Hi Twifoo,
Are you up for a new challenge. I am coming direct to you as you have been a great help so far. Your futher assistance would be greatfully appreciated.
I am venturing into VBA as it appears that this is the only way I can achieve what I want.
Ok here goes.
On the Incoming Finance work sheet there are a lot of rows that have very little data in them. This is OK as all entries on this sheet are manual. What i want to do is hide rows if the date is in the past and the column E is empty for that date.
I tried creating the following in VBA
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Activate
If Not Application.Intersect(Range("A1"), Range(Target.Address)) Is Nothing Then
Select Case Target.Value
Case Is = "Hide": Rows("5:10").EntireRow.Hidden = True
Case Is = "Unhide": Rows("5:10").EntireRow.Hidden = False
End Select
End If
End Sub
This works when I type Hide or Unhide in cell A1.
I want to modify this to say the following:
If Cell (B5) <= TODAY() and Cell (E5) <>0 then Row("5").EntireRow.Hidden = True
But I want to do this for all rows in the worksheet.
Are you willing to take on this challenge.
Best Regards
Vonryan