Results 1 to 2 of 2

Thread: How to compare 2 worksheets datas on a sheet?

  1. #1

    How to compare 2 worksheets datas on a sheet?

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Excel Version
    it can be possible by using Pivot.
    pl find attachment. where you get 3 Sheet i.e,

    Data Merge Sheet- Data Merge according to month.
    PIVOT Sheet-Create Pivot Report, Source sheet Data Merge.
    Repot Summery Sheet-As per your summery sheet. Copy the data from pivot and arrange accordingly.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts