How to compare 2 sheets data on a single sheet through VBA Codes?

I have 2 sheets in a file.One sheet is Current and other sheet is previous.Most of the 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 Current sheet from previous month.
Now,I want 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 sheet i.e.summary or not repeat. ( Column B to D )
2-Sum up automatic total Qty and amount as per Sheet of a part code ( Column E and G for Current and Column H and J for Previous ).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 from VBA Codes or MACRO Working?

Please refer the attach file for more clarification.

This will help in limit way.The reason is:-

1-How will come Unique part codes from current and Previous sheets on summary sheet automatically?
2-Grand total is not match with current and previous sheet.Refer your attach file and cell no.G2 and J2 on summary sheet.

At present,I have no any macro related to this query. In current scenario,I am doing in excel work to find the summary result.That is more time consuming and sometimes not accurate result.I am trying to find the VBA codes sotaht give accurate working and less time consume.

Thanks and Regards.

By mistake,earlier sent was marked as Solved.But,some working was missing,found later.Try to sent again for fresh.

Can anyone provide me the VBA codes of my query?

Thanks in advance for awesome efforts.

Pradeep,

I started writing a solution for you and finished testing, but that was before I saw the posts from AB33. If you had some original code you have have posted a copy as opposed to me writing he whole thing from scratch.

For this time I am willing to accept that it was not intentional.

Please check the attached workbook. Worksheet summary_original was your version and worksheet summary was generated by the code

Thank you for providing the awesome result.Excellent Solution.Glad to find it.

Thanks and Regards

PRADEEPB270

Many members here(inclunding me) have offer to you many solutions in many of your threads, BUT:

Posting duplicates threads seems that you don't respect the efford amd the time of all these members.

Beside of this is against the forum rules.

I have warning you again to don't post duplicates threads. You continue to do this.

Sorry for saying this but unfortunately this is my LAST warning.

Stop to post duplicate threads or else adding infractions to your record you will be banned of the forum.

I confirm that it is deliberately intentional. There is nothing wrong asking for a different code or requesting to amend an existing code, but it is probably out right lie to say I do not have one.

"I declare that at present,I have no any macro related to this query.

If anybody hurt from my post or overrule the forum mandate, I am really very sorry for that mistake.Keep in mind in future posts.

If anybody hurt from my post or overrule the forum mandate, I am really very sorry for that mistake. I will keep in mind in future posts.


Regards