Hi all, I have two Sheets. One Sheet is call "Data" and other call
"Report". I have data in Sheets("Data") (see below)

A B C D E ------columns
REF AC CC FO DK -------headings
356GFFFR 356 GFF FR 12
563XTRZS 563 XTR ZS 13
563XTRZS 563 XTR ZS 14
455TRERE 455 TRE RE 18
455TRERE 455 TRE RE 18
899VREXX 899 VRE XX 15
899VREXX 899 VRE XX 16
788SEPRE 788 SEP RE 20

I want macro which should check column A cells values and then column
E cells values and if any value in column A match eachother but value
in same row of column E is different then macro should copy that row
from column B to E into Sheets("Report") and paste in row 2 to down as
row 1 have headings. I hope i was able to explain my question.
Please can any friend help?

Macro should produce result something like this (see below) in Sheets
("Report")

A B C D ----- columns
AC CC FO DK------headings
563 XTR ZS 13
563 XTR ZS 14
899 VRE XX 15
899 VRE XX 16