Hey guys,

I am currently a quantity surveyor on work experience placement and am struggling to find a way to create a template using excel. All I want are a few headings (Demolitions for example) and once I have selected that heading, I would like the cells under it to display a drop down box with a list that I have pre entered. I have gotten this far but here's the problem, each item has a corresponding unit, qty and rate. How do I enter this information?

Cheers!