Rather than confuse you with words, I'm going to attempt to show you what I need to do through pictures. I think this will work a little better.

The workbook I'm using is shown here...
http://www.altairav.com/steve/step1.jpg

If you're unclear what I'm attempting after looking at this second picture, please let me know.

http://www.altairav.com/steve/step2.jpg

The actual sheet I'm working on is a bit bigger, I just wanted to simplify the example. If I can get it to work on this little example, I should be able to apply it to what I'm doing. I appreciate any help someone can give me, even if it's just some direction.

Thanks in advance!