Comparing datas of two sheets using macro

Hi,
I need your guyes help again....
I have 2 sheets.
Sheet1 -Named as Delivery. Sheet2 - Payments
I have to compare both the sheets and find out the difference.
Sheet Delivery has differnt columns from A to I and Sheet Payments has different columns from A to H, the only common column names n both the sheets are Column TPNDs,Column Qty, & Col Euro

after each TPNs i have 3 blank rows inserted in both the sheets

I cannot use Vlookups to get the data as both the sheets have more than 10 entires with the same number.

What i need to do is, first i look at sheet Delivery I have 10 entires for delivery of the same TPND say 39606.

Now il go to sheet Payment and look for 39606 I could find only 6 entires
which matches with Delivery that is TPNDs,Column Qty, & Col Euro.
I want to highlight the rest 4 entries.

That is, Invoice may have 10 entires but delivery may have only 5 entires. or
delivery may have 10 entries invoice may have 5 entreis.
or we may find only entry either in invoice or delivery or vice versa.

there are around 400 TPNds which i need to mach manually. is there a way to do this in macro.

I have attached the sample file for referece.. even this cannot be done through a macro, any ideas or suggestion are appreciated.

thanks in advance
Arvind

Hi
Check the output of macro in col K, L, M and N and see if it helps in your analysis.
Ravi

Hi,

Thanks and sorry for the delay in response.. I wanted to get all the entire values from the delivery. So I Added a column to both the sheets, and concanated the TPN,& Qty with the below function
TPN&Qty& char(Countif($A$1:A1,A1)+64, which convers all the values to unique like
3960640A
3960640B
3960640C etc...
I have given the same forumula in both the sheets and used a vlookup.

Thanks a lot for your help, I will use macro function which you have provided for one of my analysis.

Regards
Arvind.