IF function referencing a range of cells and sheets

[mwgrace]

Hello,
I am setting up an expenses tracker for myself each month has it's own sheet and I have the last sheet tracking my Visa bill.
What I want is if the Value in Column I in any of the sheets is "Visa" then copy the value in cell K to column E in the Visa Sheet in the form of a list. For example if May!I2=Visa then copy value of May!K2 to Visa!ColumnE I would like to be able see the individual transactions.
I have a few more questions but I'll stick to just this one for now.
Thanks!

 

[SteveO59L]

Something along the lines of

Dim ws As Worksheet
Dim c As Range, rng
Dim lastrow As Long
Dim visa_val As Long


For Each ws In ThisWorkbook.Worksheets

If ws.Name <> "Visa" Then
ws.Activate
lastrow = Cells(Rows.Count, "i").End(xlUp).Row
Set rng = Range("I2:I" & lastrow)

For Each c In rng

If c.Value = "Visa" Then
visa_val = c.Offset(0, 2).Value

Sheets("visa").Activate
lastrow = Cells(Rows.Count, "k").End(xlUp).Row + 1
Range("k" & lastrow) = visa_val
End If
Next c

End If
Next ws

 

[mwgrace]

I'm sorry, I'm new to excel and I'm not sure I understand.

 

[mwgrace]

I'm sorry, I don't understand what this means. Could you please explain?

 

[hannah2233]

try using vlookup

=vlookup("Visa",select your array,column which u want to return,False)