even though it works, i'd really like to hear a better way of doing this. basically, the requirement was to create a spreadsheet with added columns (requirements state, requirements assigned to, etc.) based on each task type (requirement, design,build, QA). The added columns are in a reference table which I would then map into a report before exporting to excel.