Home

Populating sheets with multiple cells

AndusCP
Occasional Visitor

Morning all.

I'm trying to create a document whereby I can select multiple options, possibly in separate sheets within the workbook to populate the page.

I spend time creating risk assessment documents for my company. The documents are all very similar in layout, with only the risks changing. There are about 10 separate risks I generally use, on average each seperate document would have between 3 & 8 of these risks. I would like to have the option to select the risk options I require, which could be across multiple cells and have them pasted into a pre-prepared template which I can then edit as required (date, location etc).

Any ideas would be gratefully received.