Excel 2007 : data entry spreadsheet

Hi, this is my first post here.

I have created a spreadsheet which I would like people in my organisation to use when creating health and safety documents. The idea is that each document is given a unique reference number and the data is stored to form a record.

As you will see from the sample, I have set up a basic data entry sheet with list boxes making reference to lists within the 'lookups' sheet, and a data capture sheet.

Using comments, I have indicated where I need help. I'm an Intermediate Excel user although I know nothing about VBA coding.

Any help will be gratefully received.

Thanks, Andy.

Thanks Marcol, I appreciate your help only when I click on the 'add data' button I get a 'runtime error 13, type mismatch' message. Any thoughts?

Thanks Marcol, this latest version seems to have fixed that error message.

Thanks too to RoyUK for your advise.