I want to run an If statement or loop macro over two columns (say Col B and
C) that asks if data in cell B = "text" and cell C = "name" then return
"account number" to column D.
e.g
Cell B1 = ABC Bank
Cell C1 = Account Name
Cell D1 = Destination cell = Account number
This loop needs to be done on more than one Account Name.
Your help would be greatly appreciated.
George