RENUPKG1973
New member
- Joined
- Sep 29, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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.
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.