I'm trying to create a list of bough-out items for various assemblies I'm making from week to week. These assemblies are called AA, AB, AC, etc through to ZZ, so as you can imagine there are quite alot. I do not use the same assemblies each week, so no week is the same. Each assembly has between 1 & 12 bough-out items per assembly, some of which are common to other assemblies. So what I'm trying to do is type into an excel spreadsheet which assemblies I want next week inorder to get a full list of bough-out items for that week. I did originally think of doing it by filters, but I think it could get a bit messy and lead to mistakes when ticking which assemblies, so what I though was; if I physically type each assembly into a spreadsheet with corresponding quantities this should reduce the chance of making mistakes. End result...... a list of bought-out items with quantities