Nikki
You can use formulas for this type of thing if you want this done only
once. But if this is a repeating task I would suggest an event macro. If
you want to use an event macro you will have to decide when you want this
copying to take place. IOW, what event do you want to trigger the execution
of this event macro. When the file is printed? When it is saved? When it
is closed? When a specific cell content is changed? Post back and provide
more detail about what you have and what you want. HTH Otto
"nikki8327" wrote in message
...
Hi, I have a questionnaire that is administered on an excel sheet with
respondents typing their answers (i.e 1,2,3) into specific cells. Is there
any way that I can create a formula (or something??) that inserts response
relevant text into another sheet in the workbook, to create a report?
Many Thanks,
Nikki