I am totally ignorant to the processes and language of VBA and have been told
that I need to use a Macro to replace an IF statement that I had tried to
enter into a cell. The IF statement needed more than 7 functions so I needed
to approach the problem in a different way and this is where Select Case was
suggested.

What I need to do is quite straight forward but I have no idea how to write
it in VB, I need to look at a cell (A1) which will contain a number 1-36,
depending on the entry in that cell I require a unique figure to be displayed
in a different cell (A2), I also need cell(A2) to update automatically as
cell(A1) is altered.

Could somebody please help me in as easy to understand language as possible.

Sorry for asking such a trivial question!
--
Craig