In that case, I think you'll need some VBA. Paul's your man. I cut my VBA teeth in Access and for whatever reason can't wrap my head around Excel VBA without inducing several mini-strokes.