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

Could you please explain where you get the account number from?
What should be placed in column D?

Also: when you write "if data in cell B = "text" ", do you mean if cell B
contents contains text (no number) ?

HTH
--
AP

"George" a écrit dans le message de
...
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