Compare colunns and if do not match write row to a new sheet

Hi,

I would like to compare columns Y and AI and if they do not match, then cut that row and paste it to a new sheet.
when the new sheet has all of the rows with Y and AI not matching I would like to save that sheet as warnings.xls and then return to the begining sheet which now only contains the matching data for columns Y and AI and save it as complete.csv.

Thanks for any help,

David

Hello,

Hope the code shows up alright... first time using the tags.

Any rate, I tried to comment as much as possible so you understood all the various parts of the attached code, especially the parts which will require your input. Look for the commented areas with 5 x *.

If you have any questions, let me know.... it's a bit overboard, prolly.


Cheers,
Xervice

Please Login or Register  to view this content.

Thank you crosservice, thats works great. The only error I receive is when it tries to save the xls file. I'm using excel 2003 if that makes a difference.

The error I get is Method 'SaveAs' of object '_Workbook' failed.

Thanks again,

David

Ok got it, changed the fileformat to x1Normal.

Works great thanks crosservice