Lets see if I can explain my problem, I am creating an assessment spreadsheet which relies on users filling in a printed sheet that has a list of set statements for each unit taught. Each unit has a different set of statements. I want to create a proforma sheet in my assessment excel workbook so I can just select which unit I want to print out and have excel fill in the cells with the required units statements. I have all the statements on an excel sheet (currently in a column, each units group of statements separated by a blank cell). What is the best way to get excel to do this? Could I then use a drop down list to select the required units statements?

Had a good look around but just getting a headache as to which is the way to go.