What I have is (7) worksheets with a list of values in column b5 thru b558 in each one and in another worksheet I have another list of values in column w5 thru w128. What I need to do is delete any rows from the b5 thru b558 set that contain a value from the w5-w128 set, any thoughts on how to do this? If you want me to attach the spreadsheet's I will just let me know. I'm not very familiar with excel functions so your patience is greatly appreciated.