Hi Lindsay,

If you could post a sample workbook, it would be easier to understand what you're asking, and provide an answer.

Cheers,