Dear All

With the limitation of the if statement to on 7 variables I need help with a
macro to do the following

I have twelve columns each representing a particular month of the year with
financial data and account numbers along the left of the table. What I want
to do is if the month is say 6 (Column "K") then pick up the value in the
column for the row pertaining to the account number for the 6th month and
return it to say column "A"

In the old days the If Statement use to work well but nolonger, can anyone
please help with a vb script.

Thanks

Regards

Newman