Thanks for the help. I ended up going with teh first solution seemed simpler. Though I'd still like to add 1 mor eline that clears the responses on Sheet 1 range b1:b20