Macro for WS/WB comparisons, and copy/paste two cells based on matches

Hi All,

I've been racking my brain for the last 5 days trying to solve this issue.

Synopsis - Every day I receive an Excel file from a batch output, and essentially my job is to raise work tasks based on the new errors. This means that every day I have to go through anywhere between 50-1000 records and matching them with yesterdays output. Firstly, I peruse column A for a matching number between the two, then when I find a match, if column E and column J match also (date format and free text respectively), I copy the cells from columns B, C and D of that row (a number, the work task number and date raised) in yesterdays sheet, into today's sheet.

Essentially I'm looking for a macro that:

• Copies sheet 1 from yesterdays sheet into sheet 3 of todays sheet.
• Compares the two sheets, based firstly on the NUMBER in column A, if match is found and value in cells E and J also match (date and text), then copy cells B, C and D for that row from sheet 3 (yesterdays) into sheet 1 (todays)
• Important to note that the rows won't match based on row number but on cell values

Any help would be greatly appreciated.
I've been trying to reverse engineer the following code to at least get a start, but my 10+ years since using VB at school has taken me back to n00bdom.

Please Login or Register  to view this content.

I've also attached a spreadsheet just to show what I mean. (Because I'm a nice guy)

Any help is appreciated!

Hi adilley

Still no attachment that I see.