VBA To Fill In Cells Based On Criteria

Hi - I just stumbled onto this forum while Googling around, and it looks great. I'm pretty new to VBA coding so please bear with me. Effectively what I'm looking to do in this mock-up file, is anywhere the currency is "EUR" in column A, I'd like the relative cell in Column G to change to "INSERT TEXT", else I want it to untouched (i.e. to keep the comment it currently has). I've tried messing around with loops, but keep getting stuck. Would really appreciate any help, if someone has the time.

Many thanks.

You could try:

Please Login or Register  to view this content.

I ideally like to get it to sort just the data, and not the entire workbook

The below line finds the last used cell from 65000 row in Col A which in you're example is row 10 so you won't need the name ranged to make it dynamic as it already is

Please Login or Register  to view this content.

Also what exactly is "drow"?

drow is a variable range and Everstrivin should of declare it e.g

Dim drow As Range
For Each drow In Range("A1:A" & Range("A65000").End(xlUp).Row)
If drow.Value = "EUR" Then
Range("G" & drow.Row) = "INSERT TEXT"
End If
Next

HTH

VBA Noob

Try the like function

Please Login or Register  to view this content.

VBA Noob