Copy data from worksheet if selected on checksheet

[dave.carr]

Hi
Hope someone can help, have not used macros before and not sure where to start.

I want to create an excel file for risk assessment
The engineer will select the risks from a checklist (sheet 1)
Standard working and data values will be prestored on sheet 2
The Items selected on sheet 1 will be inserted into Risk (sheet 3) on the next available row.

I hope the solution is simple, have attached example

Dave

[MaczaQ]

Hi,

Please check if attached solution cover your needs
For check my code press ALT+F11 and then look into Sheet1 code

Best Regards

[dave.carr]

Hi
Thanks for the solution , just what I wanted