Robert,

I've got one last thing for you. Is there a way to copy a group of numbers from another excel file and copy/paste them into sheet 2 (with your code in there) and then have those numbers that were pasted be removed from sheet 1? I tried doing it kept giving me a "type mismatch". When I go to Debug it keeps pointing to this line:

If cell.Value = lngMyValue Then

I was trying to find a better way to enter the numbers instead of one by one. You sort of eluded to it in your first post(that it may be cumbersome).

Any suggestions? You can reply with a mailing address for me to send the check. LOL!

Thanks again.

Skiman