[Lordwinky]

I am using Excel 2002 to create a management evaluation template. Within the template, my boss would like any line item that is assigned a score of 'Does Not Support Operations', selected from a list drop down, to autopopulate the the item that was assigned that score onto a new tab. Is there a way to do this?

For example:

The form would be set up as following

Score Question
Supports Operations Technology meets needs
Does Not Support Operations Layout of lobby supports customer needs
Supports Operations Time goals are met

Since 'Layout of lobby supports customer needs' received a 'does not support operations' - that question would autopopulate on a new tab within the workbook.

Anyway to do this?

Thanks