Recent content by Muh

Sir Thanks for your Prompt Response . Can you Please Let to Set File With This VBA Code Step by step . We Try to Add in File But not Working

Dear Sir Good day. Here attached Excel work book . We Need to track Credit invoice in Customer Signature and Seal 1.ERP Data Sheet- This Data get from Erp 2.Data Entry Sheet- There is Drop down List In Column I3- Date . Date Select Automatically Pick Concerned Date Transaction Need to Fill...

Dear Sir Greetings of the Day Kindly Check Above Query .

Very Nice Sir , But While Using This Formula There is Division It is showing as 2 times. This is because the Value is in the Same Division in both branches. We need its total. Same Like Given 2.Answer Below Table Answer Came As per the Given formula 2. Answer required Same Like Below

Hi Can anyone Write a formula

There is a data From Jan to May In Separate Sheets . We Need Answer required in "Table Sheet " 1. Answer Required Based On 2 Drop down in Column "B4" Month and Column"D4" Employee 2. there is Already Have Formula in "D6" .But this Formula Depend on Only Employee Drop down "D4" . so This...

Excel Formula Required Here Attach Data Sheet in 1st Sheet . Based On Colum "L" item Division Sales and Profit Amount Based On Employee name Item Division Only 1 time seen Under 1 Employee Sales and Profit amount Sum

Formula Not Working properly . If use Sumifs Formula then Data Sheet Sum range individually Select in Formula!!!.

1.Mentioned Formula is Not Associated Branches 2nd Screen Short. If may Wrong Data If Summary Sheet Branch Name Change 2. Data Sheet Colum-A Division name Duplication. If sum Value Required Please Can get a much Formula .

Answer Required Through Excel Formula in Sheet1 and Sheet2 Sheet 1"Summary Division" Colum B4 Drop Down Given Sheet 2"Summary Branch" Colum B4 Drop Down Given Sample Answer Give Yellow Higlighted If Drop Down List Change Then Concerned Branch Or Division Sales And Profit Data Pick From Data...

Thanks Really Appreciate

Not Worked After Re-Open .Can Let me Step by step the Process. Code added- ThisWorkbook File Format -macro-enabled file (.xlsm). Can Let me Step by step the Process.

Created a New VBA Excel File .Code Added In This File . But After Closing And Re-open Time This Code Features Not Affect In Excel File . also File Saved This Format "Excel Macro-Enabled Workbook (*.Xlsm) ". But Not Work Re-open Time. Need While This Worksheet Open Time Automatically Code...

Thanks

Dear Experts Kindly Create a Excel Formula In Given Answer table For Customer Ageing report. 1.1st Sheet Outstanding Bills of a customer dealing with a different branch of a group. 2. Different Branches are Dealing With Same Customer 3. Sample Answer...