If and then statement macro
I am trying to write a macro which checks the data in cell A and B in a
worksheet then outputs in col c.
e.g
If Cell A1 = "Fund A" and ' check Fund here
Cell B1 = "Client Name" then ' check list of clients here
Cell C1 = "account number" ' output clients a/c no. here from list
end
This statement needs to run through all of Col A and B and check 10
different Funds and 20 client names. to produce given account number
|