How to Compare 2 sheets datas on a single sheet in very quickly

[PRADEEPB270]

I have 2 sheets in a file.One sheet is GLR-Sep and other sheet is GLR-Aug.Most of the common part Code are same in both the sheets.But Qty,Rate and amount may be differ of a part code.Because,we are comparing to Sep month from Aug month.

Can we prepare a summary sheet which shows the result as below:-

1-Place automatic all the part codes,part name and unit,having in both sheets in a single or not repeat. ( Column B to D )
2-Place automatic total Qty and amount as per Sheet of a part code ( Column E and G for Sep and Column H and J for Aug ).Rate is divide to amount by Qty.
3-Desired Result ( Column L to N ).Preferably descending order of the amount ( Column N ).

Can it be possible through MACRO Working or excel based formulas?

Refer the attach file for more clarification.

[Pepe Le Mokko]

Perhaps ask your friends for the macro ?

[PRADEEPB270]

They don't know about macro workings .

[AB33]

Some of your figures are copied in to summary wrongly, hence you will see a difference in some rows.
This is not a formula but a macro code.

[PRADEEPB270]

Sir,

Thanks for your awesome working.This working is almost acurate and useful for me except 1- the cell no.A551 and A552 in the worksheet of Summary (2 ),which are not appearing in your solution 2-one part code is repeating twice or more..Please look on that part codes.
For more clarification please refe the Attach file ( Revised BOM File )

[AB33]

Pradeep Kumar Gupta,
I have got more than I bargain for. At the outset, I did not anticipate it took me a couple of hours work. I had to tied the duplicates in each sheet first before putting them in a summary.

Try it.

[PRADEEPB270]

Sir,

Many-2 thanks for your awesome efforts.Now,the complete working in our hands.Once again thanks for the painful efforts.

Regards