Using Excel to produce a report

Please Help

What I have is scores that rate different behaviour types. Different scores suggest different strategies. What I want to do is use Excel to automatically produce a report of the different strategies based on each score.

Hope I am making sense?

So say they score 20 in one strategy it will automatically produce the strategies and then 10 in another category which again add to the strategies.

Is it then possible for it to automatically send this text to a word document?

At the moment I am manually inputting the data and then copying and pasting out of word the specific strategies I want. It will save some major time if this can all be done automatically.

Thanks for your help
SIMON

Try Again

I have a work book in excel with scores for different behaviour categories based on a questionaire about behaviour. From these scores I manually produce a report of different strategies that improve that behaviour.

What I want to do is to produce a report automatically instead of having to put it together myself.

Eg.
Student A scored 10 in aggressive behaviour it will then automatically put the predetermined strategies into a report.

.......or at the very least a list of behaviour types, a list of predetermined strategies and what scores they apply to for each behaviour type.

Thankyou for your advice at producing an example, I have attached one here.

What I want to do is produce a report.

For example if E2 is above 7 I want to give example advice 1 in A37 in sheet number 2 in cell A1
For example if E3 is above 12 I want to give example advice 2 in A38 in sheet number 2 in cell A2
etc

I then if possible want to export all the advice in sheet 2 into a microsoft word document.

Hopefully this has cleared things up.