comparing sheets
 

hi,

i have a load of data on one sheet and a list on another sheet. i need to
highlight all the rows in the data sheet (or better still copy the rows to a
third sheet) that match the values in my list sheet.
grateful for any help.